Designing Efficient Application Access

PrerequisitesThree or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, implementing databases at the physical level, and gathering business requirements

Target AudienceDevelopers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005. individuals looking to pass the 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path

LessonsDesigning Server Management Object Applications| - recognize how to use the Server Management Object to design server applications.|Designing Replication and Automation Management Objects| - recognize how to design the Replication Management Objects and the Automation Management Objects.|Designing SNI for Asynchronous Queries| - recognize how to design the SQL Server Networking Interface (SNI) protocol layer for asynchronous queries, TDS endpoints, and management of endpoints.|Introduction to Multiple Active Result Sets| - distinguish Multiple Active Results Set (MARS) for queries and the concept of row versioning in MARS.|Creating Queries Using MARS| - recognize how to configure MARS in the SQL Native Client Providers and configure the deadlock monitor to remove MARS deadlocks.|Replication Management and Multiple Active Result Sets| - design and utilize the Replication Management Objects, Automation Management object and Multiple Active Results Set (MARS) for queries and row management.|

Test Prep

Simulations