Shop Talk: 2022-03-14

The Recording

The Panelists

  • Kevin Feasel
  • Mala Mahadevan
  • Mike Chrestensen

Notes: Questions and Topics

SQLbits and Hybrid Conferences

Our first topic of the night was a after-action report from Mala, who spoke at SQLbits. We also talked a bit about how difficult running a hybrid conference is: you have the difficulties of an in-person conference with the difficulties of a remote conference and few economies of scope.

HA/DR for a Small Shop

Most of our episode’s theme came from a question from rednelo, who reached out after the prior episode and asked about disaster recovery options. The short story is that they’re a small shop with one production server hosting both SQL and web servers. A Windows patch ended up breaking connectivity between the web server and SQL Server and they eventually needed to take a downtime to recover.

Rednelo followed up by mentioning log shipping as an option and wanted to see if that was reasonable. Spoilers: yes, it can be, especially for smaller shops.

One of the resources I love is Brent Ozar’s HA/DR planning worksheet. The last update was in 2016 but it’s still pretty well valid, with the only major addition being distributed availability groups.

Leave a Reply

Your email address will not be published. Required fields are marked *