Patrick Barel Invoker Rights Part 2 Kindness is the beginning of cruelty Frank Herbert Syntax If you check the syntax for the different program objects you... 25 January 2012 4 min read
Syed Jaffar Hussain An Easy Way to Obtain 10053 Trace I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that... 23 January 2012 1 min read
Phil Factor Confessions of a DBA: My worst mistake Over the next few months, we'll be asking various well-known DBAs to describe their worst disaster caused by a mistake... 23 January 2012 6 min read
Michelle Malcher DBA Monitoring Top Five Have you ever just sat there watching all of the processes running against the database, just waiting for something to... 19 January 2012 6 min read
Grant Fritchey SQL Cop Review Static code analysis is used a lot by application programmers, but there have been surprisingly few tools for SQL development... 19 January 2012 7 min read
Jonathan Kehayias Great SQL Server Debates: Buffer Cache Hit Ratio One of the more popular counters used by DBAs to monitor the performance, the Buffer Cache Hit Ratio, is useless... 18 January 2012 15 min read
Roel Hartman Wouldn’t you like to talk to your APEX app? You may be familiar with Martin Giffy D’Souza’s blog talkapex.com (if you’re not, check it out – it’s really worthwhile).... 17 January 2012 1 min read
Robert Young Relational Databases and Solid State Memory: An Opportunity Squandered? The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully... 17 January 2012 6 min read
David Njoku Introduction to Materialized Views: Query Rewrite In the fairy tale, The Shoemaker and The Elves, a poor cobbler works to the best of his ability; and... 10 January 2012 5 min read
Alex Kuznetsov Close Those Loopholes: Lessons learned from Unit Testing T-SQL Alex has done some pioneering work on the testing of stored procedures over four years, and has learned a great... 09 January 2012 23 min read
Gert Poel Using a database link with heterogeneous services in APEX Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The... 05 January 2012 1 min read
Fabiano Amorim Window Functions in SQL Server: Part 3: Questions of Performance A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do... 04 January 2012 12 min read
Robert Sheldon Incorporating XML into your Database Objects XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check... 04 January 2012 14 min read
Cary Millsap The Ramp I love stories about performance problems. Recently, my friend Debra Lilley sent me this one: I went to see a... 20 December 2011 2 min read
Martin Giffy DSouza Expert Oracle Application Express Plugins One of the most anticipated new features that was introduced in APEX 4.0 was the ability to create your own... 15 December 2011 2 min read
Sam Bendayan Constraints and the Test-Driven Database Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a... 14 December 2011 13 min read
Feodor Georgiev Administrating SQL Server Integration Services – Planning, Documenting and Troubleshooting SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and... 12 December 2011 15 min read
Jonathan Kehayias Great SQL Server Debates: Lock Pages in Memory There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL... 12 December 2011 19 min read
Jeff Smith Simple Bar Chart Reports with SQL Developer There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was... 09 December 2011 2 min read
Patrick Barel Invoker Rights Part 1 Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for... 08 December 2011 4 min read
