Next Meeting: Wed, Jun 03 2015
FoxPASS June 2015 Meeting
Language: English
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/D04W17N7
RSVPURL: http://fox-pass-sql.eventbrite.com/
Calling anyone who works with SQL Server indexes (that's you!)! Time to learn about index from Andy Yun!
When
iCal
UTC : Wed, Jun 03 2015 22:30 - 00:30
Event Time : Wed, Jun 03 2015 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Jun 03 2015 22:30 - 00:30
Where
4351 W College Ave Suite 210
Appleton, Wisconsin
Direction: This is the Concordia University just off Hwy 41 & College Ave.
Featured Presentation
Cleaning House: The Indexing Edition
Speaker:
Andy Yun, Senior Solutions Engineer SentryOne
Summary:
Do you design your database's indexes? Well, have you ever analyzed how those indexes are being used, if at all? And do you know if SQL Server needs other indexes to improve performance? Attend this session and discover how SQL Server tracks actual index usage. We will use this data to identify wasteful, unused, & redundant indexes. Finally, we will dive into the Missing Index DMV and learn how to make proper use of its recommendations. We will spend the second half of this session interactively working through a demo exercise, to reinforce the entire process.
About Andy:
Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for over 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.
Attachments