sql server 2012 express edition licensing

#Sql server 2012 express edition licensing software
#Sql server 2012 express edition licensing license
#Sql server 2012 express edition licensing plus

The various online operations such as index rebuilds (same as it is now in Enterprise and Datacenter).

All modes of database mirroring with automatic page repair (same as it is now in Enterprise and Datacenter).

> 2 node failover clustering (same as it is now in Enterprise and Datacenter).

Peer to Peer replication (same as it is now in Enterprise and Datacenter).

Faster failover for clustered instances (new to SQL Server 2012 – talked about this in my PASS Summit preconference).

AlwaysOn availability groups and everything that comes with it like readable replicas, backups from replicas, PowerShell cmdlets, etc.

#Sql server 2012 express edition licensing plus

Support for Server Core deployments (new to SQL Server 2012) – both clustered and standaloneĪdvanced (which includes everything you get in Standard/BI plus …).

#Sql server 2012 express edition licensing software

Mobility limitations removed for Standard/BI, so Live Migration now really a good option for VMs if you have Software Assurance (so not new, but kinda new).

Replication (same as it is now in current Standard).

Log shipping (same as it is now in current Standard).

2-node failover cluster support for an instance (same as it is now in current Standard).

Synchronous database mirroring (same as it is now in current Standard).

Things may or may not change between now and whenever SQL Server 2012 RTMs. What exactly does that mean? Thanks to MS for helping me to clarify. The one thing which some may have noticed is the line on the bottom of the chart linked above for editions: Enterprise has “Advanced” for high availability and the other two have “Basic”. Datacenter did confuse some, so I’ll say this one is a big net positive. I think simplifying down to three editions (Standard, Business Intelligence, and Enterprise) keeps things much, much cleaner and easy to understand. I mean, who wasn’t looking forward to SQL Server 2012 Titanium Edition (available only for a limited time)? All kidding aside, Microsoft isn’t a camera manufacturer that can just change its shell to another color or textile and charge you more as much as some camera companies (*cough* Leica *cough*) do.

I know some folks liked all the different variations of SQL Server.

After 4 cores, you buy licensing in 2-core “packs”, so if your intended server has processors with 6 cores, it winds up being 1.5x what you pay today. 4 cores in SQL Server 2012 is the equivalent of a single processor in SQL Server 2008 R2 and earlier. a physical processor with 2 cores), you are still paying what you would pay today. What that means is that if you have dual core processors (i.e.

In terms of cores, understand this and you’ll be in better shape to understand cost: there is a minimum of 4 cores to purchase for each individual processor.

SQL Server does give you really good bang for the proverbial buck with a lot of features “in the box” no matter what edition you choose.

I will still argue that if you do the math, in most (if not all) scenarios you’ll still be cheaper than competitor solutions. I’m shocked MS hadn’t changed it years ago based on the way the industry itself has been going.

#Sql server 2012 express edition licensing license

Anyone who is surprised by the license by core and not socket should not be.

Others (such as Denny Cherry’s blog post or Geoff Hiten’s blog post as examples) cover that pretty well. It was hard to miss the licensing and edition announcements for SQL Server 2012 yesterday. Advancedīy: Allan Hirt on Novemin AlwaysOn, Availability Groups, High Availability, Hyper-V, Licensing, Live Migration, SQL Server 2012, SQL Server Denali SQL Server 2012 High Availability and Editions: Basic vs.