Sales Ended

SQL Soton UG Meeting - 6th December , 2017

Event Information

Share this event

Date and Time

Location

Location

2 Venture Road

Chilworth

Southampton

SO16 7NP

United Kingdom

View Map

Friends Who Are Going
Event description

Description

Welcome to Southampton SQL Server User Group, this event is hosted at 2 Venture Road, Southampton Science Park near Chilworth. When entering the Science Park, turn off the A27 onto Univeristy Parkway. Not Manor Road.

Please be aware that in order to attend we need you to register in advance as there is limited space and we need to know how many people to order pizza for, thanks :-)

We have a single speaker this month which allows us to have a slightly longer session. Please note, this will be a remote session and we will have a web cam set up so that we can see and talk to Glenn.

Agenda

18:15 - Doors Open

18:30 - Introductions

18:45 - Erin Stellato - Answering the Question, "What Happened?" with Query Store

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

20:15 - Prize Draw & Close

Speaker Bio

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Sponsors

A massive thanks to our sponsors, without them we would not be able to host this event for free.

SpectrumIT

Pluralsight

Redgate

SpectrumIT kindly provide funding for the room pizza and a £20 Amazon Voucher.

Pluralsight kindly provide two one month free passess to their Excellent training content.


Share with friends

Date and Time

Location

2 Venture Road

Chilworth

Southampton

SO16 7NP

United Kingdom

View Map

Save This Event

Event Saved