SQL Server Released to Manufacturing (RTM)

SQL Server was released to manufacturing today, with general availability on April 1, 2012.  If you have not looked at the new licensing model, you should definitely do so – there are significant savings if you purchase your licenses by June 30, 2012.  See my previous blog post on the licensing model for more information.

Here is the information on the release: http://blogs.technet.com/b/dataplatforminsider/archive/2012/03/06/sql-server-2012-released-to-manufacturing.aspx

Posted in SQL Server | Leave a comment

SQL 2012 Special Ops Tour cities

Microsoft, in partnership with SQL PASS, is traveling around the country with special sessions on SQL Server 2012.  Check out the Special Ops site for a tour city near you.

There is a lot new in SQL Server 2012, so if you need a jumpstart, this is definitely the place to get it.

Posted in SQL Server | Leave a comment

Base wingsuiting – pushing the edge of human flight

I frequently tell people that skydiving is really relatively safe, but BASE jumping (jumping from a fixed object with a parachute) is stupid dangerous.  BASE jumping has been called the most extreme sport in the world, and carries with it a lot of inherent risk.  BASE wingsuiting adds an entirely new level of danger Continue reading

Posted in Off Topic | Tagged , , | Leave a comment

ServiceU – SQL Server 2012 Case Study

The case study on ServiceU’s implementation of SQL Server 2012 has just been published.  You can read about our experience with SQL Server 2012 here.

Posted in SQL Server | Leave a comment

SQL Server 2012 Multisite Failover Cluster Instance Enhancements Whitepaper

The SQL Server 2012 Multisite Failover Cluster Instance Whitepaper has just been published.  This whitepaper contains some of the many AlwaysOn enhancements available in SQL Server 2012.

Posted in SQL Server | Tagged , , , , | Leave a comment

SQL Server 2012 Release Candidate 0 (RC0) Available for Download

Microsoft has now publically released SQL Server 2012 RC0.  If you have not downloaded CTP3, go ahead and download RC0 and start getting familiar with it.  RC0 should be very stable, so I don’t expect that you will find many or any blocking issues.

You can download RC0 here: http://www.microsoft.com/download/en/details.aspx?id=28145

For detailed information an what is new in RC0, see the TechNet article here: http://social.technet.microsoft.com/wiki/contents/articles/3783.aspx

Posted in SQL Server | Tagged , | Leave a comment

SQL Server Licensing Model Overhauled for SQL 2012

November 3, 2011 – Today Microsoft announced that the licensing model for SQL Server 2012 will be dramatically different from previous versions of SQL Server.

For the first time, Microsoft will start charging for “computing power” – yes, that means cores!  There are actually two models, one based on computing power and the other based on client access licenses (CALs), discussed below.

SQL Server 2012 Editions

With SQL Server 2012, Microsoft has released a new edition called “Business Intelligence”.  This version is CAL-based, and is intended to be used for local BI and not consumed by the public.  If you need the public (web) to connect to that SQL Server, you must upgrade to Enterprise edition, which is core-based.

The following table from Microsoft shows the versions of SQL Server 2012.  Each higher version incorporates all of the features of the previous version:

Other current editions of SQL Server will convert as follows:

  • Datacenter – all datacenter features will now be incorporated into Enterprise Edition
  • Workgroup and Standard for Small Business– Standard edition will be the most basic version of SQL Server
  • Web Edition – this version will only be available to “hosters” via the Service Provider Licensing Agreement (SPLA)
  • Developer, Express and Compact Edition will continue to be distributed without any pricing changes.  There will be a new version, LocalDB, that will have all of the programmability features of SQL Server 2012 Express edition, but be used like Compact Edition is today.

Calculating your cost for SQL Server 2012

The price per core will be based on a calculation of 1 core = ¼ the cost of a SQL 2008 R2 processor license (Microsoft Suggested Retail Price = $27,495).  Therefore each core license is $6873.75.

That may be a huge increase in cost for your environment.  As an example, I know of one customer that currently has dual processor, 12-core (per processor) boxes for their production environment.  With SQL Server 2008 R2, the total cost was $57,990 ($27,495 x 2 processors).  Now, with the pricing for SQL Server 2012, the cost for that same server will be $164,970 ($6873.75 x 24 cores).  Imagine the sticker shock for customers that have superdomes or other large servers!

These changes will take effect upon general availability (GA) of SQL Server 2012.  That is expected to be during the first half of 2012.

How to lower your upgrade costs

