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,762 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,081 reads
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
2011-12-19
12,283 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,859 reads
Blogs
Daily Coping 18 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure Cosmos DB – HTAP using Azure Synapse Link
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Azure Cosmos DB – HTAP using Synapse Analytics
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Forums
Event log filling up with Sql error
Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...
How to do Join
Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...
Connect to PostgreSQL as an External Data Source using PolyBase
Comments posted to this topic are about the item Connect to PostgreSQL as an...
Ask SSC