SQL Server 2012 Licensing Reviews and Views

November 8, 2011

has recently announced the SQL Server 2012
The main news is the new BI edition released with SQL Server 2012 which is
positioned between the Standard edition and the Enterprise edition. You can
read an SQL Server 2012
Licensing review

on the Adatis blog which lists the pros and cons of the new edition and payment
method. Amongst other things, they point out that:

Business Intelligence edition strips away
– Advanced Security (Advanced
auditing, transparent data encryption)

Warehousing (ColumnStore,
compression, partitioning)

and provides a cut-down, basic (as opposed to advanced) level of High
Availability (AlwaysOn)”

felt like I read mostly good feedback from different bloggers on the matter,
coming from Chris Webb and also from Teo Lachev. So that made it
stand out for me when I saw that in Facebook Donald
wrote in his status:

new licensing for SQL Server BI Edition feels like an early Christmas present
from MSFT to #qlikview – thanks!” (With a link to the Adatis post on the

just in case you’re new to the field of BI, then you should know that up till
January of 2011 Mr. Farmer was greatly perceived as the face of Microsoft BI.
But on January 2011 he chose to leave Microsoft for PowerPivot’s
biggest competition – Qliktech. I value Mr. Farmer a very great deal and so, I
was more than intrigued to hear his full opinion on the matter. He wrote me

think I understand what MSFT are doing, but I think it is a mistake for them.
Standard edition was a great way for companies to start out on the BI journey. Now
BI Edition is good, but more expensive (although still competitive). But it
does not include SharePoint
which is crazy – collaboration is critical to modern BI, and the latest MSFT
tools like PowerPivot & Power View need it. Enterprise SharePoint is a big
additional cost.
course I believe they are getting ready for a cloud
offering at a lower cost. But cloud is a
different mode of working and we at QLIK see quite slow demand for cloud BI
because not enough data lives in the cloud yet.”

note the added links are put in by me and Mr. Farmer had only given me basic
remark about the absence of SharePoint in the licensing offer was also expressed
in a comment left in Mr. Chris Webb’s blog by Mr. James Snape. In SQL Server
2012 there is a growing connection between SQL
Server and SharePoint
. Microsoft doesn’t just enable you to integrate
SQL Server with SharePoint, but also develops SQL
Server 2012 features to work only on the SharePoint Platform

can’t help but wonder what Amir Netz,
who is chief architect for Microsoft’s BI offering, is thinking about the new
Licensing options for SQL Server 2012…

So where are you in this debate? Happy for the new
edition or dissatisfied? Sound off in the comments for this post!

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



  1. EditScriptNovember 18, 2011 ב 23:40

    Thing is, Donald Farmer has become just another cog in QlikTech’s marketing department.

  2. JohnNovember 21, 2011 ב 22:04

    I’m not a big fan of Qlikview but in this case I tend to agree with Farmer.

    The Microsoft BI product line is quickly pricing itself out of the market. To me the first mistake wasn’t the new pricing model but rather forcing a client to use SharePoint to access PowerView. This added a tremendous amount of expense and support/setup requirements which puts the product outside the realm of small businesses. To make matters worse The BI edition lacks the Data Warehousing features to make it a good solution for large BI setups and the Enterprise Edition now requires that you use a CPU license. To add insult to injury the new license system is now core licensed rather than CPU licensed adding even more expense.
    Don’t get me wrong PowerView and SQL 2012 are good products but NOT tens of thousands of dollars of good. I mean PowerView doesn’t even have pie chart support.

  3. Ella MaschiachNovember 27, 2011 ב 14:59

    EditScript – I think you could have said that Donald Famer was a cog in the Microsoft marketing department before, and I wouldn’t agree on that either. I think Mr. Farmer has a sort of decency and vision that not a lot of people in BI have. And that was his thoughts about it. And as I stated in the post – he wasn’t the only one thinking them.

    John – I agree that QlikView doesn’t offer a full solution as Microsoft BI + SharePoint does, but perhaps not everyone needs such a comprehensive solution? 
    I also agree that in that sense, leaving SharePoint to be a separate product, not in the BI pricing, is a curious decision.

  4. Rimon HayatDecember 27, 2011 ב 10:21

    Ella, Have you hear anything about the pricing SQL 2012 editions?

  5. Ella MaschiachDecember 27, 2011 ב 12:03

    Hi Rimon,

    Good to hear from you 🙂
    I haven’t seen anything more specific than the FAQ:


    Which doesn’t really say any numbers.
    I’m guessing it’ll only be published in the release itself.

    All the best,


  6. ChangSeptember 27, 2012 ב 0:47

    The SQL standard names are LOWER and UPPER, not LCASE and UCASE. Some pcudorts like MySQL alias LCASE and UCASE to the LOWER and UPPER functions for increased compatibility with other non-standard pcudorts and some pcudorts that are not databases. MS Access uses LCASE and UCASE as does the non-database pcudorts Excel and OOCalc. There are some programming languages which use LCASE and UCASE. There may be other DB pcudorts that do not use the SQL standard LOWER/UPPER names for these functions. Oracle does use LOWER/UPPER. DB2 supports both. PostgreSQL uses LOWER/UPPER.