CBusPASS

Welcome to the Columbus SQL Server Users Group

 NOTE ONE TIME DATE CHANGE !!!

Our local meetings are free and open to all! We meet the second Thursday of every month. Our current meetings are being held at:


IGS

6100 Emerald Parkway

Dublin, OH

Important travel note: Due to all the construction around the I-270/33 interchange in Dublin, your best option for getting to the meeting is to take the Tuttle Crossing exit (15) and take Tuttle Crossing Blvd. west to Emerald Parkway, and turn right. IGS is about a mile on the right.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short introduction and Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:20 - Networking & social time

6:20 - 6:30 - Welcome & Announcements

6:30 - 6:45 - Warm Up Presentation

6:45 - 7:45 - Main Presentation

7:45 - 8:00 - Meeting Wrap Up and Door Prizes

Upcoming Meeting

Our next meeting will be on September 6th, 2017.

Join us on for a special edition of our monthly meeting as Kevin Kline joins us to present "Ten Query Tuning Techniques Every SQL Programmer Should Know".

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

 

Bio:

Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft data platform MVP and noted leader in the IT data management industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a principal program manager for SentryOne. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at @kekline.

 

RSVP HERE


Todd Skelton
Todd Skelton

Previous Meeting Presentation Files

 

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