Baltimore SQL Server Users Group

Join the Baltimore SQL Server Users Group to expand your knowledge and network!  We hold free monthly meetings focusing on SQL Server DBA, Development, Business Intelligence and Professional Development topics.  We meet at the Charles I. Ecker Business Training Center located at 6751 Columbia Gateway Drive Columbia, MD 21046. Our meetings are typically on the third Tuesday of the month from 6:30 PM to 8:30 PM and they are free to attend.  We generally have food, drinks and sometimes dessert, besides one or two valuable educational sessions.

  Next Meeting - May 16, 2017 @ 6:30 PM

 

>>> Register Now - Click here


Time Topic
6:30 PM TITLE: Ten Query Tuning Techniques Every SQL Programmer Should Know

Level: 200

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.

Speaker: Kevin Kline
 
Sponsor - Sentry One

SentryOne™ enables Microsoft data professionals to monitor, diagnose, and optimize performance across physical, virtual, and cloud environments. Our software provides unparalleled awareness, insight and control over the true source of performance issues.

SentryOne

>>> Register Now - Click here

 

 

Join the Baltimore SQL Server Users Group


Join the BSSUG and expand your SQL Server knowledge.  Here's how to get started:

> Official mailing list (Constant Contact)
> General announcements and job postings (Yahoo Group)
> LinkedIn
> Meetup 

Interested in speaking or sponsorship?  We are looking to round off our speakers and sponsors for the year. If you are interested in speaking or sponsorship opportunities please contact Jeremy Kadlec.

Baltimore SQL Server Users Group History


The BSSUG was started in the days before SQL Server 7.0, back in 1999, by Raymond Barley.  The group has met in a few different places and been co-lead by a few different individuals, but the group has always been in the BWI-Columbia area.  We are a constantly growing group and always interested in meeting new members.  We are a member of the Capital PC Users Group and a SQL PASS official chapter.

Baltimore SQL Server Users Group Leadership

Ray Barley
Raymond Barley
Email
410.804.4658
Bio
Jeremy Kadlec of Edgewood Solutions and MSSQLTips.com
Jeremy Kadlec
Email
410.591.4683
Bio
- BSSUG Founder in 1999
- Principal Architect at RDA Corporation
- Microsoft Certified Solutions Expert (MCSE)
- MSSQLTips.com Champion Award Recipient  
- SQL Server Consultant @ Edgewood Solutions
- Co-Founder of www.MSSQLTips.com
- Author, Speaker and Trainer
- Co-Leader of the Baltimore SSUG


  Baltimore SQL Server Users Group Sponsors

 

Copyright (c) 2012 - 2017 BSSUG INC. All Rights Reserved.