Everyone asked for JSON in the last years….and now finally we have JSON support within SQL Server! The much-asked, long-waited feature is finally here! In this session we’ll see how the JSON support works within SQL Server, what are the pros and cons, the capabilities and the limitations, and will also take a look at performance of JSON vs equivalent relational(ish) solution to solve the common “unknown-schema-upfront” and “I-wanna-be-flexible” problems.
If used in the correct way, JSON can be a killer feature that simplifies codes, make DEVs and DBAs friends again, all with also extremely good performances. So it’s not a matter IF to use it, but just WHEN you’ll start to use it….see this session and you’ll understand why you’ll love JSON too (if you don’t love it already :))!
Why I Want to Present This Session:
JSON is everywhere today…and now that SQL Server has native support to it – and it’s really really cool – the more people will know how to use it, the more the impedance mismatch between developers and dba will hurt.
JSON can be used not only be developers to simplify code, but also by dbas, for example, to create simpler stored procedures