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
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…
sqlundercover.com
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…
Rebuilding a SQL Server Database Transaction Log sqlundercover.com/2024/09/26/reb… #sql #sqlserver
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…
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
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/2023/11/27/wri… #SQL #sqlserver #azure When your SQL backup to Azure blob store fails because it's hot the block limit
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
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…
Encryption, Comparing your Options in SQL Server #sqlserver sqlundercover.com/2023/01/17/enc…
United States Trends
- 1. Good Tuesday 24.4K posts
- 2. White House 339K posts
- 3. #tuesdayvibe 1,503 posts
- 4. Cobie 37.4K posts
- 5. Sanae Takaichi 70K posts
- 6. Texans 39.3K posts
- 7. WE ARE PROUD OF TAEHYUNG 31.8K posts
- 8. World Series 120K posts
- 9. NBA IS BACK 8,885 posts
- 10. Blue Jays 103K posts
- 11. WE LOVE YOU TAEHYUNG 36.7K posts
- 12. East Wing 80K posts
- 13. Gucci 26.5K posts
- 14. Seahawks 38.5K posts
- 15. Nick Caley 2,801 posts
- 16. Coinbase 51.4K posts
- 17. Joe Carter 3,296 posts
- 18. Curtis 40.6K posts
- 19. Diddy 21.3K posts
- 20. Springer 71.6K posts
Something went wrong.
Something went wrong.