Past Meetings

Choose a meeting below to view its details


 
 
 

Tuesday,

April

04

ONSSUG April meeting

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:00 Eastern Daylight Time
  • Language: English

This April meeting will hold not only our usual items on the agenda but elections! I hope to see lots of people to vote in a new set of board members. All four seats are up for grabs so please come to vote.

 

RSVP here: https://www.eventbrite.com/e/onssug-april-meeting-tickets-33179509807

Our PASS video will be

Getting Your Story Straight with Data Visualizations

Having multiple data visualizations doesn't make it easier to choose the right one to reveal the story. Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data. Along the way, you will also learn how to evaluate the goal of your data story and how to choose the correct visualizations that communicate this story accurately and effectively.

By: Stacia Varga


Featured Presentation:

JSON Usage and Performance in SQL Server 2016

Bert Wagner, Business Intelligence Developer Lead Progressive Insurance

JSON has become the standard format for transmitting serialized data in today's websites, APIs, and applications. With SQL Server 2016, Microsoft has made it easy to work with JSON strings in T-SQL. This session is an introduction to the new JSON functions added in SQL Server 2016. We will use T-SQL query examples to learn how these new functions can be used to parse, create, and modify JSON data. We will also discuss when it's appropriate to store JSON in databases as well as how to optimize performance when using these new functions. By the end of this presentation DBAs and developers will know how to efficiently work with JSON data in SQL Server 2016.

About Bert:
Bert is a lead business intelligence developer at Progressive Insurance in Cleveland, Ohio where he builds solutions that allow employees to improve the quality of their work and increase productivity. He has over 15 years of full stack web development and relational database experience and enjoys helping others learn to be self-sufficient SQL problem solvers. Additionally, Bert maintains a blog at https://bertwagner.com and is an avid outdoorsman.