How To Get Fired from an ETL Developer Job

Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...

Speaking at SQL Saturday Rochester this weekend!

I’ll be presenting my session Easing into Scripting with Windows PowerShell this Saturday, May 16th at SQL Saturday Rochester.
SQL Saturday is a free, all-day event for learning about SQL Server and...

Getting Database Properties – DatabasePropertyEx()

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

Stairway to Virtualization Level 2 up at SQL Server Central

Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on...

Speaking at 24 Hours of PASS

I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...

Database Growth

Last week I got into a conversation with a colleague about how SQL Server grows the database.  We were both fairly...

Powershell for SSRS in SharePoint: Multiple data sources and shared datasets

I thought that I would leave any further attempts to improve my Powershell script that was used to deploy SSRS...

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a...

Putting Your Head in the Clouds - Microsoft Azure

By David Postlethwaite

Microsoft Azure

Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in...

Excel in T-SQL Part 2 – The Normal Distribution (NORM.DIST) Density Functions

Today’s blog will be the second in a multi-part series on replicating Excel functions in T-SQL, continuing with Excel’s NORM.DIST...