Grant Fritchey Why is that SQL Server Instance under stress? There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these... 11 September 2012 14 min read
Dave Green Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the... 11 September 2012 12 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 1: Introduction From time to time you’ll have to represent your data stored in a database in an XML format, eg. to... 05 September 2012 5 min read
Patrick Barel Checking for NULL with Oracle SQL The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert... 30 August 2012 7 min read
Phil Factor Registered Servers and Central Management Server Stores SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered... 28 August 2012 14 min read
Robert Sheldon Report Builder 3.0: Creating a Basic Report Report Builder is underrated as a BI and report-authoring tool. It is a free stand-alone application from Microsoft that provides... 24 August 2012 18 min read
Greg Lucas Test-driven Database Development – Why tSQLt? Test-Driven Development (TDD) has a good track record in application development, but is less well-established in database development work. This... 21 August 2012 16 min read
Gail Shaw Gail Shaw’s SQL Server Howlers For the latest in our series of SQL Server Howlers, we asked Gail Shaw which common SQL Server mistakes and... 14 August 2012 22 min read
Glenn Berry Provisioning a New SQL Server Instance – Part Two So how should you install and configure SQL Server 2012 properly? Glenn Berry completes his two-part series by explaining the... 13 August 2012 11 min read
Michael Sorens Practical PowerShell for SQL Server Developers and DBAs – Part 2 Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating... 09 August 2012 24 min read
Annette Allen SSIS Basics: Introducing Variables In the third of her SSIS Basics articles, Annette Allen shows you how to use Variables in your SSIS Packages,... 08 August 2012 20 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part 1 Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases.... 07 August 2012 8 min read
Randolf Geist Oracle Cost-Based Optimizer Advanced This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August... 02 August 2012 2 min read
Dave Ballantyne Cleaning Up SQL Server Deployment Scripts Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema... 02 August 2012 22 min read
Randolf Geist Incremental Partition Statistics Review Here is a summary of the findings while evaluating Incremental Partition Statistics that have been introduced in Oracle 11g. The... 01 August 2012 2 min read
Doug Burns Statistics on Partitioned Tables When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and... 01 August 2012 1 min read
Grant Fritchey The Seven Sins against TSQL Performance There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally... 31 July 2012 15 min read
Richard Morris Database Continuous Integration with Bamboo We were so interested in Atlassian's Bamboo, and it's role in Continuous Integration, that we wanted to find out more,... 26 July 2012 15 min read
Michael Sorens Practical PowerShell for SQL Server Developers and DBAs – Part 1 There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS... 23 July 2012 16 min read
Phil Factor PowerShell SMO: Just Writing Things Once Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in... 19 July 2012 26 min read