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,790 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,108 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
12,676 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
6,206 reads
Blogs
Speaking at SQLSaturday MN 2022
By Will Assaf
Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...
Goal Progress for Nov 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?
Very excited to take part in my third #PGSQLPhriday blogging event, even more so...
Forums
Selecting temp tables & CTEs using PowerBI
I have a pretty difficult assignment. This is the structure that I need to...
Ask SSC