Migrating From Hipchat To Slack

Last Minute Migration?
If you are about to perform a last minute migration here's a couple tips as you jump ship from Hipchat and move to Slack. Hipchat is sunsetting...

Optimizing for Ad Hoc Workloads

Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...

SQL Server Database Experimentation Assistant - How to Run a Capture

DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...

Automating T-SQL for Azure SQL Database via Logic Apps

Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...

Azure Data Factory integration with GitHub

(2019-Feb-06) Working with Azure Data Factory (ADF) enables me to build and monitor my Extract Transform Load (ETL) workflows in Azure....

Bad indexing can show up in wait statistics

At first, this statement might sound a bit confusing. Usually, we expect wait statistics to show us what a query...

CLR Strict Security in SQL 2017

Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...

Join me for the PASS Data Expert Series Feb 7

I’m honored to have one of my PASS Summit sessions chosen to be part of the PASS Data Expert Series...

Midlands PASS Meeting for April 2019

The Midlands PASS April 2019 meeting will be held on April 2nd and we’ll be welcoming Matt Gordon (twitter | website)!
Meeting...

SQL server connection and blocking finding script

SQL server connection and blocking finding script...

[[ This is a content summary only. Visit my website for full links, other...