2020-10-22
6,546 reads
Disaster Recovery (DR)
DR as a Service
It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]
2020-10-01
84 reads
Do You Know What the Settings Should Be?
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
2020-09-28
80 reads
Emergency Preparedness
Being prepared for things to go wrong is important, more so these days than in much of our past.
2020-09-04
83 reads
How to Restore Model Database in SQL Server
In this tip we look at how to restore a missing or corrupt SQL Server model database.
2019-12-23
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
2019-12-05
215 reads
DR Priority
Today Steve asks about HA and DR. What compromises and choices do you make in your environment and how do you ensure your clients can get to their data.
2019-11-22
218 reads
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
2019-10-31
Find Estimate Time of recovery for database after Reboot
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
633 reads
How Climate Change Impacts Disaster Recovery and Security
Severe weather events cause disruptions that could lead to security vulnerabilities.
2019-05-15
Blogs
Daily Coping 10 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
T-SQL Tuesday 153: The conference that changed everything
This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...
T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...
Forums
CASE statement with multiple conditions (trimming & detecting spaces in between)
Hello everyone, I am trying to create CASE statement that will do three different...
Retrieve username for report?
We have a "report" that executes a stored procedure to perform updates. For these...
Transactional Replication to Azure getting "too many arguments" error on MSins
I'm running a 2019 (15.0.4102.2) Server with Transactional Replication out to a SQL Azure...
Ask SSC