Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.

Scaling SQL Servers is complex and is more relevant today as the transactional and data growth rates continue to grow. In this session, we will talk about what it takes to scale SQL Server to meet the peak workload.