Exploring Excel 2013 for BI Tip #8: Adding Calculated Measures

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Natural Born Killers (The series) – Day 1 Statistics

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

Natural Born Killers (The series) – Day 4 Indices

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

SQL Server Running Slow

A user calls to say the app or server is slow today.  Here’s a quick summary of how I get...

TechEd North America 2013 videos online

Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free!  What a...

TRY, CATCH, and Transactions

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...

use Table Variables in transaction

when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL

Because table variables...

Das Keyboard - First Thoughts

There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...

Dealing with Auditors: Password Settings

Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...

Natural Born Killers (The series) – Day 3 Scalar UDF’s

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...