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,633 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,046 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
11,550 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,385 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Txn log file is full. Error 9002
Hi All, Here is the scenario on of the test servers. The transaction log...
How to define data types
What are the things you consider when you create a new table and define...
What is the default data-type for columns made from an expression
In Microsoft SQL Server Management Studio 2014, when you execute the following statement: SELECT...
Ask SSC