I have spent quite a bit of time talking about the IT Pro field. I have discussed their certifications, various tests and other areas, but to the detriment of other Microsoft certifications. I shall now remedy this, ahem, slight oversight on my part.
Now, where to begin…I have given most of my attention to the networking world – now I should give it to another field: SQL. I know, how about the poor dev folks? Naah, maybe later, but right now I am going to concentrate on the DBA. At any rate, the whole SQL world is an interesting place, part Database Admin, part coder and part system administrator all rolled into one neat package. Well, knowing some of them, maybe not so neat. Theirs is a difficult world because of the different areas they must master – back up the database, write neater code, write more secure code, come up with new queries, study for the SQL 2008 exams coming out soon…oops, didn’t want to slip that in too soon. I have done a little work with SQL, not much, but enough to have great respect for what they do and more importantly, for what they must learn.
There are three distinct tracks with SQL available at the moment – One on SQL 2000, another on SQL 2005 and the last on SQL 2008. You can earn your MCDBA (Microsoft Certified Database Administrator) on SQL 2000, there are also MCITP tracks on SQL 2005 and SQL 2008 as well as tracks for Business Intelligence (again for SQL 2005 and SQL 2008). This is truly a unique situation where you have three distinct flavors of SQL to choose from. I have barely spent time in 2005 now it is time to jump to SQL 2008.
I will cover more on certifying onSQL 2005 and SQL 2008 in later blogs – as well as covering Business Intelligence and the various upgrade paths.