Exam 70-442 Objective 5

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 5 (Performance Tuning a Database and a Database Application) and received only 32%.  I've got a bit of study to do, specifically:

1. Optimize and tune queries for performance
   Creating Partitioned Views
   Table Hints (Transact-SQL)
   SET ANSI_PADDING (Transact-SQL)
   Introducing SQL Trace
   max degree of parallelism Option
2. Optimize indexing strategies
   XML Best Practices
   Planning Guidelines for Partioned Tables and Indexes
   Creating Partitioned Tables and Indexes
3. Scale database applications
   Creating Distributed Partitioned Views
4. Resolve performance problems
   Dynamic Management Views and Functions (Transact-SQL)
   Performance Optimizations for the XML Data Type in SQL Server 2005
   sys.dm_os_wait_stats (Transact-SQL)
5. Optimize data storage
   Data Normalization

Exam 70-442 Objective 4

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 4 (Designing a Transaction Strategy) and received 100%.  However, I've still got a bit of study to do, specifically:

1. Manage concurrency by selecting the appropriate transaction isolation levels
2. Design the locking granularity level
3. Design transaction scopes
4. Design code that uses transactions
   Optimization using Single Phase Commit and Promotable Single Phase Notification
   Committing a Transaction in Single-Phase and Multi-Phase
   Enlisting Resources as Participants in a Transaction
   Transaction Management Escalation

Exam 70-442 Objective 3

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 3 (Designing Error-Handling Routines) and received only 78%.  I've got a bit of study to do, specifically:

1. Design code that validates input data and permissions
2. Design code that detects and reacts to errors
3. Design user-defined messages to communicate application events
   FETCH (Transact-SQL)

Exam 70-442 Objective 2

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 2 (Designing a Database Query Strategy) and received only 60%.  I've got a bit of study to do, specifically:

1. Write and modify queries
   Declarative Security Used with Class and Member Scope
2. Design queries for retrieving data from XML sources
   How To: Use Role Manager in ASP.NET 2.0
3. Design a cursor strategry
   DECLARE CURSOR (Transact-SQL)

Exam 70-442 Objective 1

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 1 (Designing Efficient Access to a SQL Server Service) and received only 46.8%.  I've got a bit of study to do, specifically:

1. Design appropriate data access technologies
   ServerConnection Class
   Special Considerations When Using Query Notifications
   Query Notifications in ADO.NET 2.0
   Database Administrator's Guide to SQL Server Database Engine .NET CLR Environment
   Connecting to an Instance of SQL Server
   ADO.NET Architecture
2. Design an appropriate data access object model
   Updating an Application to SQL Server Native Client from MDAC
   Using ADO with SQL Server Native Client
   Using Row Versioning-based Isolation Levels
   Understanding Row Versioning-Based Isolation Levels
   Row Versioning Resource Usage
3. Design a cursor strategy for a data access component
   DECLARE CURSOR (Transact-SQL)
4. Design caching strategies
   ASP.NET Caching Overview
5. Design client libraries to write applications that administer a SQL Server service
   Configuring SQL Server in SMO
   A Technical Comparision of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
   How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
   How to: Programmatically Monitor Replication (RMO Programming)
   Microsoft.SqlServer.Replication Namespace
   Replication Management Objects Concepts
6. Design queries that use multiple active results sets (MARS)
   Multiple Active Result Sets (MARS) in SQL Server 2005

Introduction to SQL Server Data Services

When	Thursday 19 February @ 5:30pm
Where	Wellington SQL Server User Group, Intergen Offices, Plunket House, Lambton Quay
What	I presented on SQL Server Data Services
Impressions	Was well received. I started with a question; whether the audience would prefer the presentation I'd prepared, or the Microsoft presentation I had received that morning.  They chose my prepared presentation.  I was a little disappointed because the Microsoft presentation had flash graphics, and I couldn't be blamed for being under-prepared!  Nevertheless, there was a fruitful to-and-fro with the audience: Matty was insightful, as usual. Clive was incredulous and unimpressed with the lack of features provided thus far. Adrian asked a pertenant question afterwards, which I'd like to answer here as it's very relevant to the entire discussion.  He was honest about his (and I suspect many people's) confusion about Azure vs. SSDS. Think of Azure as like a Cloud O/S. Think of SSDS as like a Cloud DB. Yes, you could store blobs and entities to Azure, but over time you really shouldn't be, because Microsoft is going to add more functionality to SSDS to enable relational queries, backup, restore, and BI. My slides are here. Microsoft's slides are here.

Agenda Items for Team Meeting

Telecom Workgroup Solutions Team are having our AGM on Wednesday 25 February, this time in Auckland. Items for discussion so far are:

• Team Foundation Server. When are we going to it? What are the implications? Should we just join Stephen Burke's team wireless domain (after the move on Friday 6 March) or go it alone?
• David's idea to have a dual install SQL Server 2005 and 2008 on DEV. Merits and potential difficulties.
• Document repository. Guidelines for BLOB vs. Link.
• How to use DocsOnLine.
• My Azure SQL Server Data Services presentation.
• Digital Workflow