Brent Ozar answers community-voted SQL Server questions during a layover in Iceland, recorded in a 360-degree video from a lava field. Topics include the real-world value of In-Memory OLTP, when to use query hints vs. letting the optimizer decide, what defines a Senior DBA, whether consulting makes you sharper or shallower, the relevance of stored procedures vs. application-layer logic, storing secrets in SQL vs. Azure Key Vault, and options for cross-server foreign key relationships when splitting a 20 TB database.
Table of contents
Related154 Impressions