Skip to main content

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:

Comments

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
very nice post.... it was very helps to ssis training students.
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.
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!
Well written article. Are you looking for best digital marketing services? No look further Avenir Digital Stories is the best digital marketing consultant in India which provide SEO,SMO, web design, corporate stationary, ads banner design and google ads services at an affordable price. Contact us for


best social media agency in Gurgaon, content marketing agency Gurgaon,
best digital marketing services in Delhi
Ziya said…
It is a significant and useful article . Thanks for sharing this informative post. Best software development in chennai
Arthur Wilson said…
During higher studies, students are supposed to deliver various assignments and projects along with their studies, and examinations. These projects and assignments require conceptual clarity, and their implementation in the practical world, and thus these works often become overwhelming for the students.
In order to assist them, Global Assignment Help provides them with quality assignments on-time. The experts of the organization are highly skilled and professional in their respective fields. By adding correct and precise conceptual information, with zero plagiarism, they are renowned for enhancing the quality of the assignments. By getting assistance from the firm, many students have gained benefit through the expert guidance, and secured good grades in their academics. The attractive price and 24/7 customer services of the organization makes them one of the best assignment help service providers in the world.
Thank you for sharing this informative blog post.
Math can seem impossible when doing homework late at night. My Assignment Help aims to make math homework less painful with their expert assignment help. A student struggling with fractions, decimals or geometry can get step-by-step explanations from a qualified tutor, helping you understand concepts and complete assignments on time. No more wasting evening hours on problems that seem hopeless alone - Maths Homework Help can provide the math assistance you need to make doing homework a bit more bearable.
Martha S said…
I am excited about all the new features included in each edition.

Popular posts from this blog

Is Data Science a Buzzword? aka: My first Coursera Course

Data science and data scientists are all the rage right now in the information technology space. Every company wants one; every job candidate touts they are one. But what actually does that mean to companies and potential employees? I decided to take a course on data science to see if I could find out! My co-worker, Gabriella Melki, recommended the Coursera Data Science specialization by John Hopkins Bloomberg School of Public Health. The entire specialization contains a set of 9 courses, but you can take each one individually. I started with the first course, called "The Data Scientist's Toolbox". Over the four week timeframe, I was able to view lectures and perform the assignments at my own pace. I've listed below my thoughts on the course and what I learned about data science. Week 1: Introduction to Data Science Data science is about data , specifically about answering questions, and science , following a method to discover an answer. A data scientist is the ...

Using Power BI Custom Visualizations

Power BI ( https://powerbi.microsoft.com ) is Microsoft’s tool that provides fast analysis and reporting to developers and business users.  Microsoft releases features on a monthly basis to this tool, so this post may be out of date before it’s even published!  One of the more recent releases includes the ability to create and publish custom visualizations for use by others. Power BI Visuals Gallery The Power BI Visuals Gallery is where you can publish, search, and download custom visuals for use in Power BI Desktop and the Power BI website.  People in the community and Microsoft have published visualizations that enhance the dashboard experience and still interact with the other visualizations as though they came from out-of-the-box! (On a side note, do we need to stop saying out-of-the-box now that everything is cloud-first…)  The types of visuals run the gamit from charts, graphs, animations, and slicers. Searching for a Custom Visual To start, go to the Pow...