How To Kill SQL Server In 75 minutes
Speaker: Dmitri Korotkevitch
Summary: It is easy to design a system that uses SQL Server as a database backend. However, designing a system that efficiently works under heavy load is a much more complicated task. You can encounter the same set of database design and code mistakes in almost every system implemented by a team of application developers.
This Power Point-free session shows the commonly encountered obvious and not-so-obvious database design and T-SQL code mistakes. It'll demonstrate how to bring a perfectly healthy SQL Server to its knees in just 75 minutes.
About Dmitri: Dmitri Korotkevitch is a Microsoft SQL Server MVP, Microsoft Certified Master (SQL Server 2008) and author of "Pro SQL Server Internals" with almost 20 years of IT experience including over 14 years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock.
Configuration Option and Trace Flag Secrets: Surprising Behavior at the Flick of a Switch (Video Replay)
Speaker: Kevin Kline
Summary: If you've been a SQL Server DBA or Dev for any length of time, you've probably heard of various options that you can set at the instance- or database-level that can impact performance. Do you know what they are, when to use them, or what they do? And what about all of those trace flags? There are so many of them and many are undocumented. What gives? In this session, you'll learn about a variety of ways to speed up IO, adjust memory, change plan and buffer cache behavior, debug the SQL query optimizer, and how to punch SQL Server in the face!