Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL...

Creating an empty table from a SELECT statement

I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....

Help Bring #SQLFamily to Fargo, North Dakota

Did you know that a SQL Saturday in Fargo is in the works?  If not them, hey… there’s a SQL...

Lost in Translation – Deprecated System Tables – sysprotects

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

New Book: Knight’s SSIS 2012 24-Hour Trainer

I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services...

Power View for Multidimensional Models – Preview Available

Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012.  Power View can only consume data...

PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."

Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:

"Not loaded.  The Managed Add-in Loader failed...

Reblog: November 23 to November 29

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Rules of Holes #7: Some Will Look Down on You.

I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a...

Rules of Holes #7: Some Will Look Down on You.

I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and...