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

Using Docker to run Integration Tests for dbachecks

My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...

Versions of Stored Procedures

I never knew this, but stored procedures have versions.
I was browsing the CREATE PROCEDURE doc page, and stumbled upon this...

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

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

Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime

SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the...