Excellence in SQL Server

Recently we were asked to build a SQL Server cluster. My initial thought was to use some other technology to provide high availability...

We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template...

How do you make sure that any user database created is created on the disks that you have set aside for the data, transaction log and...

The setting of the correct index fill factor is a constant source of debate amongst DBAs. There is a lot of information that you need to...