@SQL_Undercover

David Fowler and Adrian Buckman, two database nerds who love nothing more than to spend their time, reading about, researching and sharing all things SQL Server

 South East, England
sqlundercover.com
Joined June 2017
  • Tweets643
  • Following122
  • Followers248
191Media
What's better, loads of values in an IN clause or semi-joining in a temp table sqlundercover.com/2024/12/04… #sql #sqlsserver

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

This post comes off the back of my last, where I looked at issues caused by explicitly declaring a large number of values in an IN clause. The query processor ran out of internal resources and coul…

sqlundercover.com
21
SQLUndercover retweeted
Bob Ward@bobwardms19 Nov 2024
Announcing SQL Server 2025. Read all about it at linkedin.com/posts/bobwardms… #sqlserver2025 #sqlserver #sqlai
3
41
9
89
7,482
Has your crazy IN clause just blown SQL Server's mind?! #sql #sqlserver sqlundercover.com/2024/10/30…

The query processor ran out of internal resources and could not produce a query plan – When You’ve...

Recently I received a cry for help over Teams. The issue was that an application was throwing up the following SQL error, The query processor ran out of internal resources and could not produce a q…

sqlundercover.com
26
Rebuilding a SQL Server Database Transaction Log sqlundercover.com/2024/09/26… #sql #sqlserver

Rebuilding a SQL Server Database Transaction Log

“Could you help me, we deleted the database’s transaction log file and now that database is stuck in ‘Recovery Pending’?” This was a panicked call that I received a fe…

sqlundercover.com
18
Backup SQL Server to AWS S3 Bucket (2022 Update) – SQL Undercover #sqlserver #sql #sqlundercover
41
Some exciting things in development for our Undercover Catalogue. A big change coming soon with version 0.5.0 then will come version 1.0.0 where things start getting very exciting. #sql #sqlserver #sqlundercover #excitingdevelopment
34
It's been quiet for a while but this little update is the first of a very exciting spell of development they we've got planned for the Undercover Catalogue. #sqlserver #sql #excitingtimearecoming sqlundercover.com/2024/07/22…

Latest Update for Undercover Catalogue Powershell Interrogation Script

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 aut…

sqlundercover.com
1
22
sqlundercover.com/2024/07/17… #sqlserver #sql

Are Your Secondary Availability Group Read Only Replicas Falling Behind? Are You Seeing PARALLEL_...

Are you struggling with a laggy redo and a build up in the redo queue on your readonly secondaries? Are you suffering with high PARALLEL_REDO_TRAN_TURN waits? Then this magic remedy could cure your…

sqlundercover.com
1
29
Query Store keep switching off? #sql #sqlserver sqlundercover.com/2024/07/04…

Query Store Keeps Switching Itself Off, Getting it Moving Again

I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues and I know that I…

sqlundercover.com
1
18
#sql #sqlserver sqlundercover.com/2024/06/06…

Export Extended Event Results to CSV or Table

This is something that I’ve seen pop up a couple of times on various forums recently, how can we export the results of an XEvent session. So I thought I’d answer the question here. It&#…

sqlundercover.com
1
23
It's been a long while since the last update but the Undercover Catalogue 0.4.4 update is now out. A new 'Database Snapshots' module, last accessed date added to Databases and a new Powershell Interrogation script, sqlundercover.com/2024/04/16… #sql #sqlserver #undercovercatalogue

Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module

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…

sqlundercover.com
37
sqlundercover.com/2024/04/02… #sqlserver #sql #mssql

When was my SQL Server Database Last Accessed?

Your boss walks up to you one morning and says, “Hey, I wanna list of all of our databases and when they were last accessed”. If you’ve got some sort of auditing switched on or a …

sqlundercover.com
33
An updated version of our sp_snapshot with more options and flexibility #sqlserver #SQL sqlundercover.com/2024/02/01…

sp_snapshot – The easy way to take database snapshots of one or more databases – Version 2.0

This post refers to an older version of this procedure.  Please see HERE for the latest version. Presenting you with an updated version of our sp_snapshot procedure, to easily create database snaps…

sqlundercover.com
1
45
sqlundercover.com/2023/11/27… #SQL #sqlserver #azure When your SQL backup to Azure blob store fails because it's hot the block limit

Write to backup block blob device failed. Device has reached its limit of allowed blocks.

Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device failed. Dev…

sqlundercover.com
37
The first in our series of posts looking to how to start out pen testing your SQL Server sqlundercover.com/2023/09/26… #sqlserver #sql

Penetration Testing your SQL Server, Part 1 – The Recon Mission

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are? Penetration testing is a great…

sqlundercover.com
50
Finding a History of Database Snapshots, Taken and Restored sqlundercover.com/2023/08/14… #sql #sqlserver

Finding a History of Database Snapshots, Taken and Restored

All code in this post can be found in our GitHub repo This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we…

sqlundercover.com
35
sqlundercover.com/2023/08/14… #SQL #sqlserver

Finding a History of Database Snapshots, Taken and Restored

All code in this post can be found in our GitHub repo This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we…

sqlundercover.com
33
Is xp_cmdshell really a security issue? #sql #selserver sqlundercover.com/2023/04/12…

I’ve Got 99 Problems But xp_cmdshell Ain’t One

xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within SQL. Sound scary? It might, but is xp_cmdshell really a security risk? Well a lot of …

sqlundercover.com
1
41
Using SQL Alerts to Spot Suspicious Activity in SQL @sql @sqlserver sqlundercover.com/2023/03/29…

Using SQL Alerts to Spot Suspicious Activity in SQL

SQL doesn’t really give us too many tools out of the box to allow us to spot when someone may be up to no good. We can look at the number of failed login attempts in SQL’s error log. If…

sqlundercover.com
1
31
Encryption, Comparing your Options in SQL Server #sqlserver sqlundercover.com/2023/01/17…

Encryption, Comparing your Options in SQL Server

The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL can encrypt our data at a number of dif…

sqlundercover.com
31
Load more