Sign up to be the first get notified about SQL Server 2008 and Visual Studio 2008 exams and receive 40% off!
http://www.microsoft.com/learning/mcp/sqlvs/offer/default.mspx
Iman Eftekhari's blog about Microsoft Business Intelligence, and other geeky stuff...
Sign up to be the first get notified about SQL Server 2008 and Visual Studio 2008 exams and receive 40% off!
http://www.microsoft.com/learning/mcp/sqlvs/offer/default.mspx
Today was my last day at SDM. I'm going to join the "contractors club" to experience a new type of work and want to be an independent consultant in the near future. Hence I'm starting a contract role in Tenix on a large-scale data migration project.
Working at SDM was a great experience for me and I have learned a lot and made some good friendships over the 1 year working with them.
Today I passed 70-551 (a tough one!) and upgraded my MCAD to MCPD. The exam was devided in 3 sections and each section was contained of 30 Questions:
Time for each section was around 70 minutes which seems not to be enought.Once you finish one section, you can't go back to that section again. Passing score is 700.
The first section was specific to web applications and it has a bunch of question with mobile pages, web forms and new web controls like webparts, login, profiles, site map and master page as the main topics.
The second part of the exam was the hardest one, it was related to framework and types with security attributes, xml serialization attributes, class design and generics in its topics.
The third part was the architecture one and it was lot of logical questions about designing solutions, unit testing, code coverage and integration test and best practices.
Check out this links:
The latest Community Technology Preview of SQL Server 2008 is available.
SQL Server 2008 CTP6 is "feature complete," which means that Microsoft won't be adding or removing features between now and RTM later this year.
SQL Server 2008 February CTP 6 can be downloaded from here

In this 9 minutes video, Tom Casey (general manager SQL Server Business Intelligence at Microsoft) gives an overview of BI in SQL Server 2008 (code name Catmai)
Integration Services in SQL Server 2008
Reporting Services in SQL Server 2008
Analysis Services in SQL Server 2008
Source: MS Clinic 6189: What’s New in Microsoft® SQL Server™ 2008 for Business Intelligence

Prometric already listed the exam on its site.
The official preparation guide for the exam:
I found these links very helpful:
Note: SSIS SCD control only supports Type1 and Type2. But by identifying columns with the fixed attribute update type, you can capture the data values that are candidates for Type 3 changes.
| Slowly Changing Dimension Transformation Outputs | ||
| Output | Description | Data flow requirements |
| Changing Attributes Updates Output | The record in the lookup table is updated. This output is used for changing attribute rows. | An OLE DB Command transformation updates the record using an UPDATE statement. |
| Fixed Attribute Output | The values in rows that must not change do not match values in the lookup table. This output is used for fixed attribute rows. | No default data flow is created. If the transformation is configured to continue after it encounters changes to fixed attribute columns, you should create a data flow that captures these rows. |
| Historical Attributes Inserts Output | The lookup table contains at least one matching row. The row marked as “current” must now be marked as "expired". This output is used for historical attribute rows. | Derived Column transformations create columns for the expired row and the current row indicators. An OLE DB Command transformation updates the record that must now be marked as "expired". The row with the new column values is directed to the New Output, where the row is inserted and marked as "current". |
| Inferred Member Updates Output | Rows for inferred dimension members are inserted. This output is used for inferred member rows. | An OLE DB Command transformation updates the record using an SQL UPDATE statement. |
| New Output | The lookup table contains no matching rows. The row is added to the dimension table. This output is used for new rows and changes to historical attributes rows. | A Derived Column transformation sets the current row indicator, and an OLE DB destination inserts the row. |
| Unchanged Output | The values in the lookup table match the row values. This output is used for unchanged rows. | No default data flow is created because the Slowly Changing Dimension transformation performs no work. If you want to capture these rows, you should create a data flow for this output. |