MCTS & MCITP Certifications for SQL Server 2008 BI

Last week I got the results of those beta exams (71-448, 71-452) and surprisingly, I passed both!

The surprise was because I passed them though I hadn't had a chance to work with SQL Server 2008 in a real project before, and that means there is something wrong with the exams that you can pass them based on your SQL Server 2005 experience and just reading about new features of the 2008 version.

But the good thing is that I've passed them and there is nothing to worry about till the next version! The next version of SQL Server code-named "Killimanjaro", will be released in the first half of 2010, according to Microsoft officials. The first tech preview test builds of Kilimanjaro are due in the first half of 2009. It will provide the foundation for Microsoft's first data warehouse appliance, code-named Madison, and a BI tool called Gemini that's being designed to bring a broader range of employees into the BI fold.

A feedback on 71-452 (70-452) exam: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

I sat on that beta exam yesterday and here are some points:

• There are 75 questions and the time is 3 hours which is a bit tight
• Unlike 70-446, there is no case scenario and all questions are standalone (not related to each other)
• Many data mining questions. Mostly about choosing the best algorithm.
• A few around upgrading and migration strategy
• Many questions about new features in SQL 2008, like CDC, MERGE, …
• From the name of exam, I expected to see more “Design” related questions, but there were many development questions which I think they could be moved to the TS exam (70-448)

As usual I recommend you to have a look at the topics here and work on those that you are not familiar with.

I must wait for few weeks to get the result. Fingers crossed!

An excellent quote

"The world is governed more by appearances than realities, so that it is fully as necessary to seem to know something as to know it. "
- Daniel Webster"

2008 CIO Technology Priorities

According to a survey by Gartner "Business Intelligence Applications" is the highest priority for CIOs. Here is the top 10 result:

SQL Server 2008 RTM

Download SQL Server 2008 Enterprise 180-day evaluation from here:

• Trial Experience for Developers
• Trial Experience for IT Professionals

SQL Server 2008 Feature Pack (August 2008). It contains 17 new redistributable and backward compatibility components and add-on providers. Download it from here:

• SQL Server 2008 Feature Pack - Aug 2008

Have you ever wondered what the last meeting before a product ships is like? Have a look at inside the SQL 2008 ship room!.

A feedback on beta exam 71-448 (70-448)

I'm just coming back from MS beta exam 71-448 (TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance). There were too many questions (70!) and the time was around 3 hours which was more than enough.

It was a bit disappointing that not many questions were specifically related to SQL Server 2008 new features -not even 5 questions were specific to that!- so if you don't know much about the new features, don't worry!

SSAS: · many admin tasks · a few MDX · dimension settings · attribute properties · performance monitoring and tuning · using profiler for monitoring user roles · cube processing options · deployment options · setting permission

SSRS: · security · backup the SSRS database · setting parameters · assembly file · custom control · failover environment

SSIS: · a few questions around SSIS package configuration · transaction · a couple of Foreach loop (file)

Data Mining: · a few DMX questions

In total it was not tough if you have passed the 70-445 (SQL 2005) exam, you just need to review the topics from Microsoft website and play around the topics that you haven’t had chance to work on them.

Good luck!

SQL Server 2008 RC0

Microsoft just released SQL Server 2008 RC0 (Release Candidate 0). It is expected that this will be the final release prior to SQL Server 2008 RTM in Q3/Q4 this calendar year. You can download it from here:

SQL Server 2008 RC0

New for this CTP are the AdventureWorks 2008 family of sample databases:

AdventureWorks 2008 sample database

SSIS: Passing parameters from parent to child package

When using “Execute Package Task” in SSIS control flow, you can’t pass in any configuration options or variables to the child package. Here is a workaround to do that:

1. In the parent package, create a variable for each variable you want to set in child package. It must be defined as a global variable.

2. In the child package, create variables to correspond to the ones you created in the Parent package (e.g. “ChildVar” to correspond to “ParentVar”). Important: assign these variables valid default values, otherwise you will not be able to run the child package standalone.

3. In the child package, open the package Configurations. Add a new configuration, and select the “Parent package variable”. Enter the variable name you added to the parent package (in our example “ParentVar”). Note that variables are case sensitive. Assign this to the variable of the child package (”ChildVar”).

Now when you run the parent package, it will pass the value of the “ParentVar” to the “ChildVar”. When you run the child package directly (without a parent package), it will use the default value of the “ChildVar”.

A bug in ASP.Net 2.0 Gridview control and ...

I don’t know why it has to be like this! I know BUG is a non-detachable part of software development and according to a Murphy’s law: "Each computer code has five bugs, and this number does not depend on how many bugs have been already found." (!?)

But, when a bug was found and reported to a company like Microsoft, why it should take so long to fix it? And isn't it better if Microsoft add a note or comment in MSDN like: "this is a known bug and here is the workaround..." so that people don't get confused by getting a different result from a sample code? Or maybe Bill Gates wants to make developers more creative?!

To make the long story short, last week after several frustrating hours debugging a Gridview image button which was firing an command event twice, I found it's a known bug in ASP.Net 2.0 and was reported to Microsoft on 2006, and yet to be fixed! The funny thing is it works fine when you have a LinkButton instead of ImageButton.

I finally found a workaround for this:

Put your imagebutton in an ItemTemplate and add:

commandargument="<%# DataBinder.Eval(Container,"RowIndex") %>"

The rest is same as other Gridview commands, you need to write your code in RowCommand event of the Gridview and find the index of the row like this:

Dim index As Integer = Convert.ToInt32(e.CommandArgument) Dim myRow As GridViewRow = CartGrid.Rows(index) If (e.CommandName = "YourCommandName") Then ....

Have a look at this page, (a frustrated developer was trying to get help about this issue and answer of Microsoft Online Support...):

http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic16694.aspx

"First to Know" Visual Studio 2008 and SQL Server 2008 exam offer

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