SQL Server Radio

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


Listen Later

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
...more
View all episodesView all episodes
Download on the App Store

SQL Server RadioBy Guy Glantser, Eitan Blumin

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

20 ratings


More shows like SQL Server Radio

View all
Radiolab by WNYC Studios

Radiolab

43,944 Listeners

More or Less: Behind the Stats by BBC Radio 4

More or Less: Behind the Stats

868 Listeners

Stuff You Should Know by iHeartPodcasts

Stuff You Should Know

77,477 Listeners

Planet Money by NPR

Planet Money

30,853 Listeners

The Infinite Monkey Cage by BBC Radio 4

The Infinite Monkey Cage

2,065 Listeners

Freakonomics Radio by Freakonomics Radio + Stitcher

Freakonomics Radio

32,121 Listeners

99% Invisible by Roman Mars

99% Invisible

26,114 Listeners

a16z Podcast by Andreessen Horowitz

a16z Podcast

1,009 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

580 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

26 Listeners

Hidden Brain by Hidden Brain, Shankar Vedantam

Hidden Brain

43,406 Listeners

Data Engineering Podcast by Tobias Macey

Data Engineering Podcast

139 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,521 Listeners

Throughline by NPR

Throughline

15,801 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

0 Listeners