Having said that, there IS a way to lower your upgrade costs, but you must do it BEFORE June 30, 2012.  To ease the pain of the transition, and to support Software Assurance (SA), Enterprise Agreement (EA) and Enrollment for Application Platform (EAP), Microsoft has decided that all licenses purchased under SA before June 30, 2012 will upgrade to SQL Server 2012 with NO additional cost.  So, if you purchase a SQL Server 2008 R2 processor license with SA, that license will cover your upgrade to SQL Server 2012.

EA/EAP customers can continue purchasing licenses until the first renewal after June 30, 2012.  At the time of renewal, processor licenses will be exchanged for core-based licenses sufficient to cover the databases that are currently licensed with processor licenses.  There is a minimum of 4 cores per processor for Standard and Enterprise Edition and a minimum of 8 EE cores per processor for datacenter.

For customers that use Virtual Machines (VMs) for SQL Server, there are some interesting possibilities:

  • You can buy core license only for the cores assigned to the VM
  • For servers with a high VM density, you can license all of the cores on the physical machine and then deploy as many VMs as you want, with no additional cost.  This requires buying both EE and SA.  Without SA, you are limited to one VM per core with EE.
  • License for VM mobility – this is a further benefit of SA.  With SA, you can move licenses from one server to another (on-premise or in the cloud) as often as you want.  Without SA, licenses can only be moved once every 90 days.

After June 30, 2012, the new pricing will take effect.  Upgrades without SA will be done with one processor license = 4 core licenses.  You will need to purchase additional core licenses for any remaining cores.

So, if you intend to upgrade, you should analyze your plans for the next three years and consider purchasing all of the licenses that you will need with SA or EA/EAP prior to June 30, 2012.  [Note that if you upgrade hardware after June 30, 2012, and that hardware has more cores, you will likely be responsible for the difference in core licenses.  While I don’t see that in any of the FAQs or other documentation, I was told on a call several weeks ago that would be the case.  This makes sense if Microsoft exchanges processor licenses for current hardware core licenses.]

Thoughts about the licensing model change

To be fair to Microsoft, computing power has increased dramatically in the last few years, but Microsoft’s pricing model has not.  In most cases, it has been more economical to purchase newer hardware with more cores than to purchase hardware with more processors and pay Microsoft the additional licensing cost.  With today’s computing power, we could simply continue to purchase new hardware and never pay for additional licensing.  That’s great for us, but the SQL Server team must be able to continue to show revenue and be able to both keep its current employees and hire new talent to produce the product on which our businesses rely.

Another different approach would be to keep charging per processor, but increase the per-processor cost significantly.  Initially that might sound good, but in reality, it means that someone with a 4-core processor would pay a much higher per-processor cost as someone with a 12-core processor.  The 12-core customer is probably much happier with that arrangement than the 4-core customer.  In the end, the per-core model is probably the fairest approach, but it is not one that any of us want or were expecting.  It would have been very helpful if Microsoft had released this information months ago, before we had submitted our 2012 IT budgets.

Microsoft does have charts that show that the total cost of ownership (TCO) is still much lower than both Oracle and DB2.  Microsoft feels that the TCO shows that SQL Server is the best alternative in the market for Enterprise-class RDBMs.


Still, it is a big change, and it may cause some companies to look to alternative scale-out technologies or open-source platforms, especially for entry-level or mid-level systems.  For the rest of us, it is time to submit an emergency change to our IT budgets so that we have the licenses that we need for the next few years.

For additional information, see the following links:

Posted in SQL Server | Tagged , , | Leave a comment

What it’s like to be a skydiving student

Today my brother sent me a link that describes a lady’s tandem skydive experience, her thrill and fear, and how she returned to do another tandem skydive and then the Accelerated Freefall Course so that she could learn to jump by herself.

The cartoons and her descriptions are the best I have ever seen, so if you want to know what it’s like to be a skydiving student, check out this link!


Posted in Off Topic | Tagged , , , | Leave a comment

Asymmetric Disk Only Quorum documentation released by Microsoft

As previously discussed here, Asymmetric Disk Only Quorum is a feature of Windows Server 2008 Clustering that is now officially supported by Microsoft.  Asymmetric Disk Only Quorum allows a multisubnet cluster to use a Disk Only quorum model, even though some nodes cannot see the storage of that disk resource.

Microsoft has now released updated quorum documentation that shows the support for this feature:  http://technet.microsoft.com/en-us/library/cc770620(WS.10).aspx

Posted in Clustering, Windows Server | Tagged , , , , | Leave a comment

SQL Server “Denali” now officially “SQL Server 2012”

This morning, in his keynote address at the SQL PASS Community Summit, Ted Kummert announced that the next version of SQL Server, previously code named “Denali”, will be release in the first half of 2012, and will officially be called “SQL Server 2012”.

Posted in SQL Server | Tagged , , , , , | Leave a comment