Inspector V1.3 now available
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
143 reads
Happy New Year, Here are our Most Popular Posts of 2018
Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the...
2018-12-31
233 reads
Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG
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,910 reads
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...
2018-12-26 (first published: 2018-12-05)
2,259 reads
A curious case of case when and Null values
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,810 reads
High CPU and Query Store, A Story of Spinlock Heartache
This is going to be a quick look at an issue that we recently encountered, I’m not going to go...
2018-12-04 (first published: 2018-11-20)
2,361 reads
T-SQL Tuesday – Non-SQL Server Technologies
So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...
2018-11-15 (first published: 2018-11-06)
2,157 reads
Signing Stored Procedures That Access Multiple Databases
A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Recently Manish...
2018-11-08 (first published: 2018-10-30)
2,554 reads
Identifying delays between SQL calls using SQL profiler
One of the common goto methods for query specific slowness which can be replicated via an application can be to...
2018-11-05 (first published: 2018-10-24)
2,201 reads
A Play Around With Table Variable Deferred Compilation in SQL 2019
Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...
2018-10-25 (first published: 2018-10-16)
2,075 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers