Caution about Restoring via SSMS v17
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.
2018-11-06
1,618 reads
Warren Campbell
Automated Rapid Recovery during Database Code Releases using Snapshots
Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code
2015-12-08
2,043 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
11,425 reads
Automatically Scripting Out Permissions for Cross Environment Restores
This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.
2011-12-05
5,305 reads
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