Orlando SQL Server Users Group

Upcoming Events

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, Technical Solution Professional 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 nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews 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, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.

Register for OPASS May Meeting W/ Brad Gall!

Regular Meeting Location & Agenda

 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.

Thank you to our Sponsor!



 

Upcoming Events

 

Event: OPASS/MagicPASS User Group Meeting
Location: Nova Southeastern University
Address: 4850 Millenia Boulevard
Orlando, FL 32839
Date: April 19th, 2016
Time: 6:00 PM - 9:00 PM

 

OPASS 2015 Quarterly Sponsors

 

 

 

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