The Case Against SQL Server VSS- or Virtualization-Based Backups

A recent conversation that we had around the dinner table revolved around fire safety hazards. The last week of November happened to be the National Home Fire Safety Week in Canada and promotes fire safety in homes and residential areas. Home insurance companies would recommend having a fire extinguisher at home placed in the kitchen or […]

When A Log Backup Does Not Truncate Your SQL Server Log Files In An Availability Group

There are only two ways that can truncate your SQL Server log files – a checkpoint process when the database is in simple (or pseudo-simple) recovery model or a log backup when the database is in full or bulk-logged recovery models. In order for log truncation to occur, the virtual log files (VLFs) need to […]

Upgrading to SQL Server 2014: Considerations

As SQL Server 2005 approaches the end of its support next year, customers can start planning for upgrading their databases to SQL Server 2014. In a previous blog post, I talked about how to integrate Microsoft Product Lifecycle and Support Policies into IT Operations which concluded with planning upgrades and migration based on the version […]

Video: Designing a SQL Server Always On Availability Groups Topology

As you go thru different phases in your career as a SQL Server professional, you progress from being a technician (primary task is more focused on operations) to a designer/architect (primary task is focused on designing a solution and eventually assists in building it.) A technician will be more concerned about a single aspect of a […]

Resources: Windows Server Failover Clustering (WSFC) for SQL Server DBAs

Last week at Live360, I have had the opportunity to deliver my workshop on Windows Server Failover Clustering (WSFC) for SQL Server DBAs. The workshop was based on an online course that I am about to re-release. One of the things I like about delivering presentations is that I learn a lot from the attendees […]