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...

Cumulative Update – 3 for SQL Server 2012 Service Pack 1 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 3 contains all the...

TRY_CONVERT broken by WITH SCHEMABINDING in SQL Server 2012 Data Tools build

Here's a bug you might find if attempting to schemabind an object that uses the new TRY_CONVERT function.

To reproduce, run...

PowerPoint–My Dashboard and Report Design Tool

At some point I think that I am becoming a Microsoft Office specialist as opposed to a BI Architect.  All...

New SQLTreeo Version

We are glad to announce that new SQLTreeo SSMS Add-In was published.
List of new features/enhancements are following:
Local storage support...