The Real Secret to Successfully Upgrade SQL Server Databases

Given Microsoft’s recent announcement of SQL Server 2017 general availability, you somehow get an idea of the frequency of releases for future SQL Server versions. This translates to more database upgrade and migration work that SQL Server DBAs have to do. However, keeping up with the latest and greatest version is not practical from a […]

Upcoming Virtual Training Class: SQL Server Always On Availability Groups: The Senior DBA’s Field Guide

In partnership with Brent Ozar (Twitter | blog). The idea behind this partnership started last year when Brent was kind enough to spend one Saturday morning with me over breakfast at the Bar Siena Restaurant in Chicago. I have been thinking about launching my online course – Windows Server Failover Clustering for the Smart SQL Server […]

Last call for registration

I teach about failover clustering for SQL Server – whether it’s Failover Clustered Instances or Availability Groups. Failover clustering does not have to be confusing nor complicated. It just has to work. And when things we are responsible for don’t work, we get the blame. There’s a reason behind the running joke about the Default […]

Mistakes Engineers Learn

T-SQL Tuesday #92, Lessons learned the hard way

The equation for fluid dynamics. The concepts behind set theory. The operators in relational algebra. The mathematics behind materials strength. The abstraction principle in computer programming. If you’re an engineer or a computer professional, I’m sure you can relate. These are the things I’ve learned in engineering school. I learned how to use equations to […]