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

Zip Files in SSIS

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

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

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

This Week in Data – Episode 16 (Top 5 Reasons You Need a Data Warehouse)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

What is HTAP?

I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....

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

SSIS Package Validation in the Catalog

Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package....

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

T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....