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

Patrick Barel

ANSI SQL

if you can’t beat them, join them. Gregory Y. Titelman Since Oracle 9i, Oracle SQL supports the ANSI SQL...

18 July 2012 6 min read

Jonathan Lewis

ANSI Outer 2

A comment on a recent post of mine pointed me to a question on the OTN SQL and PL/SQL Forum where someone...

17 July 2012 1 min read

Dominic Delmolino

Hate the player, not the game — or my case for Data Engineers

Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for...

16 July 2012 4 min read

Chet Justice

Fun with OBIEE SQL

I posted a couple of tweets yesterday about this crazy query I had to work with. I won’t Storify you...

13 July 2012 2 min read

Jonathan Kehayias

Optimizing tempdb configuration with SQL Server 2012 Extended Events

One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the...

13 July 2012 20 min read