July 1, 2010 at 1:48 am
Hi all,
I just switched jobs, and now need to maintain a few SQL server databases. I am desperate for some training (Database Maintenance and impementation) and that's the point:
- These trainings are divided into SQL server 2005 or SQL server 2008. When I train for 2005, I will have to update my skills to 2008 in about a year (mainstream support for 2005 ends in 2011) or is this not a problem.
Is it worth switching to 2008 for training and mainstream support, or should we keep on running this now stable situation? All applications using the SQL server are supported on SQL server 2008, so that's no problem.
July 1, 2010 at 1:51 am
I really don't think it's such a major transition, there are a few extra features, discontinued features, but the biggest difference in versions are in BI.
Do the training to get yourself up to speed on the new features, but I seriously doubt that you wont be able to do your work without the 2008 training.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 1, 2010 at 8:38 am
I would start by comparing SS2K5 and SS2K8 features, plenty of documentation on such matter like in http://www.extremeexperts.com/SQL/SQL2008/SQL2005Vs2008.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 1, 2010 at 9:32 am
As mentioned, not a lot of difference. I'd train on 2008 and most things will apply to 2005. Plus you'll learn what not to do, or change, in 2005 to be prepped for an upgrade to 2008 or R2.
July 8, 2010 at 2:46 am
I vote for this!
Steve Jones - Editor (7/1/2010)
As mentioned, not a lot of difference. I'd train on 2008 and most things will apply to 2005. Plus you'll learn what not to do, or change, in 2005 to be prepped for an upgrade to 2008 or R2.
However, new versions has many more new features, even though SQL 2008 has no many differences with SQL 2005, if you compare SQL 2000 with SQL 2005. I think it is much better if you updated and upgraded in new versions. Simple, go for SQL 2008 (soon we will have new version of the SQL Server, so you should be updated!).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply