Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Guide to MCITP: SQL Server 2008 BI Developer


Guide to MCITP: SQL Server 2008 BI Developer

Author
Message
mike.mcquillan
mike.mcquillan
Say Hey Kid
Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)

Group: General Forum Members
Points: 683 Visits: 440
Comments posted to this topic are about the item Guide to MCITP: SQL Server 2008 BI Developer
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16455 Visits: 13207
Great article! I will use it as a reference for colleagues who still want to do the MCITP.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
BarneyL
BarneyL
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 964
Thanks, I'm due to take the first exam some time soon and this has been very helpful, especially flagging up some of the areas I'll need to cover that I don't deal with in day to day work.
Barney
brian.healy
brian.healy
Old Hand
Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)

Group: General Forum Members
Points: 345 Visits: 173
I agree, this is an excellent article - I could have done with it before I took MCTS/MCITP in the last couple of months (although I did pass).

I think that the MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance book is worth mentioning though. Like you I found MCITP easier because I had some experience of all three BI strands. The MCTS exam is more 'nuts and bolts', e.g. knowing the syntax of dtutil. This book is geared to the exam, and also has MeasureUp self-test exam questions included on a CD. It also has an excellent chapter on Data Mining (one area I don't yet use in my current job), which in my opinion is enough to cover the DM subject matter for both exams. I would certainly not got through MCTS without it, despite 6 years of MS BI experience.

I'd also like to mention (no, I don't work for Microsoft!) the book Reporting Services 2008 Step-by-step. I have more SSRS experience than SSIS/SSAS, but this still taught me the extra 10% I needed, particularly as I am a developer so my administration skills and experience are at a lower level.

I used Kaplan's self-test software (mentioned in the article) to prepare for the MCITP - there appears still to be nothing offered by Microsoft to prepare you. The course 50399A is constantly promised but deadlines come and go without it being published. The self-test was very useful, and did help me answer several questions, particularly on the infrastructure side. My personal belief though is that it was too infrastructure biased and also includes a lot of pure SQL Server-related questions compared with the exam, but that may be just my experience.

Last point - I use SSIS now more than the other two, yet performed worst on the SSIS sections. I think the moral is you have got to know SSIS in detail, particularly what each task/component does, and the bits that maybe you don't use day-to-day like logging and checkpoints. It's frustrating that features many people discredit (such as SSIS logging and SSAS Proactive Caching) and hence may not feature in your day-to-day work you still need to know well to pass!

Brian Healy
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16455 Visits: 13207
brian.healy (5/11/2012)

I think the moral is you have got to know SSIS in detail, particularly what each task/component does, and the bits that maybe you don't use day-to-day like logging and checkpoints. It's frustrating that features many people discredit (such as SSIS logging and SSAS Proactive Caching) and hence may not feature in your day-to-day work you still need to know well to pass!


Euh, you don't use the logging?
You should.

And it's a certification exam. The purpose is that you can show "I know the bits and pieces of that software product", not "I have only worked with features A and B in the past, so I only know those two".



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
brian.healy
brian.healy
Old Hand
Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)Old Hand (345 reputation)

Group: General Forum Members
Points: 345 Visits: 173
Let me clarify that . What I mean is I don't use SSIS integrated logging because it is unwieldy and unflexible - I use custom logging.
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16455 Visits: 13207
brian.healy (5/11/2012)
Let me clarify that . What I mean is I don't use SSIS integrated logging because it is unwieldy and unflexible - I use custom logging.


That makes more sense Smile
I use a combination of the build-in logging and custom logging.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
RandiB1
RandiB1
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 82
Great article, interesting to know that you had an easier time with 70-452. I got my MCTS a year ago and have been thinking about going to do the MCITP since then.

I agree, there are some things covered on the test that no one actually uses, but I also got some useful information from studying for the test. I definately think the process of studying for the test made me a better BI developer.
Timothy A. Grove
Timothy A. Grove
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 72
Quick question: Books Online

I have SQL server 2008 R2 installed, and have the books online menu option. How does one get an updated or newer copy?
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16455 Visits: 13207
Books online or BOL are just the MSDN documentation pages.
Example for SQL Server 2012:
Books Online for SQL Server 2012



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search