Unzip Files with SSIS

In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write...

An interview with me

The other day I received an email asking for some help with a school project. Would I please answer some...

CHECKDB and Page Restoring from SSMS

Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...

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...