Changing the version of an SSIS package.

Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...

The Wait Is Over – SSIS 2017 Is Here!

UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...

Azure SQL Database – Scaling up

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...

Microsoft Azure – How to get details about azure locations using PowerShell

Hello friends, when we create any virtual machine using management portal we need to select the location for cloud service...

Docker images for custom SQL Server Installations

I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...

How to Search and Destroy Non-SARGable Queries on Your Server

Unexpected SQL Server Performance Killers #3

Watch this week's video on YouTube
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled...

Runtime Metrics In Execution Plans

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...

Runtime Metrics In Execution Plans

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...

SQL Puzzle 3: Knights and Queens

I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...

SQL Saturday Charlotte (#683)

I am so excited to be helping out with SQL Saturday Charlotte again this year.  This is the 6th year...