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
This Week in Tech (Audio) by TWiT

This Week in Tech (Audio)

3,009 Listeners

Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

377 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

246 Listeners

WSJ What’s News by The Wall Street Journal

WSJ What’s News

4,326 Listeners

WSJ Your Money Briefing by The Wall Street Journal

WSJ Your Money Briefing

1,744 Listeners

The Rich Roll Podcast by Rich Roll

The Rich Roll Podcast

11,749 Listeners

BiggerPockets Real Estate Podcast by BiggerPockets

BiggerPockets Real Estate Podcast

16,811 Listeners

a16z Podcast by Andreessen Horowitz

a16z Podcast

1,014 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

27 Listeners

Dear SQL DBA by Kendra Little

Dear SQL DBA

28 Listeners

Revisionist History by Pushkin Industries

Revisionist History

59,388 Listeners

The Jordan B. Peterson Podcast by Dr. Jordan B. Peterson

The Jordan B. Peterson Podcast

34,030 Listeners

Darknet Diaries by Jack Rhysider

Darknet Diaries

7,872 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,520 Listeners

My First Million by Hubspot Media

My First Million

2,618 Listeners