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