One DBA's Ongoing Search for Clarity in the Middle of Nowhere


*or*

Yet Another Andy Writing About SQL Server

Showing posts with label Licensing. Show all posts
Showing posts with label Licensing. Show all posts

Monday, July 14, 2014

End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2



@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx #Ntirety


--

What does this mean?

The key takeaway comes from this section of the MSDN blog:

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue to provide technical support which also includes security updates during the duration of extended support.  See the table below for extended support end date.  Non-security hotfixes for these versions will be offered only to customers who have an Extended Hotfix Support agreement.  Please refer to Extended Hotfix Support – Microsoft for more information.

Microsoft uses a standard cycle of mainstream support/extended support for almost all of their products, as described at http://support.microsoft.com/lifecycle/default.aspx?LN=en-us&x=14&y=6

The biggest difference between mainstream and extended support is that during the extended support period the only true support that occurs for the product is security fixes (which very rarely occur for Microsoft SQL Server) and paid support (aka 1-900-Microsoft).  There are no service packs/cumulative updates/functionality changes/online support for a product once it enters extended support.  If you pay for an Extended Support contract (I can only think of one shop I have worked with that does pay for it) then you get some added support beyond security patches, but not much.

What do we need to do?

As described in the MSDN blog, you should plan to get off Microsoft SQL Server 2008 and 2008 R2 ASAP.  Generally Microsoft keeps a product in mainstream support until the second version after becomes GA (Generally Available).  In the case, now that SQL Server 2012 *and* 2014 are out, 2008/2008 R2 are now “minus two” versions and therefore have gone out of mainstream support.

In many cases it is possible to piggy back on top of a hardware refresh project or virtualization project to try to remove as much older SQL Server as you can.

I still run lots of even older versions – SQL Server 7.0/2000/2005 – why should I care?

Many people don’t care, but I have found it is a good general IT policy is to run everything – hardware/software/etc. – within vendor-supported timelines.  Not to make the vendors $$$, but for the supportability of the product *and* for the functionality/performance of the product.

Sure, your SQL Server 2005 on Windows Server 2003 runs your database (kind of) but what would you do if the server blew its motherboard – do you have a spare eight-year-old board in stock?  What about the software (Windows/SQL Server/etc.) – each new version adds increased performance options (compression, availability groups, etc.) and improved manageability (new dynamic management views (DMV’s), Extended Events, improved tools, etc.) – what could your staff be doing if they didn’t need to continue to hand-hold those old servers?

My application vendor doesn’t support SQL Server 2012/2014 yet!

This is one of the most cited catches to advancing software, especially database platforms.  In most cases it is possible to upgrade/replace your existing server with a new current version Windows Server/SQL Server and run your “unsupported” application databases under a down-level compatibility level (for example, running the database under SQL Server 20008 compatibility (100) on a SQL server 2012 (110) server).  This option needs to be tested before it is implemented.

Where am I going to get the $$$$ to do this?

I can’t help you much there other than to refer back to my earlier point about the old server and its eight-year-old motherboard – quantify the cost to your management of the system going down, possibly for days on end while you search eBay and Craigslist for replacement hardware
 (this isn’t a joke – I worked in one shop that had to go through this). 


This is where many DBA's (and DBA Managers) get hung up in the idea of SQL Server backups.

**IMPORTANT NOTE - you absolutely need to have SQL Server backups of all of your systems with only limited exceptions – even DEV and TEST since they are functionally PROD for your developers and QA staff**

Having said that, a wonderful stack of SQL Server backups shipped securely to your offsite facility doesn’t save you from the failed eight-year-old motherboard scenario – best case you could spin up a VMware/HyperV/etc. virtual server and restore the databases there, but do you still have all of the necessary Windows/SQL Server/service pack installation media to even install Windows 2003 SP2 and SQL Server 2005 SP4CU3 patched with MS12-070?


--

I wanted to put this out there because I know that for many of you SQL Server 2008 and 2008 R2 are your base versions – there are some SQL Server 2012’s out there (and more than a few 2005’s and 2000’s) but most servers I deal with day to day are 2008/2008 R2.

Pause and consider what I have said and work together with your team and your management in the coming months to get this done.
 

Friday, July 27, 2012

Licensing SQL Server Dev/Test Environments

I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and testing (they call it staging) environments.  The client said that they purchased regular licenses for their staging environment but that they had MSDN Professional (“Visual Studio Professional with MSDN”) licenses to cover their developers.  At this point I started to talk to them about SQL Server Developer Edition and how MSDN subscriptions – while they give you a boatload of available installable software – were intended for individual use and not for shared environments.  I dug a little online and could not find anything definitive so I told the client I would call Microsoft.

Before I did that I turned to my primary help resource - #sqlhelp on Twitter.  I referenced a blog post I found (but of course anyone can write a blog) talking about how to set up a lab with MSDN subscriptions and asked the question:


This question brought several responses from what I consider reliable technical sources saying “of course it doesn’t work that way” which is what I expected.


Finally MCM Robert Davis (Blog/@SQLSoldier) directed me down the only path to a true judgment:


I called Microsoft licensing today and to my amazement, the MSDN subscription answer appears to be correct, as long as you are careful to have an MSDN subscription of the appropriate level to include SQL Server (currently Professional or higher as shown here) for each of the developers in your environment.

I asked the Microsoft Licensing rep a couple of key questions and here are his answers:

Q:           “So if a shop of twelve developers has twelve MSDN subscriptions does that mean they can install 50+  Enterprise Edition SQL Servers for development and testing?”

A:            “Yes – as long as all individual developers have subscriptions that include SQL, they can install as  many servers as they want”

Q:          “The MSDN Licensing page (http://msdn.microsoft.com/en-us/subscriptions/cc150618.aspx) says that ‘IT Pros that install a test lab’ need subscriptions as well – so if my hypothetical twelve developers have two DBA’s that install their dev/test SQL Servers for them, I just need fourteen MSDN subscriptions to be covered for as many copies of SQL as I want in dev/test?

A:            “Yes”

Q:           “What about end-users that test the software?  Do I need MSDN subscriptions for all of them too?”

A:            “No – if you look at the Visual Studio 2010 and MSDN licensing white paper you will see a section titled ‘Acceptance Testing’ that describes the following:

Acceptance Testing

At the end of a software development project, end users (or team members such as a business sponsor or product manager acting as proxies for end users, particularly in cases where it’s infeasible or impossible for the actual end users of the program to participate) typically review an application and determine whether it meets the necessary criteria for release—a process often called user acceptance testing or UAT. MSDN software may be accessed by end users who do not have an MSDN subscription for purposes of acceptance testing, provided that the use of the software otherwise complies with all MSDN licensing terms.  It is rare that someone whose primary role is designing, developing, or testing the software would also qualify as an “end user.”

Under MSDN licensing, acceptance testing must not use live production data. If a copy of any live production data is used, then that copy of the data must be discarded after the testing is complete and cannot be incorporated back into the live production data.

As you can see in this blurb, QA staff (whose primary role is to test software) would not qualify as end-users and as such would need MSDN subscriptions as well under this scheme.

This call still blows my mind – for a little shop, MSDN subscriptions (which generally run $1000+ per year at list price) are expensive and make this scheme undoable compared to SQL Server Developer Edition licenses at $40-$50 each, but for a shop of any size, especially one that may already have MSDN subscriptions for their developers as part of doing business, this could save some money (*especially* if you aren’t using SQL Server Developer Edition in dev/test!)

Near the end of my #sqlhelp conversation the other day I had this exchange:


Maybe I finally found something that does work the “beneficial” way in licensing – it must be a trick! ;)