SQL 2012 Administration: Trace Flags, Blocking, and Locking
Trace flags are curious things. They actually change the fundamental ways that SQL Server functions. Sometimes these changes are good, sometimes bad, and sometimes just down right odd.Join Chris Bell as he introduces you to some of the trace flags in SQL Server 2012, discussing what they do and what they can actually be used for.Afterwards Chris will present a common occurrence in SQL Server: Blocking. What is it, why does it happen, how can you get more information to help resolve a blocking scenario? These will all be answered along with a quick look into a special, and hopefully rare type of blocking scenario, the Deadlock.
Chris Bell, MCITP, is an 18-year SQL Server veteran for both business intelligence and application development providing solutions for businesses, organizations, and individuals. He is the founder and CEO of WaterOx Consulting, Inc., a provider of remote SQL Server consulting and services. Chris is also the founder and current President of the Washington DC chapter of PASS and a member of the Board of Directors for CPCUG. Chris also frequently attends and presents at PASS events around the country, sharing his passion for all things SQL Server. In 2012, Chris was one of 5 finalists in the world for Red Gate&rsquo;s Exceptional DBA Award.