Microsoft Foundation Sessions at PASS Summit 2015

This years PASS Summit has seen some of the biggest announcements in SQL Server and Microsoft Business Intelligence history.

  • We’ve finally gotten a clear vision where Microsoft is heading.
    And it even makes sense!
  • Microsoft already was the leader in Gartner’s Magic Quadrant for Operational Database Management Systems
    But SQL Server 2016 will bring even more improvements.
  • In the past year, Power BI has gone from “OK” to “Nice” to “Wooooooooow“.
    With all the new announcements, it seems like Microsoft is not even taking it’s foot of the throttle.
  • Cortana Analytics Suite is Microsoft’s way to help you get insight and take action on your data.
    It’s basically everything you need for your Data Science scenario’s.

Below are some Microsoft Foundation sessions from the PASS Summit that talk about these products and what you can expect from them, now and in the future.

If you’re interested in just a list of features, check out Chris Webb’s blog post about the announcements.


Business Intelligence


Advanced Analytics


Big Data and Data Warehousing


Developing Modern Applications on Azure

 


Video’s via http://www.sqlpass.org/summit/2015/PASStv/Microsoft.aspx

Microsoft’s Vision for BI Reporting

Watch out everyone, here comes Microsoft’s vision for the future of BI Reporting!
Straight from the PASS Summit 2015, thanks to several people on twitter kind enough to share.

From On-premises to Cloud solutions, the vision is complete starting right now!


In other news, SQL Server 2016 CTP 3.0 has been announced.
Not only is it feature complete and amazing, it will just change the way we look at business intelligence.
Read more about it on the official blog and some more in this official post.

UPDATE:


Clicking below picture opens them in full size, for the last 2 it’s very useful because of the quality.
CloudandOnPremSolutions

MicrosoftProvidesCompleteSolution

TheFourMicrosoftBIREportTypes

This last picture is a bit blurry, but those who know the platform can discern the complete picture.

From creating Analytical and Power BI reports, to Mobile and Paginated reports.
It will all be manageable in the cloud on PowerBI.com or on-premises in Reporting Services.
And of course, the journey ends when the end user opens the reports on PowerBI.com, his mobile device or the corporate SharePoint.

VisionForMSBIReporting

 

SQL Server 2016 CTP 2.4 is here!

Microsoft is a busy bee these days… Providing all the updates we actually want and need!
Today there was another great release for the Power BI Service.
And more importantly, a HUGE release called SQL Server 2016 2.4!

This includes a long awaited feature for SSRS and an incredible improvement for analytic workloads.


A quick overview of what you can play with:

General

  • Some sad news for people with old machines: x86 server support is now deprecated!
  • Smart Maintenance Plans
  • Tempdb now has improved scalability

SSRS

  • Export reports to PowerPoint!
  • Position report parameters the way you want
  • Print reports from modern browsers
  • Even better support for new browsers
    • Like no requirement for ActiveX to print reports

SSRSPowerPointExport

Read more details about the Reporting Services changes in this post at the official SSRS blog.

SSIS

  • Excel 2013 finally made the cut as a source and destination
    • Now we wait for Excel 2016 🙂
  • Complex data feeds including Data Streaming destination!
  • oData v4 source support in addition to oData v3
  • Balanced Data Distributor
  • AlwaysOn support

Operational Analytics and In-Memory Data Warehouse

  • Updateable NonClustered Columnstore Indexes, but they no longer need an index rebuild!
  • Parallel building of these NonClustered Columnstore Indexes.
  • Increased speed for insert operations on delta Rowgroups
  • And of course improvede query performance using these NonClustered Columnstore Indexes

Read the official post with more in depth information here

%d bloggers like this: