In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.
2014-08-11
9,549 reads
A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.
2013-08-01
4,236 reads
Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.
2013-07-25
4,301 reads
Sometimes recovery simply entails rerunning a failed process.
2013-07-19
3,818 reads
Data Protection and Disaster Recovery (DR) are IT tasks that seldom get the same level of attention as development… until disaster strikes. Only if planning is adequate can an organisation be resilient in the face of unexpected problems. There are several steps that are needed to achieve an adequate DR process and the ability to restore business operations after a disaster.
2013-04-18
3,227 reads
There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime in such circumstances should be the aim of every effective DBA. To plan for recovery, It pays to have the mindset of a pessimist.
2012-12-14
1,871 reads
This week we highlight the practice of being prepared for disasters at SQLServerCentral.
2012-12-14 (first published: 2012-12-10)
5,556 reads
Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity.
2012-12-10
2,360 reads
This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.
2011-11-07
5,662 reads
2011-07-14
2,445 reads
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Hello, I want to have value Month ago Year ago So far, I've this...
Comments posted to this topic are about the item The Fake Speakers
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Ask SSC