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

Post Content

​ 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

✔️ Resources:
https://learn.microsoft.com/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16
✏️ Hidden Gems Playlist: https://aka.ms/sqlserver2022gems

? Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter – Bob Ward, https://twitter.com/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   Read More Microsoft Developer