Free

SQL Soton UG Meeting - August 2nd, 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 - Glenn Berry - Dr. DMV's Troubleshooting Toolkit

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases. This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.

20:15 - Prize Draw & Close

Speaker Bio

Glenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

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