The next EightKB is coming on January 27th, kicking off at 2pm UTC.
Once again we have 5 mind melting sessions on 5 in-depth SQL Server internals topics, from 5 top notch speakers.
Registration is free and you can sign up here: – https://eightkb.online/
Let’s have a closer look at the sessions 🙂
Welcome to the dungeon.
Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive.
In this deep-dive session, you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness.
This session will be an eye-opener for you. Assured.
While data compression is best-known for reducing a database’s size on disk, it’s also an effective tool for making your queries fly. Come see how reduced disk usage and increased performance mean that with compression, less really can be more!
Join Microsoft Data Platform MVP and MCM, Bob Pusateri (b|t), who will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server’s row and page compression features, as well as columnstore and updateable columnstore indexes.
This session will combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation.
Since there’s no such thing as a “free lunch” in computing, the drawbacks of these features will also be discussed.
One of the major changes in SQL Server 2017 and 2019 is addition of Intelligent Query Processing, which includes a number of improvements to the way queries are optimised and executed.
Join Microsoft Data Platform MVP and MCM, Gail Shaw (b|t), who will show why this is a radical departure from the way that things worked previously and how it can improve the performance of some query forms.
This session will look at the places where Intelligent Query Processing works and compare the performance of queries using these features to see just what kind of improvement it can make.
You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect!
Join SQL Server expert and author, Klaus Aschenbrenner (b|t) in this session for a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. He will cover the differences between both, and their use-cases in SQL Server.
You will learn about best practices how to analyze and resolve Latch- and Spinlock contention for your performance critical workload.
This session will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server since 2014.
Join SQL Server Infrastructure Architect and Engineer, Thomas Grohser for this session on how to build and configure a large SQL Server (CPU, Memory, Storage, Network) and how to modify your data model to support the scaling.
The whole talk is based on real world examples with servers as large as 224 cores and over 2 PB of storage.
We are REALLY excited for this event, it’s going to be a blast 🙂
Hope to see you there!