EIGHTKB Logo
SQL Server Internals Conference

EightKB 2025 Schedule

UTC Time Session Speaker Level Length
13:00 Welcome! EightKB Crew 10m
13:15 Fix your SQL database design with T-SQL static code analysis Erik Ejlskov Jensen 400 60m

Fix your SQL database design with T-SQL static code analysis

If you are a database developer looking for ways to improve your database design or you want help others avoid database design mistakes, this session is for you.

You will learn

- how to add build validation and static code analysis to existing or new SQL database schema and scripts
- how to take advantage of additional community provided analyzer rules
- how to customize the rules engine for your purposes
- how to create and share your own rules

This session will be demo driven and based on production experience using this approach to improve database design process early in the development lifecycle with free, open source tools and libraries.

14:30 Next-Gen High Availability with Contained Availability Groups Nader Sharara 400 60m

Next-Gen High Availability with Contained Availability Groups

In this session, we’ll explore the game-changing concept of Contained Availability Groups (Contained AGs) in SQL Server. Learn how this feature simplifies high availability and disaster recovery by encapsulating databases, metadata, and dependencies within the availability group. Through live demos, we’ll showcase how to set up, manage, and migrate Contained AGs, demonstrating their benefits for on-premises, hybrid, and cloud environments.

15:45 Resurrecting Lost Data: Mastering SQL Server's Transaction Logs and Row Internals Secrets Vladimir Afanasev 400 60m

Resurrecting Lost Data: Mastering SQL Server's Transaction Logs and Row Internals Secrets

A deep dive into SQL Server internals for data recovery

This 400+ level session delves into the advanced internals of SQL Server, focusing on techniques to recover deleted data by leveraging transaction logs and understanding the structure of data rows. Attendees will gain insights into how SQL Server manages transactional operations, how data rows are stored and marked for deletion, and how these mechanisms can be used to retrieve data even after accidental deletion.

Prerequisites:
To maximize the learning experience, attendees should have:
- A solid understanding of SQL Server architecture, including transaction logs and recovery models.
- Proficiency in writing and analyzing T-SQL scripts.
- Experience with database management tasks such as backups, restores, and performance tuning.

Key Takeaways:
- A step-by-step guide to identifying and recovering deleted data using fn_dblog command.
- Understanding the anatomy of a data row in SQL Server.
- Best practices for data recovery and preventing accidental data loss in production environments.

Why This Session?
This session is tailored for advanced database professionals who are looking to deepen their technical expertise and gain practical skills in handling critical data recovery scenarios. The session balances theoretical knowledge with hands-on techniques to provide an engaging and actionable learning experience.

Let me know if you’d like further refinements!

17:00 Exploring TDS: The Protocol Behind Client-Server Database Communication James O'Doherty 500 60m

Exploring TDS: The Protocol Behind Client-Server Database Communication

The Tabular Data Stream (TDS) protocol is essential for communication between clients and database servers. This session will break down how TDS works, how connections are established and maintained, and its role in authentication, channel encryption, SQL execution, and returning data.

18:15 Deep Dive into Memory-Optimized TempDB Haripriya Naidu 400 60m

Deep Dive into Memory-Optimized TempDB

TempDB contention has always been a challenge for DBAs, especially in high-concurrency OLTP environments. To address this, SQL Server has introduced several enhancements starting with SQL Server 2019, to reduce bottlenecks and improve performance, including Memory-Optimized TempDB.

In this session, I’ll show you how Memory-Optimized TempDB works, when to use it, and how to implement it. I’ll demonstrate how it will resolve contention. I'll also cover limitations and provide strategies to manage them effectively.

By the end of this session, you'll have a clear understanding of how and when to leverage Memory-Optimized TempDB to enhance server performance.

EightKB 2025 Registration is Open!

It's that time again! Time to register for the biggest SQL Server internals conference on the internet! Join us *August 21st @ 13:00 UTC* for a free day of the high quality deep-dive content you've come to expect from EightKB!

Who is EightKB?

We created this event to fill a void in the SQL Server conference line-up. While there are many important topics to discuss and things to learn in the SQL Server world, we want this conference to focus on the core components of SQL Server, the things that make SQL Server work. EightKB is about expert topics, not expert speakers. If you have expert experience about any SQL Server topic, the community wants to hear you speak. If you aren’t yet an expert speaker, we will help you with your abstract and session and even pair you with a mentor if you like. A core goal of this conference is to enable SQL Server professionals to bring their whole selves to the event. In particular, we believe that a diverse and inclusive speaker community is foundational to everyone feeling welcome at our conference.