Enabling Instant File Initialization

Found a couple good walkthroughs on enabling instant file initialization. However, I’m becoming more familar with the nuances of various...

Reblog - Memorial Day in US - Freedom is Never Free

Originally published May 2014:

Well, as all folks in the United States know, this weekend we celebrate Memorial Day,
Monday May...

DDL Auditing - Article on SQL Server Central

My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...

I Spoke at SQLSat (and I Liked It)

That is the first and last Katy Perry reference you will find on this blog or anywhere else in my life.
Last weekend I spoke at the 4th edition of my “home”...

DB_Owner Querying for Database Options

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Power BI with Azure SQL Database

**Information is current as of 5/21/2015**
Recently Azure SQL Database was added as a new connection to the Power BI Preview....

Why not jump in and help?

If you know me, you know it is in my nature to help.  Whether it’s helping a friend move, helping...

Creating an Azure SQL Database

By David Postlethwaite
Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL...

Advanced SSIS Training Class This Fall

Now that the details have been finalized, I can announce that a new SSIS class coming up this fall. My Linchpin...

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded...