Broken tempdb

Why PolyBase matters - Part 2

Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.

Disaster Recovery and Big Data

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

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.

Disaster Recovery Tip #8: Maintain up-to-date contact information

A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.

Disaster Recovery Tip #6 - Monitor Your Systems

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.

Disaster Recovery Tip #4 - Learn about partial restores!

Sometimes recovery simply entails rerunning a failed process.

Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs

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.

Planning for Disaster

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.

Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral.