SQLUndercover
@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
You might like
What's better, loads of values in an IN clause or semi-joining in a temp table sqlundercover.com/2024/12/04/exp… #sql #sqlsserver
sqlundercover.com
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…
Announcing SQL Server 2025. Read all about it at linkedin.com/posts/bobwardm… #sqlserver2025 #sqlserver #sqlai
Has your crazy IN clause just blown SQL Server's mind?! #sql #sqlserver sqlundercover.com/2024/10/30/the…
Rebuilding a SQL Server Database Transaction Log sqlundercover.com/2024/09/26/reb… #sql #sqlserver
sqlundercover.com
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…
Backup SQL Server to AWS S3 Bucket (2022 Update) – SQL Undercover #sqlserver #sql #sqlundercover
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
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/lat…
Query Store keep switching off? #sql #sqlserver sqlundercover.com/2024/07/04/que…
sqlundercover.com
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…
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/und… #sql #sqlserver #undercovercatalogue
An updated version of our sp_snapshot with more options and flexibility #sqlserver #SQL sqlundercover.com/2024/02/01/sp_…
sqlundercover.com/2023/11/27/wri… #SQL #sqlserver #azure When your SQL backup to Azure blob store fails because it's hot the block limit
sqlundercover.com
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…
The first in our series of posts looking to how to start out pen testing your SQL Server sqlundercover.com/2023/09/26/pen… #sqlserver #sql
sqlundercover.com
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…
Finding a History of Database Snapshots, Taken and Restored sqlundercover.com/2023/08/14/fin… #sql #sqlserver
sqlundercover.com
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…
Is xp_cmdshell really a security issue? #sql #selserver sqlundercover.com/2023/04/12/ive…
Using SQL Alerts to Spot Suspicious Activity in SQL @sql @sqlserver sqlundercover.com/2023/03/29/usi…
sqlundercover.com
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…
Encryption, Comparing your Options in SQL Server #sqlserver sqlundercover.com/2023/01/17/enc…
United States Trends
- 1. Vanity Fair 30.9K posts
- 2. Susie Wiles 74K posts
- 3. Mick Foley 24K posts
- 4. Raphinha 38.8K posts
- 5. Disclosure Day 15.6K posts
- 6. Spielberg 21.4K posts
- 7. Brad Johnson N/A
- 8. Michelea Ponce 9,554 posts
- 9. Bellingham 25.9K posts
- 10. Palmer 35.7K posts
- 11. langdon 2,495 posts
- 12. My Fellow Americans 1,803 posts
- 13. Alan Jackson N/A
- 14. Doug Williams N/A
- 15. Unemployment 56.3K posts
- 16. CSC Academic All-District N/A
- 17. Larian 6,090 posts
- 18. Chief of Staff 44.9K posts
- 19. Allen Lazard 1,245 posts
- 20. Emily Blunt 5,706 posts
Something went wrong.
Something went wrong.