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
120 reads
It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...
2019-02-07
282 reads
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...
2019-02-04
119 reads
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
170 reads
Inspector V1.3 is now available on GitHub.
We have updated the sample report for you to play with which includes the...
2019-01-15
141 reads
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,030 reads
Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the...
2018-12-31
230 reads
There are times when we need to compare two tables and figure out if the data matches. I often see...
2018-12-31 (first published: 2018-12-18)
3,086 reads
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,246 reads
For some reason I have always written my Case statements using the following logic:
SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...
2018-12-12 (first published: 2018-11-28)
2,788 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers