April 2013 Events

April is going to be a fantastic month! I am slated to have quite a few speaking and training opportunities...

Sub query pass through

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...

We Need a Place for SQLFamily News

I’m writing this because I was thinking about a member of the local PASS chapter on the way home last...

Why I’m Considering a Surface and Windows Phone 8

Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...

Customizing SSMS – Bigger Queries

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...

SQL Server : Part 6 : Design consideration of Clustered Index

In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss...

CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from

http://support.microsoft.com/kb/2812412

Similar to CU2 there...

SQL in Chicago

Hello Dear Reader!  I've got some very exciting news!  Pragmatic Works is holding a Two Day Performance Tuning Workshop in...

A Second March ‘Index Analysis’ Update

After this month’s Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let...

SQL Server Development Permissions

After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...