Overcoming the OPENQUERY Record Limit for AD
Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.
2014-11-13
5,789 reads
Steven Burns
Blogs
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup...
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Maintenance Window for SQL Server Critical Alerts
Hello, We had some sql server have issues on some production servers. We actually...
Capturing all Error messages caused by SQL Server code
Hello - The ERROR_MESSAGE() is capturing only the last message in the error stack...
Ask SSC