none
Should I Study MCTS on SQL Server 2005 or 2008? RRS feed

  • Question

  • I'm about to start studying for a DBA certification.  I'm not currently working as a DBA but want to train up so I can have a chance to get a DBA job.  I'm confused about whether I should study MCTS 2005 or 2008.  For example would I need to study 2005 first and then 2008 or would it be sufficient to just pass the MCTS exam for SQL 2008 DBA?  Also, when is the 2005 exam being withdrawn?  Is that going to be obsolete soon, and not worth having?  

    Any advice would be much appreciated to get me started on the right track.

    Saturday, September 25, 2010 8:21 AM

Answers

  • I'm about to start studying for a DBA certification.  I'm not currently working as a DBA but want to train up so I can have a chance to get a DBA job.  I'm confused about whether I should study MCTS 2005 or 2008.  For example would I need to study 2005 first and then 2008 or would it be sufficient to just pass the MCTS exam for SQL 2008 DBA?  Also, when is the 2005 exam being withdrawn?  Is that going to be obsolete soon, and not worth having?  

    Any advice would be much appreciated to get me started on the right track.

    I suggest you to go for SQL Server 2008 Exam 70-432.

    http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432#tab1


    Regards, tnvbalaji http://in.linkedin.com/in/tnvbalaji
    Wednesday, September 29, 2010 5:31 PM
  • Hi,

    SQL 2005 has been around for a while and so is the exam for that. I passed this in 2006 so you know that looking at the time frame this exam won't be around for much longer. So being prepared as you would like to be i'd say go straight for 2008. There are various upgrade tracks but if you haven't passed 2005 then i don't think it makes sense to first go for 2005 and then upgrade to 2008.

    Good luck with the study. Questions, you know where to find us ;-)

    Maurice

    Saturday, September 25, 2010 11:06 AM
  • Hi

    I have to disagree with Maurice. SQL Server 2000 (yes 2000 not even 2005) is still so widely used by companies that 2008 is rocket science for them. We developers tend to be early adopters but industry doesn't move with us right away. Most companies are years behind in technology because their huge infrastructure is nor easy or cheap to upgrade. Plus why they should change something that get's the job done without a problem ? They never go like "hey Sql Server 2008 went RTM last week, let's upgrade our systems !". Instead they go like "hmm, SQL Server 2000 is getting old and Microsoft will discontinue it's support, maybe we should upgrade in the coming years when we have some spare funds and time". But even then they might upgrade to 2005 instead of 2008 because they will find it more mature.

     

    I'd suggest to go for 2005 certification. Then with minimum effort you will be able to get the 2008 one too. So in the end you will be a specialist in both versions which is by far the preferred way.

     

    If the exam is withdrawn this has no impact at all on your certification. You will still be the same recognized SQL Server 2005 specialist. Exam retiring only means that people won't be able to obtain the certification anymore, but this doesn't invalidate in any way the certifications of the existing specialists. But this is not the case anyway. Microsoft has no reason at all to retire SQL Server 2005 until the 2011 version is released.

     

    I'd suggest reading this small article which also proves my point: http://www.networkworld.com/community/blog/sql-server-2010i-dont-think-so

    Saturday, September 25, 2010 9:57 PM
  • Hi there,

     

    I in a way agree with both point of views from maurice and Mihai, but i would suggest to go for SQL Server 2008 (I am preparing right now for 70-432).

    Mihai has very stretegic approch but one thing needs to be kept in mind that most of the companies will eventually migrate to SQL Server 2008, and it has started happening. I am working for one of largest retail company in Canada and i have seen trend catching up as I am right now in middle of analysis phase for upgrading all SQL Servers. Well this might sound like that only big companies can afford it but eventually small companies will have to move to newer versions as Microsoft has denounced support for SQL Server 2005 effective April 11/12, 2011 which is not far.

     

    Although learning & demonstrating skills on SQL 2005 will be most welcome, you know what future is. Your employer will like you if you know SQL 2005 but will be more happy if you know 2008.

    All the best

    J

     

     

    Tuesday, September 28, 2010 6:10 PM
  • Hi DBA to be,

    You got two perspectives, the job and the knowledge. From them both I strongly suggest you to go to SQL 2008. From the job perspective, It may be more tempting for a headhunter to go catch the latest or more updated knowledge because it may be possible that they are looking for updated IT guy for migrations, administration or upgrades. From the knowledge perspective, it easier to find training on the last technology available. Trainers always are fetch to teach the last technology. In the other hand you'l find a lot of support on printed materials. Look back only to support legacy databases, such as 2005 and 2000.

    Moreover, if you're looking foward to a new knowledge, don't think to look back, get the latest knowledge available.

    Please, don't forget that DB are run in server, so learn about servers like Windows 2008 and Windows 2008 R2.

    Enjoy yourself.

    Alfredo Arizaleta


    Disclaimer: This posting is provided "AS IS" with no express or implied warranties or rights.
    Tuesday, September 28, 2010 11:56 PM
  • Hi

    Of Corse 2008, because a huge features are added to the 2008 from administative point of view

    1. The resource governor to manage resources by process

    2. The policy based management to standardize the  way developing database systems

    3. The bcp to import and export data from emplacement to another

    4. The compressed backup

    5. The CDC change data capture DMVs to help get info about your objects in your sql server instance

    6. Freeze plan to predicate queries

    7. Entire data base encryption

    8. Several ETL enhancements if you're  intersted to Integation services SSIS and SQL BI

    In the other hand the  T- SQL is enhanced 

    1. New File stream data types

    2. LINQ support

    3. Merge statement

    4. Sparse column support

    5. Spacial data types

    6. Table data types  (you can create a table as a type and pass it as a parameter in a stored procedure or UDF )

    7. Byond relational

    And those features would be crucial in the near future so you can learn 2005 but my advise to you is to prepare the 2008 one, please mark this and answer if you're satisfied


    The complexity resides in the simplicity
    Thursday, October 14, 2010 7:51 PM

