Inspector V1.4 now available

The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project...

Is Your Availability Group ‘REALLY’ Ready To Failover?

You know what it’s like, you need to fail your AG over but is it safe to fail over? Perhaps you’ve clicked on ‘failover’ for the AG and there’s...

Using Indexing To Solve Blocking and Deadlocking Issues

A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...

#TSQL2sDay – #112 – Mini cookies

This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:

Dipping into the Cookie Jar...

TSQL Tuesday #112 – Dipping into the Cookie Jar

This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...

Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO

In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...

7 more ways to Query Always on Availability groups

Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...

Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...

ALTER TABLE Fails on Replicated Tables With Isolation Level SERIALIZABLE or READ UNCOMMITTED on SQL2012 and Earlier

It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...

Undercover Catalogue 0.2 Released

We’re pleased to announce the release of the Undercover Catalogue 0.2 and can be downloaded from https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue
The new version brings...