<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Mike McQuillan
»
Guide to MCITP: SQL Server 2008 BI Developer...
22 posts, Page 1 of 3
1
2
3
»
»»
Guide to MCITP: SQL Server 2008 BI Developer
Rate Topic
Display Mode
Topic Options
Author
Message
mike.mcquillan
mike.mcquillan
Posted Thursday, May 10, 2012 10:47 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, November 22, 2012 8:43 AM
Points: 500,
Visits: 280
Comments posted to this topic are about the item
Guide to MCITP: SQL Server 2008 BI Developer
Post #1298335
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 11, 2012 12:04 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
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
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1298347
BarneyL
BarneyL
Posted Friday, May 11, 2012 1:11 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:05 AM
Points: 318,
Visits: 640
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
Post #1298368
brian.healy
brian.healy
Posted Friday, May 11, 2012 1:39 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 8:44 AM
Points: 107,
Visits: 122
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
Post #1298382
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 11, 2012 1:43 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
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
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1298385
brian.healy
brian.healy
Posted Friday, May 11, 2012 1:46 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 17, 2013 8:44 AM
Points: 107,
Visits: 122
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.
Post #1298388
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 11, 2012 1:50 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
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 :)
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
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1298390
turtleemu
turtleemu
Posted Friday, May 11, 2012 6:22 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:07 PM
Points: 1,
Visits: 53
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.
Post #1298522
Timothy A. Grove
Timothy A. Grove
Posted Friday, May 11, 2012 6:59 AM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, February 02, 2013 3:26 PM
Points: 6,
Visits: 37
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?
Post #1298558
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 11, 2012 7:03 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
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
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1298562
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
