Expert Picks

Need for Speed: Top Performance Picks

By Erin Stellato, PASS Performance Virtual Chapter President


Monday, November 5

8:30am - 4:30pm

Pre-Con: Practical SQL Server Performance Troubleshooting
(DBA-398-P) - Klaus Aschenbrenner  

Tuesday, November 6

8:30am - 4:30pm

Pre-Con: Query Performance Tuning: Start to Finish
(AD-399-P) - Grant Fritchey

Wednesday, November 7

1:30pm - 4:30pm

Query Optimizer Deep Dive
(AD-400-HD) - Paul White
4:45pm - 6:15pm

Maintain SQL Server System and Performance Data with PowerShell
(DBA-319-S) - Allen White
4:45pm - 6:15pm

Choose Your Own Adventure: Performance Tuning
(DBA-408-S) - Thomas LaRock and Tim Chapman

Thursday, November 8

10:15am - 11:45am

Query Tuning Mastery: The Art and Science of Manhandling Parallelism
(AD-501-S) - Adam Machanic
10:15am - 11:45am

Querying and Optimizing DAX
(BIA-321-S) - Alberto Ferrari
1:30pm - 2:45pm

ColumnStore Indexes: The Turbobooster Inside SQL Server 2012
(BIA-311) - Klaus Aschenbrenner
3:00pm - 4:30pm

Database Design Throwdown
(AD-322-S) - Thomas LaRock and Karen Lopez
5:00pm - 6:15pm

A Developer's Guide to Dangerous Queries
(AD-203) - Jeremiah Peschka
5:00pm - 6:15pm

Index Psychiatry: Diagnose and Treat the Top 5 Disorders
(AD-204) - Kendra Little
5:00pm - 6:30pm

Diagnose T-SQL Performance Problems Fast with sp_Blitz
(DBA-320-S) - Brent Ozar
5:00pm - 6:30pm

Improve Query Performance by Fixing Bad Parameter Sniffing
(AD-210-S) - Grant Fritchey

Friday, November 9

8:00am - 9:15am

Configuring the OS for Optimal SQL Server Performance
(DBA-202) - Brad McGehee
8:00am - 9:15am

Troubleshooting SQL Server 2012 Performance with Extended Events
(DBA-407-C) - Rohit Nayak
9:45am - 11:15am

Performance Tuning Through the Plan Cache
(DBA-409-S) - Jason Strate
1:00pm - 2:15pm

Optimizing Your BI Semantic Model for Performance and Scale
(BIA-402-M) - Allan Folting
1:00p - 2:15pm

Optimizing SQL Server I/O with Solid State Drives
(DBA-205) - Luke Jian


Why Attend?