Post Content
Join SQL Server expert and best-selling blogger Erik Darling on a fast-paced ride through the treacherous terrain of SQL Server settings. Whether you’ve just gotten the keys to your first SQL Server, or you’ve been tweaking them for years, this session is for you.
Erik will draw from his vast experience to reveal:
– Settings that’ll make your workload go faster than free beer
– Configuration options that you should avoid like free sushi
– Newer SQL Server settings that don’t get a lot of attention
Prepare for the best 10 minutes of your life, that’ll have you itching and scratching to log into your servers and right some configuration wrongs. Don’t miss this chance to learn which settings Erik loves, which ones he loathes, and everything in between.
Chapters:
00:00 – Introduction
03:12 – Min Server Memory
04:03 – Lock Pages in Memory
04:55 – Target Recovery Interval
06:05 – Optimize for Ad Hoc Workloads
07:16 – Resource Governor
08:15 – Accelerated Database Recovery
09:56 – Optimistic Isolation Level
10:38 – In-Memory Temp DB
11:29 – Database Compatibility Level
📌 Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
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
