Selecting SQL Server Services to Support Business Needs
o Overview of the Built-in SQL Server Services
o Evaluating When to Use the New SQL Server Services
o Evaluating the Use of Database Engine Enhancements
Designing a Security Strategy
o Overview of Authentication Modes and Authorization Strategies
o Designing a Security Strategy for Components of a SQL Server 2005 Solution
o Designing Objects to Manage Application Access
o Creating an Auditing Strategy
o Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Designing a Data Modeling Strategy
o Defining Standards for Storing XML Data in a Solution
o Designing a Database Solution Schema
o Designing a Scale-Out Strategy
Designing a Transaction Strategy for a SQL Server 2005 Solution
o Defining Data Behavior Requirements
o Defining Isolation Levels
o Designing a Resilient Transaction Strategy
Designing a Notification Services Solution
o Defining Event Data
o Designing a Subscription Strategy
o Designing a Notification Strategy
o Designing a Notification Delivery Strategy
Designing a Service Broker Solution
o Designing a Service Broker Solution Architecture
o Designing Service Broker Data Flow
o Designing Service Broker Solution Availability
Planning for Source Control, Unit Testing, and Deployment
o Designing a Source Control Strategy
o Designing a Unit Test Plan
o Creating a Performance Baseline and Benchmarking Strategy
o Designing a Deployment Strategy
Evaluating Advanced Query and XML Techniques
o Evaluating Common Table Expressions
o Evaluating Pivot Queries
o Evaluating Ranking Queries
o Overview of XQuery
o Overview of Strategies for Converting Data Between XML and Relational Formats
