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 Applebee's.


Interested in sponsoring or speaking at our User Group?

Please contact us at OhioNorth@PASS.org for more information.


Please register on our new Slack Channel!

This is the invite link only.

If you already have registered using the above link you can go straight to it here: Slack Channel

Session Slide Decks provided by Speakers are posted on our Slack Group under the speakerslidedecks channel.


Next Meeting

Tuesday,

September

05

ONSSUG Meeting September 2017

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

If you are planning on attending, please RSVP here at Eventbrite! That helps us report attendance to our masters... thanks!

 

We will watch a video from the 2016 PASS Summit on Architecting Robust Big Data Solutions, presented by Brian Mitchell. Our erstwhile leader Luis will introduce what's news and new with PASS, and possibly in the soft drink world.

All of this fun will be followed by our feature presentation!

Special thanks for our meeting sponsor, Sentry One!!!

 

Featured Presentation:

Ten Query Tuning Techniques Every SQL Programmer Should Know

Kevin Kline, Principal Program Manager SentryOne

: SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful. Prerequisites: Familiarity with the SELECT statement on Microsoft SQL Server. Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves. Summary: Learn how to assess query performance, guarantee consistent query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.

About Kevin:
Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

Back to Top