Comparing Agent Jobs across Availability Group Replicas with PowerShell

On the plane home from PAS Summit I was sat next to someone who had also attended and when he...

Query to determine mirrored database status

I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...

Launching SQL Server on Linux in Single User Mode

There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL Server on Linux in Single User Mode. Well you’ve...

Launching SQL Server on Linux in Single User Mode

There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL...

How to be a successful innovator

Let’s say you have some obscure list of career goals for the year and one of those is to be...

Using Plaster To Create a New PowerShell Module

Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week

Tracey Boggiano T | B came along to our...

How to Upgrade an AG Cluster to Windows 2016

Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016.  The best...

How to Upgrade an AG Cluster to Windows 2016

Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016.  The best...

Things I Learned from Speaker Idol 2017 at the SQL PASS Summit

I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching...

SQL Server 2017 – Interleaved Execution

I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...