This session examines the evolution of SQL Server from 2012 to 2025, with a focus on features that enable developers to write more efficient, secure, and maintainable code. Through practical demonstrations and real-world examples, attendees will learn how to leverage modern capabilities, including JSON support, temporal tables, dynamic data masking, row-level security, in-memory OLTP, and advanced string and date functions. The session also covers performance tuning tools, encryption strategies, and expanded cross-platform support, providing a comprehensive guide for developers seeking to optimize SQL Server’s performance in modern applications.

Prerequisites

Basic understanding of T-SQL

Familiarity with SQL Server Management Studio (SSMS)

Experience working with SQL Server 2012 or later

Session Goals

Explore time-saving developer functions introduced in SQL Server versions 2012–2025.

Understand new security, paging, and in-memory features that enhance application performance and protection.

Learn about expanded operating system and platform support, including Linux and containerization.