Yooper PASS

Next Meeting




September Meeting

  • In-Person @ 2235 Pewabic St. Iron Mountain, Michigan, United States (map)
  • 17:30 - 19:00 Central Daylight Time
  • Language: English

Come join us to listen to a Guy Glantser presentation on XML and JSON.

Featured Presentation:

From XML to JSON

Guy Glantser, CEO Madeira Data Solutions

Session Description: 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 in order to apply constraints on the contents of XML documents, as well as to speed up query performance. SQL Server 2016 provides 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 markup languages in SQL Server. We will discuss use cases for using either XML or JSON. We will compare a few methods and talk about the performance impact of each. If you're a developer and you need to manipulate XML or JSON files in SQL Server, then this session is for you.

About Guy:
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.



Sponsored By:

Back to Top