Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrading to 2012


Upgrading to 2012

Author
Message
Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1587 Visits: 3680
To a degree I agree with you. However, with todays new technology a 'system' can live on indefinately with VM. when the old machine is becoming old you simply migrate it to a new VM machine. We still have a handful of old, smaller systems on Win2000 believe it or not. Systems that are used and maybe the vendor has gone out of business but the company still needs the function. We have a handful of systems like that. Some are not necessarily in production but have to be kept for legal reasons up and running.

With the changing of how Microsoft licenses SQL Server it is more difficult to justify an upgrade. Especially for smaller systems that don't require any of the new features like Always On. When I give my boss a quote for the cost and he asks me what do I tell our CIO the justification to upgrade... about all I can say is we will move to a newer version. That isn't much bang for the buck until we are forced to upgrade due to loss of support. We have done a lot of server consolidation but sometimes there is only so much you can do. Most of the times our hands are tied until the vendor certifies the latest version of SQL Server. Then it turns into our IT Dept putting it into the next years budget to upgrade and it not getting cut out of the budget. Then it is do we have the hours in IT for everyone to work on it. It is a never ending cycle.



Atkray
Atkray
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 5
milzs (4/19/2013)
We're a US government (US Air Force) organization and we'll be sticking with 2008 R2 for the forseeable future. My specific application runs using SQL 2008 on three different networks, all of different classification levels. In order for us to upgrade anything we have to get Information Assurance and the security officers to approve the new software for all three networks. That's typically a nightmare. Fortunately SQL is US-owned software so the process is much simpler. Getting software developed by foreign-owned companies approved is nearly impossible.


Similar situation, we are currently migrating to 2008 R2.
Peter Schott
Peter Schott
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1035 Visits: 1906
We're trying to upgrade from SQL 2005 to SQL 2012 and figure that just bypassing SQL 2008/R2 makes sense because of that. We'll be able to take advantage of a lot of features that are new to us, but not sure how many 2012-only features we'll use right away. I'm sure we'll work in some windowing functions and at least consider Always-On a little more, but the biggest thing I see us using sooner is filtered indexes.



TravisDBA
TravisDBA
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1480 Visits: 3069
Peter Schott (4/19/2013)
....not sure how many 2012-only features we'll use right away.I'm sure we'll work in some windowing functions and at least consider Always-On a little more, but the biggest thing I see us using sooner is filtered indexes.


Filtered Indexes are not new to SQL 2012. They were introduced in SQL 2008. :-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Peter Schott
Peter Schott
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1035 Visits: 1906
TravisDBA (4/19/2013)
Peter Schott (4/19/2013)
I'm sure we'll work in some windowing functions and at least consider Always-On a little more, but the biggest thing I see us using sooner is filtered indexes.


Filtered Indexes are not new to SQL 2012. They were introduced in SQL 2008. :-D


Correct, but they're also in 2012, so they'll be new to us for production use. Smile I didn't mean to imply that it was a new in 2012 feature, just newer than 2005.



SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21113 Visits: 18259
David.Poole (4/19/2013)
...

I'm going to say something contraversial here. You can do cold hard financial logical analysis of cost vs benefits and put forward a recommendation but if your business people read about a fabulous new feature that will solve all their problems then somehow fact based cost analysis goes out of the window. Even if the facts say don't the "feeling" is do. A bit of a double-edged sword that one so make sure you are holding the handle.


+1



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

djackson 22568
djackson 22568
Right there with Babe
Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)

Group: General Forum Members
Points: 741 Visits: 1176
David.Poole (4/19/2013)

I'm going to say something contraversial here. You can do cold hard financial logical analysis of cost vs benefits and put forward a recommendation but if your business people read about a fabulous new feature that will solve all their problems then somehow fact based cost analysis goes out of the window. Even if the facts say don't the "feeling" is do. A bit of a double-edged sword that one so make sure you are holding the handle.

AMEN!

I know someone in management that was telling everyone he could about how relational databases are a thing of the past, because he read an article on Mongo DB and No Sql. It didn't make a bit of sense to argue the point. Sometimes you just grin and bear it.

Dave
Jim P.
Jim P.
Say Hey Kid
Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)Say Hey Kid (689 reputation)

Group: General Forum Members
Points: 689 Visits: 2215
djackson 22568 (4/19/2013)
I know someone in management that was telling everyone he could about how relational databases are a thing of the past, because he read an article on Mongo DB and No Sql. It didn't make a bit of sense to argue the point. Sometimes you just grin and bear it.

Anytime I hear anyone mention Mongo DB I always flash to this video* in my mind.

I work in a different area than the CIO and management. I was support of hosted customer DBs and our software as opposed to our internal systems. About a year ago the CIO was asked about implementing Hadoop and was considering it. I showed him that video and somehow the idea was quietly dropped.

* - Notice that the video is barely safe for work because of profanity and you will be laughing your posterior off.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3154 Visits: 3821
Staying on an old version of a product has a cost.

Any cost/benefit analysis about moving to a new version of a product should include the costs of staying on an old version, otherwise it is not a blanced analysis.

New versions of products such as SQL Server tend to be more reliable than older versions. This means less unplanned downtime. This mans less cost to the business.

New versions of 'interesting' produts such as SQL Server help in staff attraction and retention. This means less recruitment. This means less cost to the business.

New versions of products such as SQL Server have features that may become useful to the business. Upgrading before they are needed means the IT department can support business change rather than being a brake on it. This means being able to exploit the right time to market. This means growth to the business.

If a cost/benefit analysis focusses on the downside of upgrading, then the organisation risks being bypassed by its competitors.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1587 Visits: 3680
Oh I don't know. Hypothetical situation. The cost of upgrading if we had all of our dbs on SQL2005 to 2008 to the company would be tremendous. Licenses, hardware, dba time, application folks testing, outage time to do the actual upgrade.. We have 40 servers right now with about 300 dbs. If my boss asks me what is the benefit in spending, say, three quarters of a mill to do this I cannot say we will get that much in savings by upgrading. What if we wait and jump from SQL2005 to 2012 just to stay on a Microsoft supported version and jump over SQL2008. We don't have more than a handful of mid to large dbs here. Most are quite small and won't take advantage of any new features. In SQL 2008R2 the one big benefit I like is using the COMPRESS backup. But, again, for small to midsized dbs that isn't much of a help.

I know of a LOT of companies that are simply jumping over a version... much like the Windows PC operating system. I doubt many companies will upgrade to Win8... heck we are still finishing up upgrading folks to Win7. Last month I was finally upgraded from XP to Win7.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search