When the buffer pool isn’t just in memory

Last time we looked at the four major components of a computer system, and then looked at the SQL Server...

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

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

Using Cloud Academy

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

What is Azure Key Vault?

Keys and secrets (AKA passwords)  are an essential part of data protection management not only on-premises, but within the cloud...

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

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

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! ]]

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

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