Full documentation on the Undercover Catalogue can be found HERE We've spotted a bug in the Databases module where an unprintable ASCII character was being inserted at the beginning of the file paths. This has caused a few problems when generating reports on that field. This is was likely only a problem if you don't use... Continue Reading →
We've been hearing of a few people getting errors from the latest Undercover Catalogue, Powershell interrogation script. The issue seems to be happening when the scripts tries downloading automatic updates and online module definitions when running the script with older versions of Powershell. A new version of the script has now been uploaded to our... Continue Reading →
Full documentation on the Undercover Catalogue can be found HERE It's been a while since the Undercover Catalogue last received an update but having had a few of those moments recently when I thought to myself 'I really wish I was capturing that data', so I decided to roll a few changes into the Catalogue.... Continue Reading →
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix - LocalInterrogation There was an issue with the LocalInterrogation stored proc not updating the execution log, this has now been fixed. Undercover Inspector Updates we forgot to mention from May (V2.2): Added EmailGroup column to ReportData table #216Added... Continue Reading →
Quick video showing you how to install and configure the SQL Undercover Catalogue https://www.youtube.com/watch?v=SJ5YlTGkV5o
In this video, David give a quick introduction into the Undercover Catalogue. https://www.youtube.com/watch?v=iw98wYN1R1g
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 →
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 →
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 →
SQL Undercover 