In this video, David give a quick introduction into the Undercover Catalogue. https://www.youtube.com/watch?v=iw98wYN1R1g
Introducing The Undercover Catalogue
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git Hub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/CatagoryControlledAgentJobs.sql Agent jobs, they can be a right pain to manage when you're running availability groups. The problem is that they're just not AG aware, this means that if you failover our AG, more often than not you're going... Continue Reading →
Undercover Catalogue 0.4.0 Released
We're pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of new features and enhancements. Centralisation The on of the main focuses of 0.4 is centralisation. The first major change that 0.4.0 brings is centralisation. With previous... Continue Reading →
Happy New Year – Our Top Posts of 2019
With the New Year fast approaching and maybe already having arrived depending on where you are, we thought we'd do a quick recap of our top 5 posts from 2019. Using Indexing to Solve Blocking and Deadlocking Issues Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary Why... Continue Reading →
A Merry Christmas and a Happy New Year from us here at SQL Undercover 🙂
Inspector V2.00 now available
The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The latest powerBI template can be found here.As more features are documented they will be updated on the Inspector V2 page. New Features Schedule report windows and... Continue Reading →
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 →
Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary
If you're running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that you could do that, you could use read only routing or simply just point those reports directly at a read only secondary (read only routing is... Continue Reading →
Undercover TV Podcast – Intent Locks
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is. https://www.youtube.com/watch?v=44vNrHJR984
