Utah County SQL Server User Group

Welcome to the Utah County Chapter

Next Meeting




Working with JSON in SQL Server

  • In-Person @ 1220 S. 630 E. American Fork, Utah, United States (map)
  • 15:00 - 17:00 Mountain Daylight Time
  • Language: English

**Please note that as of August 2018 the Utah County meeting has moved to a new time and location.**

Time: Thursday September 13, 3:00 PM

Location: Henry Schein, American Fork
Arrival instructions: Enter through the East doors and check in with the security desk. The Wirig Conference Room is through the glass doors on your right after passing security.
Google map: https://goo.gl/maps/GQ7cmk1D8B22
Video showing one route to the building: https://drive.google.com/open?id=1Annrr75usR_HGBflj-jq8X1omQbiRGgg


Come to our monthly meeting to visit, network, ask questions and increase your knowledge and skill.  Details are below, see you there!

If you wish to join remotely, you can register using this URL:  https://attendee.gotowebinar.com/register/5562272487842240514

Featured Presentation:

Working with JSON in SQL Server

Joshua Johnson, Database Architect - Dentrix Ascend Henry Schein Practice Solutions

JSON is widely used by applications now instead of XML. Is that good or bad? What are the benefits and what are the uses of it in SQL Server? Is SQL Server really the place to generate or query my JSON? This session will give an overview of JSON, its pros and cons and resources available to you to be able to learn about JSON. The presentation will present the various functions SQL Server has available for generating, parsing, modifying and presenting data from JSON structures. Included in that discussion will be appropriate techniques for storing JSON your application receives. Finally, it will discuss ways to index a JSON structure as well as potential pitfalls with indexing the structure.

About Joshua:
Joshua has worked as a software or QA engineer since 1999 using Java, PHP, C#, Groovy, etc. He started using databases at the end of 1999 and has been using SQL Server since October 2003. He received his bachelor's degree in CS from Utah Valley University. Joshua currently works at Henry Schein Practice Solutions. He has been there for the past 13 years where he has been a QA engineer, software engineer and is currently the database architect for their cloud-based dental practice management software (Dentrix Ascend) – where he works under a Microsoft Certified Master in SQL Server. His responsibilities have also included training other engineers – where he has instructed on topics including indexes, XML, optimizations, etc.




Back to Top