XML and JSON are two widely used markup languages, shared by many applications and data platforms. Since SQL Server 2005, there is native support for XML, which means we can extract relational data from XML documents as well as generate XML documents from relational data. We can also use namespaces, schemas and indexes. SQL Server 2016 is going to provide support for JSON, so that we can do more or less the same things with JSON.
In this session we will learn how to work efficiently with these two languages in SQL Server. We will compare a few methods and talk about the performance impact of each. We will also discuss use cases for using either XML or JSON.
If you’re a developer and you need to manipulate XML or JSON files in SQL Server, then this session is for you.
Guy Glantser, SQL Server MVP, is the leader of the Israeli PASS chapter and also the CEO of Madeira. His career has been focused on SQL Server for the past 18 years, performing various database roles as either a DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, PASS Summit, SQL Rally, SQLBits and user groups around the world. He also co-hosts the SQL Server radio show.