DBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner
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.
Get full session notes, resources and more here: https://groupby.org/2017/03/dbas-vs-developers-json-in-sql-server-2016/
Видео DBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner канала GroupBy
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.
Get full session notes, resources and more here: https://groupby.org/2017/03/dbas-vs-developers-json-in-sql-server-2016/
Видео DBAs vs Developers: JSON in SQL Server 2016 with Bert Wagner канала GroupBy
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Working with Very Large Tables Like a Pro in SQL Server 2019 — Guy GlantserMonitoring and Troubleshooting SQL Server environments using Free community tools — Javier VillegasAdvanced data types – JSON — Damir MatešićUsing Query Store to fix plans & pains in your queries — Pablo LozanoA Complete Introduction to Azure Data Factory — Paul AndrewA Practical Starter Guide to SQL Notebooks — Deborah MelkinManaging SQL Server the easy way with dbatools — Daniel Suarez6 Query Tuning Techniques to Solve 75% of Performance Problems — Amit BansalAzure SQL: What to use when — Anna HoffmanFree Pizza & Beer… And Other Mistakes — Andy MallonUnderstanding Statistics in SQL Server — Deepthi GoguriAdvanced Plan Explorer Usage for Tuning Execution Plans — Andy YunFrom XL to S – Reduce your Power BI model size by 90%! — Nikola IlicBaking Extended Events recipes without breaking a sweat — Gianluca SartoriSQL TUTORIAL - CTEs Part 1High Availability/Disaster Recovery 101 — Glenn BerryAzure SQL Database Administration for the on-prem DBA — Ahmad OsamaHow to import nested JSON object (JSON data file) in Microsoft SQL ServerAdvanced data security (from 2016 to 2019 new features) — Ronen ArielyConverting a Shapefile to GeoJSON with QGIS