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

Index Tuning

This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments.  Using...

SQL in Chicago

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

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

SQL Server Development Permissions

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

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

Consuming News Through Social Media and Read It Later With Pocket

These days the fastest way, not always the most accurate, to get news is through social media.  Technology, sports, politics,...

How I used Data Explorer to create a demo

Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...

How To Be An Expert At What You Do

Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them...

Laws You Break at Your Peril

Laws of Thermodynamics
TANSTAAFL
Gods of the Copybook Headings
All magic comes with a price
Winter Is Coming
My adult years started with a pretty...