Next Meeting

Wednesday,

August

12

OPASS and MagicPASS August 2015 Meeting W/ David Pless

  • In-Person @ 4850 Millenia Blvd, Orlando, Florida, United States (map)
  • 18:30 - 20:30 Eastern Daylight Time
  • Language: English

The Orlando SQL user group(s) OPASS and MagicPASS feature a different speaker every month covering a variety of topics. This is a free event centered around Microsoft SQL server, where everyone is welcome and encouraged to attend. Come join us for free learning, networking, food, and fun.

Featured Presentation:

SQL SERVER 2016 PLAN GUIDES AND QUERY STORE

David Pless, Senior Premier Field Engineer Microsoft

Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL Database V12. Query Store is designed to help with query performance troubleshooting by making it easier to identify poorly performing statements and finding scenarios where performance regresses. In this session we will discuss how Query Store can help you identify the changes in query plans and figure out when performance regressions occur. We will cover how Query Store collects and presents detailed historic information and how it can be used to reduce the time it takes to diagnose and resolve issues. If a query generates different plans, you can use Query Store to analyze the plan changes, identify possible performance degradation, and even force the query processor to use a particular plan for your query. We will also cover how plan guides allows you to optimize the performance of queries when you cannot directly change the text of the actual query in SQL Server. Plan guides can be useful when a small subset of queries in a database application (example: third-party vendors) are not performing as expected.

About David:
For the past eight years, I have been a Senior Premier Field Engineer with Microsoft. As a PFE I perform health checks, conduct full training workshops, I also work on reactive and proactive engagements on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world. My core areas are Performance Tuning and Optimization, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more

Register for OPASS and MagicPASS 2015 w/ David Pless!

 Meeting Time

We typically meet on the last Thursday of each month from 6:30PM - 8:30PM

 NEW Meeting Location

Cork and Olive

1061 S. Sun Drive Ste. 1009 Lake Mary, FL 32746

We normally start with about 10 minutes of news and announcements.  We then have 10-15 minutes of networking.  Right before the food is served, we give our sponsor for the month a chance to present for 10-20 minutes.  At about 6:45 we start our feature presentation. Finally we end by raffling off any SWAG our sponsors have graciously supplied.

 

Sign up here for news, and join us on our LinkedIn group for networking, discussion, and job posts.