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

Madison SQL Saturday (#SQLSat206) Coming Up

It’s coming up in just a couple weeks… the SQL Saturday in Madison, Wisconsin.  On April 6th, a couple hundred...

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

The Axis Of Evil

Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be...