Episode

Instant File Initialization for the transaction log | SQL Server 2022 Hidden Gems | Data Exposed

with Anna Hoffman, Bob Ward

Data Exposed

Next in the SQL Server 2022 hidden gems series you'll learn about Instant file Initialization (IFI) behavior for Log file growth even with TDE enabled (does not require special privilege).

Chapters

• 00:00 - Introduction
• 01:05 - Purvi's list
• 01:31 - Demo

Recommended resources

• What's new in SQL Server 2022 (16.x)
• Hidden Gems Playlist

Related episodes

• Data Exposed | Microsoft Learn
• To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
• Microsoft Azure SQL
• Microsoft SQL Server
• Microsoft Developer

Connect

• Anna Hoffman | Twitter/X: @AnalyticAnna
• Bob Ward | Twitter/X: @bobwardms
• AzureSQL | Twitter/X: @azuresqltw

Next in the SQL Server 2022 hidden gems series you'll learn about Instant file Initialization (IFI) behavior for Log file growth even with TDE enabled (does not require special privilege).

Chapters

• 00:00 - Introduction
• 01:05 - Purvi's list
• 01:31 - Demo

Recommended resources

• What's new in SQL Server 2022 (16.x)
• Hidden Gems Playlist

Related episodes

• Data Exposed | Microsoft Learn
• To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
• Microsoft Azure SQL
• Microsoft SQL Server
• Microsoft Developer

Connect

• Anna Hoffman | Twitter/X: @AnalyticAnna
• Bob Ward | Twitter/X: @bobwardms
• AzureSQL | Twitter/X: @azuresqltw

Video URL

Start at time

HTML iframe

Player size

1920 x 1080 1280 x 720 640 x 360

Start at time

Developer

Azure

Azure SQL Database