SQL in the City 2017

Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...

Interviewed

I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions...

UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.

From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...

Come to SQL Saturday Providence!

Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.

I will be presenting by SQL Server Health Check session first thing...

Live on Channel 9 with ReadyRoll

I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some...

Kalen Delaney’s Weekly Webinars

Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...

My Second Pester Test

I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I...

Moving to an Azure SQL Database via Command Line

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...

How to Update @@SERVERNAME to Actual Machine Name?

The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...

An Open Letter to the SQL Community: Regarding Speakers

(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...