Photo by Jakub Jankiewicz
DBAs and developers who want to work with JSON efficiently in SQL Server 2016.
The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developers who want to store their data in JSON because it is fast, standard, and flexible. DBAs cringe when they hear of long text strings being stored in their SQL databases; they cry with concern, “No data validation? No schema binding?”. Is there any hope for these two warring factions to see eye-to-eye?
This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.
By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016. It will also usher in an era of peace between DBAs and developers…
… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.
Why I Want to Present This Session:
As a developer, I love JSON. However, I started my career in the world of SQL’s take-advantage-of-relational-databases-instead-of-row-by-agonizing-row-processing and I’m aware of the terrible SQL queries that developers are capable of writing. This session is exciting to me because with SQL Server 2016 it is now possible for developers to use JSON in SQL while DBAs can be happy that those queries aren’t killing the server.
For additional resources, please see my blog post series on the topic of JSON in SQL Server 2016:
When Is It Appropriate To Store JSON in SQL Server?: https://blog.bertwagner.com/when-is-it-appropriate-to-store-json-in-sql-server-8ed1eed1520d
Part 1 – Parsing JSON: https://blog.bertwagner.com/json-support-is-the-best-new-developer-feature-in-sql-2016-bbb3ced89ce8#.s7zd2uo1u
Part 3 – Updating, Adding, and Deleting JSON: https://blog.bertwagner.com/json-support-is-the-best-new-developer-feature-in-sql-2016-part-3-updating-adding-and-deleting-24cea5fc0ab5#.6uedy635g
Part 4 – JSON Performance Comparisons: https://blog.bertwagner.com/json-support-is-the-best-new-developer-feature-in-sql-2016-part-4-performance-comparisons-bd04dc7635f3#.xtqnqjpam
Part 5 – JSON DateTimes: https://blog.bertwagner.com/who-stuck-these-letters-in-my-datetimes-b42cbd6e987d
Latest posts by Bert Wagner (see all)
- DBAs vs Developers: JSON in SQL Server 2016 - June 9, 2017
- High-Performance SQL Server Reporting Services: Lessons Learned - January 13, 2017