Unit 1: Minimizing and Handling Database Operation Conflicts
- Why Do Data Conflicts Arise?
- Isolation Levels Available in SQL Server 2005
- Guidelines for Using SQL Server 2005 Isolation Levels
Unit 2: Handling Large Objects
- What Are Binary Large Objects and Character Large Objects?
- The Process for Reading Large Objects from a Database
- The Process for Writing Large Objects to a Database
Unit 3: Enhancing Database Performance
- ADO.NET Enhancements in the .NET Framework 2.0
- SQL Server Provider Statistics
Unit 4: Creating Managed Code Objects for SQL Server 2005
- The Benefits of Creating Managed Code Objects
- Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005
- Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005
Unit 5: Querying XML by Using XPath
- The XPath Data Model
- The Process for Selecting and Editing XML Data by Using XPathNavigator
- The Process for Evaluating XPath Expressions by Using XPathNavigator
Unit 6: Transforming XML by Using XSLT Style Sheets
- What Is XSLT?
- The Process for Executing an XSLT Style Sheet
What Are Extension Objects?