Blog Archives

70-457 and 70-458 Game Plan Part Uno

Being methodical and logical as I am, I have set forth a plan to achieve my Microsoft Certified Solutions Associate as noted earlier in my goals for 2013.  Having not found much in the way of preparation material as noted in this post , I decided to rent the 70-462 Training Kit from Amazon and transpose some of the objectives there to fit the 70-457 and 70-458 since I am taking the upgrade exams the materials for the regular exams should suffice in preparation.

Now I have outlined a calendar below and the hard dates to hold me accountable to the task especially since the book has to be returned in June.  Let the journey begin!

70-462 Training Kit – 70-457 Objectives
Objective Chapter Lesson Date
Install and Configure
Plan Installation 1 1 1/20/2013
Install SQL Server & related services 1 2 1/20/2013
Implement a migration strategy 4 1 1/27/2013
Configure additional SQL server components 3 1 1/27/2013
Manage SQL Server agent 11 1 2/3/2013
Maintain Instances and Databases
Manage and configure databases 3 3 2/10/2013
Configure SQL Server Instances 2 1 2/17/2013
Implement a SQL Server clustered instance 8 1 2/24/2013
Manage SQL Server instances 2 2 3/3/2013
Optimize and Troubleshoot
Identify and resolve concurrency problems 10 2 3/10/2013
Collect and analyze troubleshooting data 9 1-6 3/17/2013
Audit SQL Server instances 6 3 3/24/2013
70-462 Training Kit – 70-458 Objectives
Manage Data
Configure and maintain a backup strategy 11 2 3/31/2013
Restore databases
11 3 4/7/2013
Implement and maintain indexes
10 1 4/14/2013
Import and Export Data 4 2 4/21/2013
Implement Security
Manage logins and server roles 5 1 4/28/2013
Manage database permissions 6 1 5/5/2013
Manage users and database roles 5 2 5/12/2013
Troubleshoot security 6 2 5/19/2013
Implement High Availability
Implement AlwaysOn 8 2 5/26/2013
Implement database mirroring 7 1 6/2/2013
Implement replication 7 2 6/9/2013

Additional Goals for 2013

Yesterday I posted my personal development plan for 2013.  After reading a few other similar blogs by colleagues yesterday, one haunting thought stayed with me all night that I couldn’t quite put my finger on until this morning.  My goals were lofty, but they were no more so than last year.  That would not be stepping out of my comfort zone.  There was really no challenge in the list when compared to 2012, where there were some serious steps on the ledge for me.

How do I resolve this?  Not sure at this point, but I have some ideas so this may evolve over the next week.  The first idea I had would be to upgrade my SQL Server 2008 MCTS to the new MCSA 2012 (Microsoft Certified Solutions Associate).  This would consist of two exams, 70-457 and 70-458, both aptly titled ‘Transition Your MCTS on SQL Server 2008 to MCSA SQL Server 2012, Part 1 and 2.’ I waited for all of the dust to settle with the new certifications before I pursued moving forward in my personal growth as it does not appear that I am anywhere ready to tackle the MCM, thus I have made it a five-year goal.  This would put me on that path and force me to commit to the preparation needed to pass these exams.  Now that I have talked this out with you here I think I will add these to the list!  Enjoy!

SolAssoc_SQLSrvr2012_Blk

%d bloggers like this: