Saturday, September 30, 2006

MCITP: Business Intelligence Developer

Microsoft has just released an update to the Microsoft Certified IT Professional (MCITP) with the creation of Business Intelligence Developer credential. It looks like you only need to sit two exams to become a Business Intelligence Developer.

This qualification is a step up from the Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI).

The training material is available but the exams are not available until early 2007. It might be a good time to start looking into getting this certification.

Check out:

MCITP: Business Intelligence Developer
MCTS: SQL Server 2005 Business Intelligence

Saturday, September 16, 2006

Tips, Tricks, and Advice from the SQL Server Query Optimization Team

A colleague of mine has just introduced me to one of the best blogs I have seen in along while. The Tips, Tricks, and Advice is brought to you by the SQL Server Query Optimization Team.

Here are some of my favourite posts on the performance features of SQL 2005 Query Optimizer. Check out the following:

Tuesday, September 12, 2006

SQL Server 2005 Skill Assessments

Microsoft has released a series of free skill tests that are well worth trying. There are tests covering most Microsoft products. There are two categories that I have given a go.

  • Introduction to SQL Server 2005 (DBA, Developer, BI): SQL 2005
  • Introduction to SQL Server 2000 Reporting Services: RS 2000

Monday, September 04, 2006

This Months Book Recommendation: Microsoft Data Warehouse Toolkit

After TechEd I realised that in my slide deck I did not recommend The Microsoft Data Warehouse ToolKit by Joy Mundy and Warren Thornthwaite as required reading before starting a BI project.

If you are new to BI or new to the SQL Server 2005 BI platform this book is a great starting point. This book covers an end to end BI solution on the SQL server 2005 platform. The book covers a Reference Architecture for implementing a Microsoft BI Solution.

The book also includes a case study using the Adventure works example database as the source for an end to end BI solution. All the sample code can be downloaded from www.msftdwtoolkit.com