Daniel Hutmacher

Join Bob Ward and friends to learn every aspect of SQL Server 2025 including AI built-in, Developer features, all of the core engine, Azure Arc, Fabric Mirroring, and more.

Join Bob Ward and friends to learn every aspect of SQL Server 2025 including AI built-in, Developer features, all of the core engine, Azure Arc, Fabric Mirroring, and more.

With the recent introduction of new JSON functions and JSON indexes in SQL Server 2025 and Azure SQL Database, this is a good time to learn what JSON is, and how to work with it in. While JSON support is a great addition to T-SQL, some of these new features will require a little planning and tweaking to get just right. We’ll cover the basics of the JSON format, common JSON functions in SQL Server, and how to make practical use of them when importing and exporting JSON data.

SQL injections can be found everywhere, including your ETL frameworks, your desktop apps, even your login prompts. In this session, we'll take a look at a wide range of code patterns that bad actors can exploit, from the obvious to the obscure, but we’ll also look at ways to prevent or mitigate the effects of SQL injection attacks.