-
Mark S. Rasmussen 4.17
Description:
This is a 4 hour session aimed at developers who use SQL Server in their daily work. While the title says 101, we'll go deep into various subjects. After attending this presentation, you should have a much broader knowledge of what governs SQL Server performance, how to tune & select indexes, analyze how the SQL Server is performing and what time is spent on.
Agenda: Storage, indexes, index maintenance, query optimization, plan caching, wait statistics, GUIDs, performance counters, database best practices.
Awesome course! Really nice to see how Mark has hands-on experience on every bit of SQL and well augmented opinions about how to do stuff the right way. Things like not just to throw more hardware at a given performance issue, but actually get your hands dirty and check the conditions of the databases and do some thoughts on how partitioning the physical disks will and can affect SQL server.
Presentation was delivered in a good tempo, well thought and perfectly executed, with a lot of “before and after”-scenarios samples proving Marks arguments.
Will attend Marks sessions anytime!