Meetings take place every third Tuesday of the month.
Tuesday, April 18th, 2017
Note: This session is a recording from the 2016 PASS Summit
Intro to Internals: How to Think Like the SQL Server Engine
When you pass in a query, how does SQL Server build the results? Time to role play: Brent will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, sargability, fill factor, and corruption detection.
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the Microsoft MVP award.
5:30 - Professional Networking & Food
6:00 - Announcements
6:15 - Featured Presentation
7:15 - Prize Drawings
1401 North Meridian St.
Indianapolis, IN 46202