Always Check on the Basics

The basics are important, especially with regards to backup and restore in SQL Server.

Azure Stretch Database, Part I: Getting Going

With most innovative new technologies, Azure Stretch Database demos make it look completely easy. Here is a step by step to get going, with examples. Part One of a Two-Part series.

Let’s Start with Architecture

In this article, we look at the conceptual design for gathering information about your servers to better understand how they are performing.

Resumable online index rebuild

How Often Do You Give Your Server a Physical?

The start of a new series that looks at examining your servers and keeping track of their health.

Tracking the Change

The Aware DBA

A good DBA is aware of how their systems should be working.

Resetting Status

Altering a Filegroup

The Dangers When Changing Database File Names

Recently a friend had an issue with their SQL Server as a result of a file change in their SQL Server database. In this short piece, I want to highlight the dangers of making some changes to an online database that might cause an unexpected outage. This is really the same whether you are changing […]