Kevin Kline is a noted database expert and software industry veteran. A Microsoft Data Platform MVP since 2003 and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.org), as well as the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends & Applications magazine (DBTA.com). He tweets at @kekline and blogs regularly. Kevin is a Head Geek at SentryOne, a leading vendor of IT and database tools.
Let’s face it. You can effectively do your job of writing code of how SQL Server works. Many great developers, DBAs, and architects get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes of their computer systems. But if you want to take your dev skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - What happens during checkpoints? Lazywrites? - How are IOs handled with regards to transaction logs and database? This fast paced session will take you through many aspects of the internal operations of SQL Server which you can use to ensure your code performs at its best.