Upcoming Meetings  

Wednesday, June 3, 2015 - Cleaning House: The Indexing Edition - Andy Yun 

Join us online: https://meet.lync.com/sqlpass365-sqlpass/fox/D04W17N7 

We meet at Omni Resources, 4351 W College Ave, Appleton WI 54914 
This is the Concordia College building just west of Hwy 41. 

PASS Summit 2015 

Summit is the world’s largest gathering of SQL Server & BI professionals. Take your SQL Server skills to the next level by learning from the world’s top SQL Server experts, in over 190 technical sessions. Register today, and save an extra $150 by using FoxPASS's discount code, LC15KZW5

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! 


Event Time : Wed, Jun 03 2015 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Jun 03 2015 22:30 - 00:30


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 Database Architect/Developer Rise Health

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: Once a DBA, Andy is a Database Architect & Developer. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, Andy strives to make T-SQL leaner and meaner. Passionate about passing his knowledge onto others, Andy actively participates in the SQL Server community, as co-Chapter Leader of the Chicago Suburban User Group, and by speaking at regional User Groups & SQL Saturdays.