<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
»
Career
»
Certification
»
Slave to 70-450!!
21 posts, Page 1 of 3
1
2
3
»
»»
Slave to 70-450!!
Rate Topic
Display Mode
Topic Options
Author
Message
WWDMark
WWDMark
Posted Thursday, February 07, 2013 7:45 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 3:02 AM
Points: 446,
Visits: 348
Hi all, I'm in need of some advice from some learned peeps regarding study material etc for my 70-450 exam.
I've unfortunately just failed the exam this morning (score of 457!!
).
So, I've been a DBA since Jan 2012 using SQL Server 2008 R2 looking after 5 servers each with an instance of SQL Server supporting up to 15 databases collectively (nothing over 2GB). I've been on the MS course applicable for the 70-450 exam (M50400) and also studied for it using the MS suggested MeasureUp online course tests.
Without breaking the terms of the NDA I can safely say the exam was soooo much more in depth than the MeasureUp questions and included topics that weren't covered in the M50400 course which took me quite by surprise!
I passed my 70-432 exam with a score of 900 back in November and really want/need to pass my 70-450 by the end of March this year....am I being too ambitious or could someone suggest alternative methods of study?
I've been toying with setting up virtual machines to implement security settings, replication/mirroring/failover clustering etc to give me more of a practical angle of study (I also have access to a physical test server that I can play with), what do people reckon, what would you do??
MCITP
MCTS -
E-Business Card
Twitter:
WWDMark
Try not! Do or do not, there is no try
email:
info@weekendwebdesign.co.uk
Website:
www.weekendwebdesign.co.uk
Post #1417077
anthony.green
anthony.green
Posted Friday, March 08, 2013 5:03 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
Unfortunately I'm in the same boat, going to go back and do 70-450 in a couple of weeks if I can find the funds, failed it twice now with a score of 624 each time.
I've been using the MOAC books along with SQL Server 2008 Administration - Real World Skills For MCITP Certification And Beyond and Transcenders but still no luck.
If you have been using other media please let me know and I will most certainly have a look.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1428522
WWDMark
WWDMark
Posted Monday, March 11, 2013 4:15 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 3:02 AM
Points: 446,
Visits: 348
I really do sympathise with you Anthony as I know how gutted I was when I didn't pass (@DBAReactions on Twitter had a great post that expressed it quite well for me actually -
http://goo.gl/pxX1c
)
I since re-booked my exam for the 15th of this month to give me a deadline to work towards and have been pouring over my course material from the course I did with QA Training in Bristol back in March 2012 (Designing, Optimizing, and Maintaining a Database Administrative Solution - course number 50400A) as the majority of the questions are based on that material - have you been on that course as it's recommended by Microsoft (then again so was the measureup practice tests!!!)?
I've also been playing with my testing servers setting up log shipping/replication/mirroring etc to give me the practical experience rather than just replying on the theoretical side of things (we only use transactional replication where I work and that's only so we have a standby copy of the DB which has been in place since the crossbow was a secret weapon - really should be changed to log shipping IMHO as that would better suit the situation!). I've also been sitting in on webinars from Brent Ozar and his 'team' which have been quite informative.
I'm on my last week of study to get me ready for the 15th so I'll let you know if using the material has paid off or not.......
MCITP
MCTS -
E-Business Card
Twitter:
WWDMark
Try not! Do or do not, there is no try
email:
info@weekendwebdesign.co.uk
Website:
www.weekendwebdesign.co.uk
Post #1429137
anthony.green
anthony.green
Posted Monday, March 11, 2013 4:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.
I do have a few friends in QA who became colleagues so they are going to see if 50400A is relevant to what they know I know as they still have a valid teaching certification for MS courses so still have access to the course material.
I'm going to re-book mine for the end of the month, thinking the 29th, but need to get confirmation to have the morning off yet.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1429147
Richard Warr
Richard Warr
Posted Monday, March 11, 2013 4:33 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,602,
Visits: 1,084
I'm doing 70-462 next week and I'm not even a DBA. Trouble is you now need all three to get a qualification. Have set up local environments to practice on so hoping I can cover most of what is likely to come up.
Post #1429150
WWDMark
WWDMark
Posted Monday, March 11, 2013 4:46 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 3:02 AM
Points: 446,
Visits: 348
Richard Warr (3/11/2013)
I'm doing 70-462 next week and I'm not even a DBA. Trouble is you now need all three to get a qualification.
That's one of the reasons I'm concentrating on SQL 2008 rather than 2012, that and the fact that all our DB servers run 2008 R2 and we've got no need to upgrade to 2012 yet (which I suspect is the case with a lot of companies - if it ain't broke!!!).
After I've done the MCITP (and I will pass this time!!!), I'm scheduled to do 70-448 by the end of the year which will give me the MCSA certification - fingers crossed!!
Good luck with your exam though, out of interest, what do you do that would require you to do 70-462?
MCITP
MCTS -
E-Business Card
Twitter:
WWDMark
Try not! Do or do not, there is no try
email:
info@weekendwebdesign.co.uk
Website:
www.weekendwebdesign.co.uk
Post #1429154
WWDMark
WWDMark
Posted Monday, March 11, 2013 5:04 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 3:02 AM
Points: 446,
Visits: 348
anthony.green (3/11/2013)
Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.
I do have a few friends in QA who became colleagues so they are going to see if 50400A is relevant to what they know I know as they still have a valid teaching certification for MS courses so still have access to the course material.
I'm going to re-book mine for the end of the month, thinking the 29th, but need to get confirmation to have the morning off yet.
6231A & 6232A got me through 70-432 first time and really set me on my SQL Server love affair!!
Good call re 50400A though (networking, networking, networking!!), if you do need specific material from the 50400A course manual and you can't get it from your colleagues let me know as I've got it all scanned.
Fingers crossed you can get the morning off for the exam, are you still paying for it yourself or are your company helping with the costs?
MCITP
MCTS -
E-Business Card
Twitter:
WWDMark
Try not! Do or do not, there is no try
email:
info@weekendwebdesign.co.uk
Website:
www.weekendwebdesign.co.uk
Post #1429161
Richard Warr
Richard Warr
Posted Monday, March 11, 2013 5:47 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,602,
Visits: 1,084
WWDMark (3/11/2013)
Good luck with your exam though, out of interest, what do you do that would require you to do 70-462?
Thank you. To be honest, not a lot in this job as we have a full-time DBA. I do need to do 461/2 and 3 to get the MCSA qualification though. I'm a developer specialising in T-SQL but also do a bit of SSRS and SSIS.
The admin side is pretty interesting though - there's an awful lot to it!
Post #1429196
anthony.green
anthony.green
Posted Monday, March 11, 2013 6:37 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
WWDMark (3/11/2013)
anthony.green (3/11/2013)
Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.
I do have a few friends in QA who became colleagues so they are going to see if 50400A is relevant to what they know I know as they still have a valid teaching certification for MS courses so still have access to the course material.
I'm going to re-book mine for the end of the month, thinking the 29th, but need to get confirmation to have the morning off yet.
6231A & 6232A got me through 70-432 first time and really set me on my SQL Server love affair!!
Good call re 50400A though (networking, networking, networking!!), if you do need specific material from the 50400A course manual and you can't get it from your colleagues let me know as I've got it all scanned.
Fingers crossed you can get the morning off for the exam, are you still paying for it yourself or are your company helping with the costs?
If you could send me the material for 50400A that would be great, unsure my contacts can send it without getting into trouble with MS, so would be good to have it to read.
I have to pay for it myself, and if I pass they give me the fee back which isn't to bad, just must remember to use my second shot voucher just in-case the worst happens.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1429233
WWDMark
WWDMark
Posted Monday, March 11, 2013 6:47 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 3:02 AM
Points: 446,
Visits: 348
anthony.green (3/11/2013)
If you could send me the material for 50400A that would be great, unsure my contacts can send it without getting into trouble with MS, so would be good to have it to read.
No worries, were there specific subjects you needed as the original material covered 3 ring binders!!!?
MCITP
MCTS -
E-Business Card
Twitter:
WWDMark
Try not! Do or do not, there is no try
email:
info@weekendwebdesign.co.uk
Website:
www.weekendwebdesign.co.uk
Post #1429236
« Prev Topic
|
Next Topic »
21 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.
