Category Archives: Uncategorized

Departure of a SQL Server Administrator – What to Check?

A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading

Posted in Uncategorized | Tagged , , , , , | 1 Comment

Upgrading SQL Server using Availability Groups – Checklist

This is a checklist put together and followed for an upgrade of a pair of physical SQL Server 2012 servers which hosted a single availability group of several terabytes of data with minimal downtime. The availability group was configured with … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 3 Comments

SQL Server Configuration on Windows Server Core Edition

You can’t run SQL Server Configuration Manager on a Windows Core server – no UI. You can’t run SQL Server Configuration Manager on another server and direct it to point to your server running Windows Core. But what you can … Continue reading

Posted in Uncategorized | Tagged , | 2 Comments

Postcode Data and the Geography of a Drunkard’s Walk in SQL Server

I was thinking about postcode data, as it might come in handy for some reporting / planning / analysis work later. There’s a set of scripts to create tables and populate with postcode data in SQL Server, which was my … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Wrapping up CPU Load Graphs into a Stored Procedure

After the fun of the last few days, I thought it might be a better idea if I wrapped this all up into a single stored procedure. So I did that. Parameters I have implemented the following parameters: @ShowCPUAsLines (BIT, … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

CPU Load Graphs & Deadlocks 2 – Tweaks

Following on from the earlier post CPU Load Graphs and Deadlocks Bug fix Oops. Of course, I wasn’t expecting this system to have multiple deadlocks in the same minute, but, if you do have that situation and you use the … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

CPU Load Graphs with Deadlocks

Continuing on disappearing down the rabbit hole… Send help! Or coffee! Deadlocks I’m always being asked, sometimes being asked, somebody asked me once “what about the deadlocks? Can you show them on your CPU load graphs?” Oh, go on. First, … Continue reading

Posted in Uncategorized | Tagged , , , , , | 1 Comment