Everything you care about in one place
Follow feeds: blogs, news, RSS and more. An effortless way to read and digest content of your choice.
Get Feedersqlundercover.com
SQL Undercover
Get the latest updates from SQL Undercover directly as they happen.
Follow now 16 followers
Latest posts
Last updated 11 months ago
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
11 months ago
Presenting you with an updated version of our sp_snapshot procedure, allowing you...
Time to Revive our YouTube Channel
about 1 year ago
It’s been forgotten about and neglected for few years but I’ve decided...
Why Not Just Use VARCHAR(MAX)?
about 1 year ago
A while ago I was looking into some odd errors that were...
Distributed Availability Group Dashboard
over 1 year ago
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo....
SQL Server Migration Using a Distributed Availability Group
over 1 year ago
SQL Server migrations are a headache, ask anyone who’s been through the...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
almost 2 years ago
This post comes off the back of my last, where I looked...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
almost 2 years ago
Recently I received a cry for help over Teams. The issue was...
Rebuilding a SQL Server Database Transaction Log
almost 2 years ago
“Could you help me, we deleted the database’s transaction log file and...
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
almost 2 years ago
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted...
Backup SQL Server to AWS S3 Bucket (2022 Update)
about 2 years ago
Way back in the mists of time I wrote a post on...
Latest Update for Undercover Catalogue Powershell Interrogation Script
about 2 years ago
We’ve been hearing of a few people getting errors from the latest...
Are Your Secondary Availability Group Read Only Replicas Falling Behind? Are You Seeing PARALLEL_REDO_TRAN_TURN Waits?
about 2 years ago
Are you struggling with a laggy redo and a build up in...