< Return To Course List
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
Target Audience
Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others
Prerequisites
This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation
Expected Duration (hours)
1.3
Lesson Objectivesrecognize how locking is used to secure data integrity in a SQL Server database.
detect and end deadlocks and blocking connections in a given scenario.
detect and terminate a transaction lock.
connect to the server using the dedicated administrator connection (DAC) in a given scenario.
connect to a non-responsive database using the dedicated administrator connection (DAC).
Course Number:
234730_eng
Monitoring and Diagnosing Database Problems in SQL Server 2005
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
Target Audience
Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others
Prerequisites
This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation
Expected Duration (hours)
1.3
Lesson Objectives
Monitoring and Diagnosing Database Problems in SQL Server 2005
234730_eng
Copyright© 2010 SkillSoft - All Rights Reserved