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 - July 18, 2017 @ 6:30 PM

 

>>> Register Now - Click here


Time Topic
6:30 PM Title - Query Store – The good, the bad and the ugly

Abstract - With SQL Server 2016, Microsoft introduced the Query Store, which promised to track statement performance over time, pinpoint regressed queries and provide a more effective way to tune. In this session, we will look at the benefits and downsides of Query Store. How well does it actually work? What if your database is read only? What if you have lots of databases to monitor? How does it handle plan changes due to schema changes? Join Amit Parikh from Quest, to explore both the limitations and the sweet spot for using Query Store, and discover insightful tips on what to monitor, when to use it and how best to leverage the data it is collecting.

Amit will then demonstrate how you can use Spotlight Developer and its newly released Tuning Pack to deliver a stress-free route to SQL tuning. The Plan Viewer charts the route that SQL Server has chosen for you and highlights any congestion points in the plan by pointing out the most expensive nodes. The all-new Tuning Pack takes this a step further and acts as your GPS to automatically scan all the possible routes that could be taken and recommends the ultimate path to complete your query in the fastest time possible.

Outline –
• Pre SQL Server 2016 – Query Performance Management
• Overview of Query Store
• What are the benefits of Query Store
• How can the Query Store be used to solve real world problems
• Are there any downsides to Query Store?
• Best Practices for managing the Query Store
• Spotlight Developer and Tuning Pack

Speaker - Amit Parikh
  Sponsor - Quest Software

Quest® helps its customers reduce administration tasks so they can focus on growing their businesses. Combined with its invitation to the global community to be a part of the innovation, Quest continues to deliver the most comprehensive solutions for Microsoft Azure cloud management, SaaS, security, workforce mobility and data-driven insight.

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