Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.9K views 1 year ago #LearnSQL #SQL #AzureSQL
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). 00:00 - Introduction 01:05 - Purvi's list 01:31 - Demo ✔️ Resources: What's new in SQL Server 2022 (16.x): https://learn.microsoft.com/sql/sql-s... ✏️ Hidden Gems Playlist: https://aka.ms/sqlserver2022gems 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - Bob Ward,   / bobwardms   Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL ...more
...more
Instant File Initialization for the transaction log | SQL Server 2022 Hidden Gems | Data Exposed
53Likes
1,936Views
2024Mar 7
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). 00:00 - Introduction 01:05 - Purvi's list 01:31 - Demo ✔️ Resources: What's new in SQL Server 2022 (16.x): https://learn.microsoft.com/sql/sql-s... ✏️ Hidden Gems Playlist: https://aka.ms/sqlserver2022gems 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - Bob Ward,   / bobwardms   Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

Follow along using the transcript.

Microsoft Developer

588K subscribers