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,805 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,112 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
12,760 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,289 reads
Blogs
Resources for Architecting Zero Downtime Deployments
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Daily Coping 23 Mar 2023
By Steve Jones
Today’s coping tip is to focus your attention on the good things you take...
SQL Bits 2023 Recap
By DataOnWheels
I had an amazing time adventuring to Wales with other members of the data...
Forums
Best way to ETL on large tablle with columnstore index
I have a table with 489M rows and growing. The reason we had to...
Unable To Create Transactional Replication - Microsoft SQL Error 20026
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Grouping the first letter in a string
Hi All, I have the column of data in SQL Server. Here I need...
Ask SSC