Undercover Catalogue 0.3.0-Auditing and Change Tracking Comes to the Catalogue

We're pleased to announce the release of the Undercover Catalogue 0.3.0. You can grab it from our GitHub page... https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue Installing and Upgrading Full installation and upgrade instructions can be found on the main Catalogue page, https://sqlundercover.com/undercover-catalogue-0-2/ v0.3.0 Brings Auditing to the Catalogue The biggest change that we've introduced to the Catalogue is auditing. All... Continue Reading →

Aug 27, 2019 0

Undercover Catalogue 0.2 Hox Fix 2 to Fix Breaking Changes with dbatools 1.0.0 & SQL2008r2/2008 Compatibility Patch RELEASED

Some breaking changes were introduced with dbatools 1.0.0, please make sure that you've got the latest version of hotfix 2 installed as well as the lastest Interrogation script runningThe minimum version of dbatools that we now support is 1.0.0 Undercover Catalogue 0.2.2 It looks like a bug has crept it's way into the Undercover Catalogue.... Continue Reading →

Jun 20, 2019 0

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 a little green tick and no data loss reported... Or maybe you've checked out sys.dm_hadr_database_replica_cluster_states and 'is_failover_ready' is reporting a 1. So, you're cool to failover,... Continue Reading →

Apr 29, 2019 1

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 datatypes were having their size recorded as the data length rather than character count in the 'Tables' module. Another issue affected any MAX datatypes which were having their length mis-recorded. Version 0.2.1 fixes both... Continue Reading →

Feb 14, 2019 0

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 with it a number of new modules as well as the thing that we're most excited about, a Power Bi dashboard to make keeping track of your SQL Server estate even easier. Power BI... Continue Reading →

Feb 4, 2019 2

Managing Logins and Users Across An Availability Group

What's the deal with logins and availability groups? I'm sure that we all, when creating a login that accesses a database that happens to be part of an availability group, diligently go and create that login on all secondary replicas, don't we?! Of course, when that AG fails over to another replica, we want to... Continue Reading →

Dec 5, 2018 1

Undercover Catalogue 0.1 Released

Easily Keep Track of All Your SQL Servers We know what it's like when you've got 101 SQL Servers to manage, or even just a couple. It can be almost impossible to keep track of all these servers, their versions, the databases that they host, permissions, dependencies... the list goes on. We developed the Undercover... Continue Reading →

Aug 28, 2018 2

A Quick Look At The All New Undercover Catalogue, Preview Release Due Out Soon…

I thought I'd give you all a little preview of our latest offering, the Undercover Catalogue which should be available in Preview version very soon. So what actually is it? The Undercover Catalogue will help you to build up a picture of your entire SQL infrastructure. It'll go out, discover and interrogate all of your... Continue Reading →

Aug 6, 2018 0