Randolf Geist Dynamic Sampling (I), an Introduction – Part 2 If you follow me on my blog you might wonder if I let you get away without an actual test... 08 February 2012 8 min read
Steve Harville Migrating databases to new storage This was a last minute request to move five databases on two servers from an old failing storage system to... 06 February 2012 2 min read
Phil Factor Automated Script-generation with Powershell and SMO In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases,... 03 February 2012 24 min read
Dave Green Using SQL Test Database Unit Testing with TeamCity Continuous Integration With database applications, the process of test and integration can be frustratingly slow because so much of it is based... 02 February 2012 22 min read
Robert Sheldon Converting String Data to XML and XML to String Data We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server,... 01 February 2012 18 min read
Randolf Geist Dynamic Sampling (I), an Introduction – Part 1 Welcome to my first post on AllThingsOracle.com! This is the initial part of a series highlighting different aspects of “Dynamic Sampling”.... 30 January 2012 7 min read
Brad McGehee How to Document and Configure SQL Server Instance Settings Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why?... 30 January 2012 74 min read
Rob Garrison What’s the Point of Using VARCHAR(n) Anymore? The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the... 30 January 2012 11 min read
Alex Nuijten Comparing Schemas: Red Gate Schema Compare for Oracle This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use... 26 January 2012 2 min read
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