SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly—a software glitch that causes an app to freeze or a ...

Database backups and restores are a fundamental (and critical) skill-set of any MS SQL Server DBA. A solid backup plan is a requirement for most on-premise instances and things are no different in the ...

We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been running ...

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...

Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services. Part of the company’s Azure services platform, SQL Data Services, it ...

A new version of SQL Server is a big deal for Microsoft Corp. SQL Server is a $5 billion business for the world’s largest software company, and the company says it now enjoys a 45% market share ...