ARMED - ARM resource dependency graph inside VSCode

I think the title sums it up, I have published a new version of ARMED the arm helper extension for...

Register for Red Gate’s SQL in the City

Aunt Kathi. Grant Fritchey. Steve Jones. They’re part of five hours of training on SQL Server performance and DevOps with...

SSMS Updates in 17.4

SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You...

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)

(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...

GroupBy Slides and Demo Script is Now On GitHub

The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository
https://github.com/SQLUndercover/UndercoverToolbox/tree/master/GroupBy
Many thanks again for watching,...

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