Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
272 reads
This is a reblog of a post that I originally wrote back in January. After using this technique again last...
2017-10-03
120 reads
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,193 reads
As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...
2017-09-25
144 reads
How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...
2017-09-25
162 reads
sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...
2017-09-20
131 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
There are a whole bunch of environment variables that can be used to configure...
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Comments posted to this topic are about the item Volunteer For Something
I have inherited a SQL Server that makes a call to a Linked Server...
I have a merge stored procedure that may be conflicting with the structure of...
Ask SSC