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,680 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,066 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
11,834 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,531 reads
Blogs
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just...
My T-SQL Tuesday #129 Time Capsule
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
Azure Database Administrator
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Forums
Time out expired on the application side
Hi I have an application that is timing out i run the query...
Sum function in CTE is not calculating the right balance
I have table with all charges and payment the charges are 'c' and payments...
Attacks on Unsecured Databases
Comments posted to this topic are about the item Attacks on Unsecured Databases
Ask SSC