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,687 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,070 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
11,893 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,569 reads
Blogs
Azure SQL Database Compatibility with SQL Server
By gorandalf
A long time ago, in early days of the Azure SQL Database in 2015,...
Custom deployment parameters in Azure Data Factory - Forget Me Not
By Rayis Imayev
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
Tempdb version store related question
Hi All, Recently, we observed the tempdb has grown out of proportion and filled...
about the option (fast n) and acutal execution plan
what kind of situation can I use "option (fast 1)" when I execute a...
Problem during the setup of SQL Server 2019
During the installation I come to the step of configuring the database engine. It...
Ask SSC