Salt Lake City SQL Server User Group

Welcome to the Salt Lake City Chapter

EventDisplay

Next Meeting: Wed, Oct 10 2018

October SLC SQL User Group Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://attendee.gotowebinar.com/register/1665624169994717186
RSVPURL: Registration URL: https://attendee.gotowebinar.com/register/1665624169994717186 Webinar ID: 575-262-211

October SLC SQL Meeting - IMED DOTY CR 6+7+8

Presentation by Joshua Johnson
Title: Working with JSON in SQL Server
Watch Online Registration URL: https://attendee.gotowebinar.com/register/1665624169994717186
Webinar ID: 575-262-211

Abstract:
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.

Bio:
Data Architect - Dentrix Ascend, Henry Schein Practice Solutions
Bachelors of Science in Computer Science: Utah Valley University
Joshua has worked with databases since 1999 and with SQL Server since October 2003.
Joshua has worked as a software or QA engineer since 1999 working with Java, PHP, C#, Groovy, etc. He currently works at Henry Schein Practice Solutions (now Henry Schein One). He has been there for the past 14 years where he has been a QA engineer, software engineer and is currently the data architect for a cloud-based dental practice management software (Dentrix Ascend) – where he works under a Microsoft Certified Master in SQL Server. His responsibilities have included training other engineers, and has taught multiple classes on topics including: indexes, XML, optimizations, etc.

When

iCal
UTC : Wed, Oct 10 2018 21:00 - 23:00
Event Time : Wed, Oct 10 2018 15:00 - 17:00 Mountain Daylight Time
Your Local Time: Wed, Oct 10 2018 21:00 - 23:00

Where

Doty Family Education Center
Murray, Utah

Featured Presentation

Working with JSON in SQL Server

Speaker: Joshua Johnson, Data Architect - Dentrix Ascend Henry Schein Practice Solutions

Summary: Abstract: 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.

Announcements

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids