Welcome to the Ohio North SQL Server User Group


Our user group meets the first Tuesday of every month from 5PM-7:30PM at the Microsoft office in Independence.

Microsoft Corporation
6050 Oak Tree Blvd.
Suite 300
Independence, OH 44131

Our meetings follow the schedule below:
5:00PM - 6:00PM: Video presentation from last year's SQL PASS Summit
6:00PM - 6:15PM: Announcements & Introductions
6:15PM - 7:30PM: Feature Presentation

Afterwards, we usually continue networking across the street at Mavis Winkles.

 Upcoming Meeting

Next Meeting

Tuesday,

April

07

April Meeting

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

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

5:00 - 6:00



Pre-Session Video: Spatial Data: Looking Outside the Map



Pre-Session Abstract: It's been said it before and it'll be said again: spatial data doesn't get much love in SQL Server. But, it is a feature worthy of much appreciation and will become more vital as more location data is collected. In this session, we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.

6:00 - 6:15



Opening & Announcements



Sponsor Intro: KellyIT - http://KellyIT.com

6:30 - 7:30

Feature Presentation

Meeting Sponsor: 

KellyIT - KellyIT.com

www.kellyservices.com 

Please take a minute to check our their site and see what they have to offer and don't hesitate to contact them if you have any questions.

Featured Presentation:

Working with BimlScript to ease and automate your SSIS development

Jeff Mlakar, Enterprise Architect Bennett Adelson Consulting

Business Intelligence Markup Language (Biml) is a great way to simplify your SSIS development to an easy-to-read XML format. BimlScript expands this even further to allow you to embed .NET code in your Biml to have new Biml dynamically generated with schema changes at your source. In this session, we’ll talk about what BimlScript can do and give you multiple examples of how it makes SSIS package creation easier and more dynamic.

About Jeff:
Jeff Mlakar is an Enterprise Architect on the Business Intelligence team at Bennett Adelson Consulting. He has spent the last decade working in database technologies, ranging from SQL Server, SSIS, and the whole Microsoft BI stack, to Oracle and Elasticsearch. He has spoken at the local .NET User group, the Modern Excel User group, SQL Saturdays, the SQL Server User Group, and the Dog Food Conference.