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

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

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

PowerShell Usage in DBA Work – Case Study 5/7

One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc)...