22-25 April 2026

Leveraging JSON in Microsoft SQL Server

Proposed session for SQLBits 2026

TL; DR

Dive into JSON in SQL Server: learn its role, native support, and best practices to efficiently store, query, and optimize JSON data for modern applications.

Session Details

In the ever-evolving landscape of database management, the integration of JSON (JavaScript Object Notation) has become pivotal for modern applications. This session aims to provide a deep dive into the integration and utilization of JSON in Microsoft SQL Server.
The session will commence with a foundational understanding of JSON and its role in database systems. Participants will gain insights into the structure of JSON, its advantages, and how it aligns with contemporary data storage and exchange requirements.
Moving forward, the session will explore the native JSON support introduced in Microsoft SQL Server, unravelling the capabilities and performance enhancements it brings to the table. Attendees will learn how to efficiently store, query, and manipulate JSON data within the SQL Server environment

3 things you'll get out of this session

- Understand the role and structure of JSON in modern database systems and its integration with SQL Server. - Explore native JSON support in SQL Server, including storage, querying, and manipulation capabilities. - Apply best practices and performance techniques to optimize JSON usage in real‑world SQL Server applications.