Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Guide to MCITP: SQL Server 2008 BI Developer Expand / Collapse
Author
Message
Posted Thursday, May 10, 2012 10:47 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:36 AM
Points: 500, Visits: 294
Comments posted to this topic are about the item Guide to MCITP: SQL Server 2008 BI Developer
Post #1298335
Posted Friday, May 11, 2012 12:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
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
Posted Friday, May 11, 2012 1:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 440, Visits: 762
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
Posted Friday, May 11, 2012 1:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:08 AM
Points: 166, Visits: 153
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
Posted Friday, May 11, 2012 1:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
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
Posted Friday, May 11, 2012 1:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:08 AM
Points: 166, Visits: 153
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
Posted Friday, May 11, 2012 1:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
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
Posted Friday, May 11, 2012 6:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 7:16 AM
Points: 10, 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.
Post #1298522
Posted Friday, May 11, 2012 6:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 11, 2014 9:21 PM
Points: 9, Visits: 59
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
Posted Friday, May 11, 2012 7:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse