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 →
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 →
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 →
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 →
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 →
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 →
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 →
