Finding the Primary Replica of an Availability Group

This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover's search terms. How do I find an availability group's primary server? A while back, Adrian put together a bunch of queries for Always On Availability Groups, 7 ways... Continue Reading →

Oct 24, 2019 1

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

Now I'm all for making my life easier and one thing that makes life easier for me is having a single process that I can run to install\update all my favourite utility stored procedures quickly and on all my SQL Servers. I've done this a few different ways in the past but this time I... Continue Reading →

Nov 27, 2017 10