Connecting to a Specific Port–#SQLNewBlogger

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

Live #SQLintheCity–Behind the Scenes

Here’s a shot from our engineer, behind the scenes of my live talk today.
Tom Austin and @way0utwest live at #sqlinthecity...

Master Data Services Error – Missing Temp Directory

I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...

Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!

Release...

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...

sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released!

In this new version additional parameters are added to control what information is returned and...

Treat Yourself to a Training Christmas Present

Its the week before Christmas. Party season is in full swing. Its a time for reflection on the year gone...

Zip Files in SSIS

Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...

Presenting with SQL Server Management Studio

Short one this week as it’s the usual madness on the lead up to Xmas!
One of the cool things that...

Reminder – Geek Sync Today!

Today (December 14, 2016) at 12 PM Eastern I’m giving a webinar on preparing for your SQL Server farm for the...