[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/.

Here’s what we covered:

00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019). Is the change worth paying for? I cannot find any benchmarks to support or contradict such a change. 04:12 OhMyKingdomForANetworkEngineer: Hi Brent! You mentioned using DNS CNAMEs to redirect during log shipping failovers. My friend wants redirect end users to new production after upgrade