Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Upgrading to 2012

By Steve Jones,

It's been a little over a year since SQL Server 2012 was released in its RTM version. In that time, I've been using it on most of my machines for testing and demos. I like working with the new features and enhancements, and I think this is the best version of SQL Server yet. However I also keep a version of SQL Server 2008 running in a virtual machine since this is the version that runs SQLServerCentral.

In the last three years, we've continued to run the site on SQL Server 2008 because it works well. We don't need the newer features, and since we have a clustered pair of instances, an upgrade would be a substantial cost. That cost is hard to justify when there isn't a business benefit I can point to. I'm sure we could write more efficient code with the new T-SQL enhancements and improve performance, but since we've invested in beefy hardware, I'm not sure we would gain much with an upgrade. Quite a few of the people I've talked to in the last couple years feel the same way.

This week I'm curious to see if any of you are looking to upgrade. I know for new systems it might make sense to just install the latest version of SQL Server, but what about existing systems? The question this week is:

Are you upgrading any existing systems to SQL Server 2012 and why?

I'm looking for those drivers that provide enough benefit for you to upgrade. There might be features you are taking advantage of that others can use, so share with us the exact reasons for your upgrade. As budgets shrink, especially for systems that are working well, it can be hard to justify upgrades across the board for all your servers, but there are sometimes reasons to upgrade individual instances.

Steve Jones


The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. They have a great version of Message in a Bottle if you want to check it out.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 316 | Views in the last 30 days: 12
 
Related Articles
BLOG

SQL Server Version Upgrade

SQL Server Version Upgrade - You have SQL Server running nicely with no issues or problems. The trou...

BLOG

Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...

FORUM

Reg. Upgrade Sql Server 2005 RTM to stable version

Upgrade RTM to Stable version

ARTICLE

High Availability Upgrades

Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgr...

BLOG

Powerscripting Podcast 2

I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcas...

Tags
editorial    
friday poll    
sql server 2012    
upgradin    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones