Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure.
And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks.
Relevant links:
Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) -...
Published 04/08/24
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
Relevant links for more info:
OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Microsoft Learn ...
Published 02/12/24