Episode 168 - New data types in SQL Server and a question about index fragmentation

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:
  • microsoft-dbas-club/Indexes/Table and Index High Unused Space.sql at MadeiraData/microsoft-dbas-club
  • Check Index Fragmentation Based on Page Fullness and Fill Factor
• Upcoming webinar at the Cloud Data Driven Meetup:
  • Database DevOps for Leaders - Eitan Blumin, Thu, Oct 24, 2024, 12:00 PM | Meetup