All replies

  • Hi,

    SQL 2005 has been around for a while and so is the exam for that. I passed this in 2006 so you know that looking at the time frame this exam won't be around for much longer. So being prepared as you would like to be i'd say go straight for 2008. There are various upgrade tracks but if you haven't passed 2005 then i don't think it makes sense to first go for 2005 and then upgrade to 2008.

    Good luck with the study. Questions, you know where to find us ;-)

    Maurice

    Saturday, September 25, 2010 11:06 AM
  • Hi

    I have to disagree with Maurice. SQL Server 2000 (yes 2000 not even 2005) is still so widely used by companies that 2008 is rocket science for them. We developers tend to be early adopters but industry doesn't move with us right away. Most companies are years behind in technology because their huge infrastructure is nor easy or cheap to upgrade. Plus why they should change something that get's the job done without a problem ? They never go like "hey Sql Server 2008 went RTM last week, let's upgrade our systems !". Instead they go like "hmm, SQL Server 2000 is getting old and Microsoft will discontinue it's support, maybe we should upgrade in the coming years when we have some spare funds and time". But even then they might upgrade to 2005 instead of 2008 because they will find it more mature.

     

    I'd suggest to go for 2005 certification. Then with minimum effort you will be able to get the 2008 one too. So in the end you will be a specialist in both versions which is by far the preferred way.

     

    If the exam is withdrawn this has no impact at all on your certification. You will still be the same recognized SQL Server 2005 specialist. Exam retiring only means that people won't be able to obtain the certification anymore, but this doesn't invalidate in any way the certifications of the existing specialists. But this is not the case anyway. Microsoft has no reason at all to retire SQL Server 2005 until the 2011 version is released.

     

    I'd suggest reading this small article which also proves my point: http://www.networkworld.com/community/blog/sql-server-2010i-dont-think-so

    Saturday, September 25, 2010 9:57 PM
  • Hi there,

     

    I in a way agree with both point of views from maurice and Mihai, but i would suggest to go for SQL Server 2008 (I am preparing right now for 70-432).

    Mihai has very stretegic approch but one thing needs to be kept in mind that most of the companies will eventually migrate to SQL Server 2008, and it has started happening. I am working for one of largest retail company in Canada and i have seen trend catching up as I am right now in middle of analysis phase for upgrading all SQL Servers. Well this might sound like that only big companies can afford it but eventually small companies will have to move to newer versions as Microsoft has denounced support for SQL Server 2005 effective April 11/12, 2011 which is not far.

     

    Although learning & demonstrating skills on SQL 2005 will be most welcome, you know what future is. Your employer will like you if you know SQL 2005 but will be more happy if you know 2008.

    All the best

    J

     

     

    Tuesday, September 28, 2010 6:10 PM
  • @a_naughtymind

    I wasn't suggesting him to go for 2005 and forget about 2008. I was actually encouraging him to go for both 2005 and 2008 certifications as the gain is maximum for a minimum effort.

    Tuesday, September 28, 2010 8:35 PM
  • Hi DBA to be,

    You got two perspectives, the job and the knowledge. From them both I strongly suggest you to go to SQL 2008. From the job perspective, It may be more tempting for a headhunter to go catch the latest or more updated knowledge because it may be possible that they are looking for updated IT guy for migrations, administration or upgrades. From the knowledge perspective, it easier to find training on the last technology available. Trainers always are fetch to teach the last technology. In the other hand you'l find a lot of support on printed materials. Look back only to support legacy databases, such as 2005 and 2000.

    Moreover, if you're looking foward to a new knowledge, don't think to look back, get the latest knowledge available.

    Please, don't forget that DB are run in server, so learn about servers like Windows 2008 and Windows 2008 R2.

    Enjoy yourself.

    Alfredo Arizaleta


    Disclaimer: This posting is provided "AS IS" with no express or implied warranties or rights.
    Tuesday, September 28, 2010 11:56 PM
  • I'm about to start studying for a DBA certification.  I'm not currently working as a DBA but want to train up so I can have a chance to get a DBA job.  I'm confused about whether I should study MCTS 2005 or 2008.  For example would I need to study 2005 first and then 2008 or would it be sufficient to just pass the MCTS exam for SQL 2008 DBA?  Also, when is the 2005 exam being withdrawn?  Is that going to be obsolete soon, and not worth having?  

    Any advice would be much appreciated to get me started on the right track.

    I suggest you to go for SQL Server 2008 Exam 70-432.

    http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432#tab1


    Regards, tnvbalaji http://in.linkedin.com/in/tnvbalaji
    Wednesday, September 29, 2010 5:31 PM
  • @Mihai

     

    Yes, i got your point that you were suggesting to go for both certitifications, but my reply was only clarifying which one to go for if one dosen't wish to go for both certs. Instead of investing money in two certs for same tech and different version, i would go for latest and invest in another cert for same version but different perspective. In fact i am planning to go for 70-433 along with the 70-432 and then follow Alfredo's advise of getting into Windows Server 2008. As one can get better understanding when designing solutions, using both techs as most of time SQL server is hosted on windows Server.

     

    @DBA_Enquirer

    If you have no experience with SQL Server techs, i would suggest that although your aim is going for DBA, Go for Database Developement cert like 70-433 as well(i said "as well" here, i am not advsigin to drop plan for 70-432), cause ususally DBAs do start as developers and move on to core DBA. Database Development will give you more fundamental knowledge of SQL (in this case T-SQL) as well as a database design.

     

    Further you can follow Alfredo's advise, I am of same opinion as Alfredo regarding Windows Server.

     

    Cheers to All

     

    J

    Wednesday, October 13, 2010 7:46 PM
  • One more point for you...

    If you are new to IT field or SQL Server field and going for certification...i would suggest do not go for

    MCTS MS press Training Kit books right away, As these books do assume that you have working knowledge of thses techs and may end being bit confusing.

     

    Instead go for more descriptive books which will give you good knowledge to buildup on, although you can keep exam objectives handy and read book in exam focused way, still you will cover lot of things and then if you think you should then go for MCTS Traning Kit books.

    I personally like Begining SQL Server 2008 Administration & Begining SQL Server 2008 Programming, both from WROX series. Another great book is

    Begining T or Transact SQL with SQL 2005 and 2008 by Paul turley, this one is aslo from Wrox.

    Also a book on SQL Server 2008 Administration from SAMS publishing (looks quite good to me) and it never hurts to keep SQL Server 2008 Bible handy.

     

    All the best

    J

    Wednesday, October 13, 2010 8:07 PM
  • Hi

    Of Corse 2008, because a huge features are added to the 2008 from administative point of view

    1. The resource governor to manage resources by process

    2. The policy based management to standardize the  way developing database systems

    3. The bcp to import and export data from emplacement to another

    4. The compressed backup

    5. The CDC change data capture DMVs to help get info about your objects in your sql server instance

    6. Freeze plan to predicate queries

    7. Entire data base encryption

    8. Several ETL enhancements if you're  intersted to Integation services SSIS and SQL BI

    In the other hand the  T- SQL is enhanced 

    1. New File stream data types

    2. LINQ support

    3. Merge statement

    4. Sparse column support

    5. Spacial data types

    6. Table data types  (you can create a table as a type and pass it as a parameter in a stored procedure or UDF )

    7. Byond relational

    And those features would be crucial in the near future so you can learn 2005 but my advise to you is to prepare the 2008 one, please mark this and answer if you're satisfied


    The complexity resides in the simplicity
    Thursday, October 14, 2010 7:51 PM