Tuesday, May 3, 2016

SQL Server 2016 versus 2014 Business Intelligence Features

Hello, SQL Server 2016
Yesterday, Microsoft announced the release of SQL Server 2016 on June 1st of this year: https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/.  Along with performance benchmarks and a description of the new functionality, came the announcement of editions and features for the next release.

Good-bye, Business Intelligence Edition
The biggest surprise to me was the removal of the Business Intelligence edition that was initially introduced in SQL Server 2012.  Truthfully, it never seemed to fit in the environments where I worked, so I guess it makes sense.  Hopefully, fewer licensing options will make it easier for people to understand their licensing and pick the edition that works best for them.

Feature Comparison
Overall, the business intelligence services features included with each edition for SQL Server 2016 are fairly similar to SQL Server 2014.  Nothing has been "downgraded" from 2014, in that nothing previously included in Standard edition is now only in Enterprise edition.  A few features previously only in Enterprise edition are now included in Standard edition though!  And we gained a lot of new features across all the editions!  Here are the highlights as currently shared:

  • 2014 Enterprise features now in 2016 Standard:
    • Multidimensional DAX queries
    • BI Semantic Model for Tabular (except perspectives and DirectQuery storage modes) is now available in Standard edition
  • New features included in 2016 Enterprise:
    • Report Services mobile reports and KPIs
    • SQL Server Mobile Report Publisher (.rsmobile)
    • Power BI apps for mobile devices (iOS, Windows 10, Android) (.rsmobile)
  • New features included in 2016 Enterprise, Standard, and Express variations:
    • Integration Services Azure data source connectors and tasks and Hadoop / HDFS connectors and tasks
    • Reporting Services Pin report items to Power BI dashboards
Talk to the Licensing Folks
For all licensing question, contact your licensing specialist - they have the best information!  For detailed information to talk to them about, see:

28 comments:

Unknown said...

Nice posting...

gibsonherry said...

I found this blog after a long time which is really helpful to let understand different approaches. I am going to adopt these new point to my career and thankful for this help.
vSan 6 Advance for 1 processor

soumya said...

This information is really useful for me to learn more at MSBI Online Training

svr technologies said...

very nice post.... it was very helps to ssis training students.

Anuradha Singhaniya said...

Really it was an awesome article. very interesting to read. You have provided an nice article. Thanks for sharing this valuable information.
Are you wants to read more about Sql server 2016. We also provide sql training in delhi India. Visit us.

Unknown said...

I'm glad to hear that, Data Science. Good luck to you. Blogging is a great thing, and you get better with practice. Data Science training in Hyderabad One of the best ways to grow is to read other people's blogs. See what they do, how they do things. It's always food for thought, and sometimes, it's downright inspiring.

likitha said...
This comment has been removed by the author.
latesttechnologyblogs said...

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog onPower BI Online course

akhilapriya404 said...

Thanks you for sharing the article. The data that you provided in the blog is infromative and effectve. Through you blog I gained so much knowledge. Also check my collection at MSBI online training Hyderabad Blog

Unknown said...

The post is totally awesome! Bunches of incredible information and motivation the two of which we as a whole need! Likewise prefer to appreciate the time and effort you put into your blog. For more info visit.data science consulting firims

Unknown said...

The post is totally awesome! Bunches of incredible information and motivation the two of which we as a whole need! Likewise prefer to appreciate the time and effort you put into your blog. For more info visit.data science consulting firims

arjun said...

Please let me know if you’re looking for an author for your site. You have some great posts, and I think I would be a good asset. If you ever want to take some of the load off, I’d like to write some material for your blog in exchange for a link back to mine. Please shoot me an email if interested. Thanks.
Surya Informatics

addendanalytics said...

The features of SQL Server 2016 and Business Intelligence 2014 are perfectly mentioned. Such a great article. Keep posting!

ASHA RAJESH said...

Very informative and it's easy to understand keep update Surya Informatics

Martin Reed said...

Hey I’m Martin Reed,if you are ready to get a loan contact.Mr Benjamin via email: lfdsloans@lemeridianfds.com,WhatsApp:+1 989-394-3740 I’m giving credit to Le_Meridian Funding Service .They grant me the sum 2,000,000.00 Euro. within 5 working days. Le_Meridian Funding Service  is a  group investors into pure loan and debt financing at the  returns of 1.9% to pay off your bills or buy a home Or Increase your Business. please I advise everyone out there who are in need of loan and can be reliable, trusted and capable of repaying back at the due time of funds.

Ranjith said...


I think this the best blog with the most important information filled in this website
I Got the more and more ideas from this blog Thank You for letting us to know.
pythonTraining in chennai

python Course in chennai

غير حياتك للافضل said...

شركة تنظيف بالرياض
شركة نظافة بالرياض
شركة تنظيف فلل بالرياض
شركة تنظيف مكيفات بالرياض
شركة عزل فوم بالرياض

غير حياتك للافضل said...

شركة كشف تسربات المياه بالخرج
شركة تنظيف بالخرج
شركة تعقيم بالخرج
شركة مكافحة حشرات بالخرج
شركة تسليك مجاري بالخرج

غير حياتك للافضل said...

شركة تنظيف بجدة
شركة تعقيم بالرياض
شركة تسليك مجاري بالرياض
شركة نقل اثاث بالرياض
شركة مكافحة الحمام بالرياض

غير حياتك للافضل said...


شركة تنظيف بمكة
شركة تنظيف بالبخار بمكة
شركة تنظيف خزانات بمكة
شركة مكافحة حشرات بمكة

غير حياتك للافضل said...

شركة تنظيف بالمدينة المنورة
شركة تنظيف خزانات بالمدينة المنورة
شركة نقل عفش بالمدينة المنورة
شركة مكافحة الحمام بالمدينة المنورة
شركة مكافحة حشرات بالمدينة المنورة
شركة عزل اسطح بالمدينة المنورة
شركة جلي رخام بالمدينة المنورة

غير حياتك للافضل said...

شركة تنظيف بينبع
شركة تنظيف خزانات بينبع
شركة نقل عفش بينبع
شركة مكافحة حشرات بينبع
شركة مكافحة الحمام بينبع
شركة كشف تسربات المياه بالمدينة المنورة
شركة تنسيق حدائق بالمدينة المنورة

غير حياتك للافضل said...

شركة نقل اثاث بالمدينة المنورة
شركة تنظيف بالمدينة المنورة
شركة مكافحة حشرات بالمدينة المنورة
شركة تنظيف خزانات بالمدينة المنورة
شركة تنظيف بينبع
<a href="https://fajr-sate3.com/furniture-m…

غير حياتك للافضل said...

شركة تنظيف بالاحساء
شركة تنظيف خزانات بالاحساء
شركة تسليك مجاري بالاحساء
شركة مكافحة حشرات بالاحساء
شركة تنظيف خزانات بالاحساء
شركة تعقيم بالاحساء
شركة مكافحة النمل الابيض بالاحساء
شركة كشف تسربات المياه بالاحساء

fragrant past said...

بشركه تسليك مجارى بالرياض
بشركه رش مبيدات بالرياض

رقيه احمد said...

شركة تنظيف منازل بالرياض بأفضل المنظفات والمطهرات وارخص الاسعار مقابل شركات التنظيف الأخرى خصم على جميع خدمات شركة تنظيف منازل بالرياض خدمات الشركة
شركة تنظيف شقق بالرياض
شركة تنظيف خزانات بالرياض
شركة تنظيف كنب بالرياض
شركة تنظيف منازل بالرياض
شركة تنظيف بالرياض
شركة تنظيف منازل بالرياض
شركة تنظيف سجاد بالرياض

Shrok Ahmed said...


طريقة فتح موقع تسوق الكتروني
ان تصميم المواقع الإلكترونية وبرمجتها من الأمور التي يبحث عنها الكثير من الناس اليوم فـ تصميم موقع الكتروني مربح او تصميم مواقع صديقة لجوجل نحن معك حتى تصل الى كل ما تريد وايضا من تحسين خدمات المتاجر الالكترونية و طريقة فتح موقع تسوق الكتروني

Assignment Writing Help said...

We are a top rated do my assignment Online service here with experts specializing in a wide range of disciplines ensuring you get the assignments that score maximum grades.