After some consideration I decided to pursue the 70-432 Exam: Microsoft SQL Server 2008, Implementation and Maintenance instead of the 2005 version. Though a large part of me thinks that getting certified in both versions is a good idea. As I mentioned before I am late in the SQL Certification arena so I might as well go with the most current version. The first thing I did was to visit the Microsoft Learning site and reviewed the “skills measured” section to see the areas I needed to focus on. There are eight sections that cover installation to high availability. So naturally I will hit the installation portion first. I do feel like I know the material well enough in terms of installing SQL Server 2008, but I don’t want to sell myself short so I will follow along and check off each item listed one-by-one. I am guessing I could spend about 8 weeks or so covering every section with every bit of spare time I have on a day-to-day basis in order to knock this out within two months.
I have some course material that I will use but I will also incorporate the use of Books-Online, Microsoft Learning, SQL Server centric sites and blog posts via the SQL Community. I definitely believe this is a plausible goal, but I will really need to focus on juggling my time management between work, school and family life. I do have some experience behind me with installation, configuration, replication, upgrades and such so tomorrow marks the start of my actual self-instructed training. I will run full steam ahead on this and plug away as much as I can. I will do my best to blog about my study experience as much as possible along with any and all materials I end up using.
I am a little late in the certification arena but I have a good excuse… my dog ate my ambition! Actually I have been plugging away at my Computer Information Systems (CIS) degree with a concentration of Database Management and it boils down to a few remaining classes. Seems like I have been working towards this degree for a lifetime. I would have been finished long ago, but I had to decide if I would: 1) either run full steam ahead with my education while working full-time in a travelling required position and let my grades suffer or 2) attend part-time and maintain a 3.5 or higher GPA. I choose the latter. Even though some have told me that a (D) will still get you a degree, that is just not my character. I believe if you are going to commit, then you need to commit 100%. Especially when the investment comes with a hefty price tag. Not to mention “half-ass-ism” can be habit-forming and that quite frankly is something I am not looking to catch.
During these next few classes I have decided to pursue DBA specific certifications. I mean I am certified but the certifications that I currently hold are desktop support centric and since my role has changed it is only natural that I change my focus. To be honest when I first started in the IT field I really wanted nothing to do with databases. I was set on being a Server or Network Admin and thought databases were boring. Looking back I realize I was foolish because now I am consumed in it and wish to do nothing more but DBA work. I literally started working with SQL Server 2000 by an initiative that was put into action by my previous employer. The overall goal was to eliminate the use of paperwork for field staff. So the consultants were brought in and shortly after careful observation a project was born. Instead of equipping the field staff with paperwork to shuffle they were issued laptops with a custom developed application and a local copy of sql server (MSDE) back then. The fact we implemented Merge Replication somewhat enticed me to refer to the field staff as subscribers rather than field staff because I was trying to immerse myself with SQL Server terminology as much as I could. Not to mention I felt cool just speaking it out loud during meetings since this was a new concept to our organization.
I have heard and read about the pros and cons about certifications, but I see it as another item to prove that I can take my own initiatives along with my willingness to continue and further my knowledge and skill-set. Another available avenue for continual education. I have also heard certifications combined with a degree tends to hold more weight over those with just a certification but that is debatable. In the end I suppose it is all up to you and how you feel about it. Some say it boosts personal self-confidence and I am all for that. Why not?
The first exam I might tackle is (70-431: Microsoft SQL Server 2005 Implementation and Maintenance). I know it is a SQL Server 2005 exam, but I am more familiar with 2005 at the present time over 2008. I picked up the Microsoft Press Self-Paced book and will use that as my primary study material. I have heard and read many good things about this title. I also thought about (70-445: Business Intelligence Development and Maintenance). I cannot decide actually because I have a love for both. I see a need for Administration and Business Intelligence development. Either way I figured I would set study time to one hour a day at minimum with weekends being optional. If I can or cannot cover multiple chapters in one hour then so be it. I need to be strict with a schedule in order to stick with it. Luckily I have a license for VMware Workstation 7 which allows me to build a VM study system that I can literally destroy and revert when needed. This will provide me an adequate study platform during my progress. One thing I need to do is schedule myself for the actual test as it will make the process more official since I will be actually setting a realistic and attainable goal. Not to mention it will keep me focused since the added penalty of wasting money will add fire to my priorities and will align my studies.
I am interested in knowing what you would pursue first? SQL Server Administration or Business Intelligence?