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

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