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,718 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,073 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
12,062 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,690 reads
Blogs
2020 Advent of Code–Day 3
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Welcome to the Azure Data Community, empowered by Microsoft
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
Daily Coping 24 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server maximum Server Memory
I am using SQL Server 2008 R2 Express edition. I have already set Maximum...
Developer vs Enterprise
Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...
"SQL Server Windows NT - 64 bit" in Task Manager: Memory and CPU high
Hello, It's weird that suddenly I can't access to my sql server database (it...
Ask SSC