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

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 content, and more! ]]

Using Cloud Academy

The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using...