In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton
PASS Data Community Summit via YouTube
Power BI Fundamentals - Create visualizations and dashboards from scratch
Finance Certifications Goldman Sachs & Amazon Teams Trust
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore SQL Server Hekaton (In-Memory OLTP) architecture and performance optimization in this technical session presented by 20-year SQL Server MVP Kalen Delaney. Learn how this revolutionary technology transforms data management by keeping all data in memory while using disk storage primarily as a REDO log. Discover the architectural differences in memory and storage requirements, understand the internal workings of memory-optimized tables and indexes, and examine checkpoint operations and disk writing processes. Gain deep insights into the mechanisms behind Hekaton's remarkable 30x performance boost and understand how this technology can revolutionize database administration practices.
Syllabus
24 Hours of PASS: Summit Preview - In Memory OLTP Internals: How is a 30x Performance Boost Possible
Taught by
PASS Data Community Summit