SQL Server Internals Conference

Event Details Code of Conduct Previous Events Podcast Blog

Session Schedule

Session	Speaker	Level	Length
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.
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.
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!
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.
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.