Undercover Catalogue 0.2.2 It looks like a bug has crept it’s way into the Undercover Catalogue. When running with certain versions of DBA Tools, a number of the modules...
2019-06-20
8 reads
Here’s a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN....
2019-06-06
140 reads
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...
2019-05-20
19 reads
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...
2019-05-09 (first published: 2019-04-29)
848 reads
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...
2019-03-20 (first published: 2019-03-05)
2,964 reads
This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar...
2019-03-12
269 reads
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
229 reads
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
236 reads
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
204 reads
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...
2019-02-14
119 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Hi Guys I need help pivoting the following SELECT [ID],[code_name],,[retail_price] FROM products 1 |...
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Here's my data... I am trying to return total days in status for each...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers