HASSUG and Houston BI User Group normally meets on the second Tuesday of every month during lunch time.   Occasionally, we will meet at other time, so please watch this page for updates. 

*** MEETING LOCATION  ***

         Improving
10111 Richmond Ave
Houston, Texas 77042

Next Meeting: Tue, Aug 08 2017

HASSUG August Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://meetu.ps/3bNw8M

Meeting Agenda:

11:30 – 11:45 – Networking & Lunch
11:50 – 11:55 – Announcements
11:55 – 12:55 –
Query Store – The Good, the Bad and the Ugly by Amit Parikh

When

iCal
UTC : Tue, Aug 08 2017 16:30 - 18:00
Event Time : Tue, Aug 08 2017 11:30 - 13:00 Central Daylight Time
Your Local Time: Tue, Aug 08 2017 16:30 - 18:00

Where

10111 Richmond Ave, Suite 100
Houston, Texas

Direction: None

Featured Presentation

Query Store – The Good, the Bad and the Ugly

Speaker: Amit Parikh, Senior Consultant Quest

Summary: 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 briefly discuss how Quest can help with managing SQL Server query performance.

About Amit: My career in Information Technology spans 20 years where I've held various roles both in management and as an individual contributor. I'm currently a Senior Consultant on Quest's Information Management Pre-sales team. As a trusted advisor both internally within the organization and externally with my clients, my aim has always been to solve challenges that businesses face with technology based solutions that help achieve goals and create success. Over the years I've had the fortune of speaking at numerous conferences, symposiums and user groups worldwide and consider myself to be an effective communicator, which enables me to work with all levels of management and project team members, stakeholders and users. My notable specialties are in areas such as Applications and Database Performance Management, End User Monitoring, Database Benchmarking and Performance Tuning, Database Administration and Development as well as Enterprise Architecture. My current and future interests have propelled me into areas such as Data Protection, Virtualization, Business Services Management and Cloud Management. On a personal note, my interests include sports of all kinds, travel and motorcycling. I'm currently based in the Dallas/Fort Worth area.

Attachments

Welcome to the Houston Area SQL Server Users Group