Oct 14 2024 32 mins 36
Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation.
Relevant links:
- Resources from Microsoft:
- Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub
- Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub
- EAP for Vector Support Refresh - Introducing Vector type - Azure SQL Devs’ Corner (microsoft.com)
- Calling external REST endpoints from Azure SQL Database | Microsoft Learn
- Index fragmentation:
- SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com)
- Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database? (kendralittle.com)
- Stop Worrying About SQL Server Index Fragmentation (brentozar.com)
- Why SQL Server Index Fragmentation Isn’t A Problem On Modern Storage Hardware – Darling Data (erikdarling.com)
- Index fragmentation scripts:
- Upcoming webinar at the Cloud Data Driven Meetup:
