January 28, 2009 at 6:55 am
Because of the economic crisis and there is a big budget cut in my company, there will be no software upgrade this year including microsoft office and of course SQL Server. I doubt there will be any upgrade next year. The management decided if we can get by with current software why spend money to upgrade?
Right now we are using SQL Server 2005, that means I will not see SQL Server 2008 in the near future. I am worried my skills set will be out dated soon.
Is your company planning to upgrade from SQL Server 2005 to 2008 this year?
Thanks
January 28, 2009 at 7:20 am
We were planning on upgrading to 2008, but due to budget cuts this is no longer an option.
Which is a shame as the project i am working on required a few of the features that only come with 2008 such as the FILESTREAM data type.
Though i do have a copy of 2008 CTE which i used to develop against with the plan to upgrade once the trial was over. As this is not going to happen i will have to re-write a couple of aspects of the applications. But it did give me a really good chance to learn about a lot about 2008.
My advice would be to get a copy of 2008 CTE and develop your skills with test projects.
January 28, 2009 at 7:26 am
Loner (1/28/2009)
Is your company planning to upgrade from SQL Server 2005 to 2008 this year?
I've got clients still on SQL 2000 with no plans to upgrade.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2009 at 7:30 am
We're beginning a project to ASSESS the upgrade from 2000 to 2008 this year. I wouldn't sweat your skills being out of date. SQL Server 2000 is still going very strong. SQL Server 2005 has a long life.
Just last weekend I presented a session on execution plans. When I showed how you can use the + to navigate around a large execution plan, most of the audience was surprised. Why? Because most of them were still working in SQL Server 2000.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 28, 2009 at 8:22 am
Don't forget that the next version of SQL Server will not be out before 2011. Microsoft should not be dropping support for SQL 2005 before 2011 is out. Support for 2008 will probably not be dropped before the next version after that, 2014.
So, like other's said, SQL 2008 will be around for a while yet.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 28, 2009 at 9:22 am
I haven't had to actively manage a database in 3 or 4 years, but most of what I knew back then still applies. I have to read and practice some things to get updated, and learn new skills, but the platform doesn't change that rapidly.
Lots of SQL 2000 and I don't see that drastically decreasing this year with the economy. And if it does, lots of people are still thinking 2005.
I'd keep getting Developer Editions and trying things. Read articles here, try the new techniques out. There is supposed to be a release sometime in the first half of 2010 that is a DW upgrade of some sort. We'll see. I wouldn't be surprised to see that be SQL 2010 and then have a late 2012 release as well. The platform is changing, and I think having new versions makes sense as they get people to leave DB2/Oracle/MySQL/etc. to come over. I wouldn't be surprised to see versions every 24-30 months and then having 3-4 versions supported at any one time.
January 28, 2009 at 10:20 am
Can we actually purchase SQL Server 2008 Developer Edition yet. Last time I looked it still wasn't on the Microsoft website, just SQL Server 2005 Developer Edition. (Too bad your aren't giving away a few copies of SQL Server 2008 developer edition as "party gifts", Steve.)
January 28, 2009 at 10:24 am
Lynn Pettis (1/28/2009)
Can we actually purchase SQL Server 2008 Developer Edition yet. Last time I looked it still wasn't on the Microsoft website, just SQL Server 2005 Developer Edition. (Too bad your aren't giving away a few copies of SQL Server 2008 developer edition as "party gifts", Steve.)
I purchased a copy a few months ago from Amazon for just under $50.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 28, 2009 at 10:53 am
Thank you. (Still, that would have been a good gift to someone on SSC, even if it wasn't me.)
January 28, 2009 at 2:37 pm
Loner (1/28/2009)
I am worried my skills set will be out dated soon.
Heh... everyone that asks that question/makes that statement, simply needs to start answering some on this forum. Your current skillset with just 2005 will be outdated if you don't practice outside of the "normal" stuff they do at work. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
January 29, 2009 at 11:39 am
At my current company, we got as far as the pricing for the 2005 to 2008 upgrade. As soon as we found out there's no actual upgrade license, and that it would be a full re-buy, 2008 was off the table pretty quick. Enterprise/CPU licensing is WAY too expensive to buy just because I, I mean the company "needs" it. 🙂
Anything new will be 2008, but until then, I'm out of luck except for what I do on my own time.
For the current company, and probably most other companies, knowing 2005 is enough to do the job or pass an interview. As stated earlier, a lot of companies are still on 2000.
I keep thinking about giving consulting a shot, and that's where I'd think having 2008 knowledge is a must-have, since consultants are held to a higher standard of expertise.
Any opinions on this?
January 30, 2009 at 5:43 am
As it stands, I'm not 100% sure if we'll be looking at SQL2008. We currently run SQL2005 and SQL2000.
However, the long term strategy is MySQL for licensing cost reasons. While I know we won't fully migrate this year, I can't really see any value in upgrading the production systems for the business - the only value would be for myself.
While I like what I have seen with MySQL and the migration will be a cool project to work on, it is a shame that my company is moving away from SQL Server...
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply