Achievement Unlocked: 24 Hours of Pass Session Submitted

I have finally submitted a session for a speaking engagement. Those who know me know that this is a very...

Getting Under The Hood

Whenever a piece of software does something that makes me think this is awesome I find myself blocking out the...

Planning a High Availability and Disaster Recovery Plan in Madison, WI

I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster...

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...

Measuring My Career

I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.
I saw Brent...

How to resequence column based on numeric prefix using TSQL

Beginning in version 2005, SQL Server is making manipulation of  partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...

SQL Server 2014 Deprecated Features

SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL...

Stupid T-SQL Tricks – Part 2: Retrieving Columns Set to the Current DEFAULT CONSTRAINT Value

“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show
If you’re old enough to remember the Tonight Show hosted...