sql server training course

							SQL Server Architecture,
Internals and Optimisation                                                                                    Course Outcomes:
with Microsoft author                                                                                         At the end of this course, the students will


Kalen Delaney.
                                                                                                              be equipped with the knowledge to:
                                                                                                              • Examine details of SQL Server’s internal
                                                                                                                structures to determine their impact on
Kalen will be in Australia to present this workshop in February 2008...                                         query performance
seats are strictly limited so don’t miss your opportunity to learn from                                       • Use the SQL Server 2005 Dynamic
one of the world’s leading experts in SQL Server Internals!                                                     Management Objects to determine
                                                                                                                SQL Server’s internal behaviour
Course Summary:                                               Who Should Attend:
This comprehensive workshop has been developed                This course is invaluable for all               • Read graphical and text-based query

by one of the world’s leading experts in SQL Server           professionals involved in advanced                plans to determine where a poorly
internals. Topics to be covered include:                      solutions for SQL Server, including               performing query needs tuning
• Physical Storage Structures                                 Database and Application                        • Determine if concurrency issues are
• Index Design and Performance Tuning                         Developers, Database Administrators,              causing problems with performance
• Query Processing and Query Plans                            Architects and Database Analysts.
                                                                                                                and troubleshoot those problems
• SQL Server Architecture and Metadata                        Kalen gives participants an in-depth            • Use the SQL Server 2005 Graphical
• Optimisation and Recompilation                              understanding of the mechanics
• Concurrency Control: Locking, Blocking and                                                                    Tools such as Profiler to determine how
                                                              and internals of SQL Server in
  Row Level Versioning                                                                                          SQL Server is performing, and to use
                                                              order to monitor, understand and
• Query Tips and Techniques                                   improve performance of database                   those tools as a basis for improving
• Troubleshooting Tools                                       applications.                                     performance

 Brisbane 18th-22nd February                           Sydney 25th-29th February

              Author & Facilitator: The author of the best selling books Inside SQL Server 2000,
              Inside SQL Server 2005 – The Storage Engine and Inside SQL Server 2005 – Query Tuning and
              Optimization, Kalen has been a columnist for SQL Server Magazine since the first issue as well
              as writing for MSDN and TechNet Magazines. Kalen’s SQL Server seminars have been delivered
              both internally for Microsoft events and as recommended training for premier Microsoft
              partners around the world.




www.wardyit.com                                      contact@wardyit.com
Call 1300 927 394 to register for this course today as places are strictly limited.