Ohio North SQL Server User Group

Choose a meeting below to view its details


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
cage-aids
cage-aids
cage-aids
cage-aids