Saturday, 29 July 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
New Microsoft SQL Server Certification / Troubleshooting Performance Problems in SQL Server 2005
Author: Victor Isakov Date Posted: 16/02/2006 4:35:26 PM
This month Victor Isakov (MCT, MCDBA, MCSE, MCTS, MCITP) will present two sessions, namely:

1st Session: Microsoft Learning Offerings for SQL Server 2005
Microsoft Learning has created an extensive set of learning products for SQL Server 2005. In this presentation we will look at the full suite of learning products that will be available over the next 4 months, including skills paths, certifications, and availability dates. We will delve into the rational behind the SQL Server 2005 MSL portfolio design and provide a brief overview of the new MSL certification strategy.

2nd Session: Troubleshooting Performance Problems in Microsoft SQL Server 2005
Before SQL Server 2005 the methodology for troubleshooting SQL Server performance problems were ad hoc and limited in nature. With the release of SQL Server 2005 Microsoft has exposed the server state in queryable format through Dynamic Management Views. In this session we will provide an overview of DMVs before examining how to diagnose and troubleshoot performance problems in SQL 2005 using DMVs, looking at the major subsystems: CPU, Memory, I/O, TempDB and slow running queries.

Presenter:
Victor Isakov has been involved with SQL Server since Version 4.21a, enjoying a reputation as one of the best "SQL Gurus" in Australia. He has been an Microsft Trainer since 1995 and consulted for organisations like the University of NSW, DET (NSW), BT Financial Group, Microsoft (Redmond), Westpac and the United Nations. He specialises as a Trainer and a Consultant in Architecting, Optimising and Troubleshooting Database Solutions.
http://www.sqlserver.com.au/user/bio/ViewBio.aspx?bioId=31

Venue: Canberra - Level 2, 44 Sydney Avenue, Barton ACT 2600 | Duration : 5:00PM - Pizzas | Session: 5:30PM until 7:00PM | On: Monday, 27 February 2006