Today, the latest CTP (3.2) of the upcoming SQL Server 2016 was released to the public. You can download the latest bits from the SQL Server Evaluation Center
For me, one of the highlights definitely are the first parts of the announced BI roadmap. Mobile Reports can now be viewed side-by-side in the preview of the Reporting Services portal. In the current CTP this new portal only supports viewing (for editing and adding new reports or datasources you have to use the “old” SSRS report portal) – but this will definitely change in future releases.
Quelle: MSDN Blog
Within this preview portal you are able to view two differen types of reports – paginated reports and mobile reports (Datazen reports) side by side. In order to create those mobile reports a new publishing tool was announced (that will be available by the end of this year – which is quite near ). In the announcement blog post Microsoft called that new tool Microsoft SQL Server Mobile Report Publisher (MSSMRP? what a nice acronym)
Quelle: MSDN Blog
In the context of Mobile BI a unique mobile access method for all types of reports was announced (for Windows, iOS and Android). The Power BI app for iOS was announced to be published in the App store by the end of december 2015.
Quelle: MSDN Blog
Analysis Services got several new features like
- the support of Tabular Model Scripting Language (TMSL) in SQL Server Management Studio
- Calculated Tables in SSDT
- a new DirectQuery implementation
- bi-directional filtering in tabular models in SSDT
Some Integration Services (SSIS) components in the context of Hadoop / Azure got enhancements and new functionality:
- Avro File Format for HDFS File Source/Destination
- Kerberos authentication for Hadoop Connector
- HadoopFileSystemTask: new action CopyWithinHadoop
Master Data Services
- Derived Hierarchies: Manipulation of Many-To-Many (m:n) relationships
- Editing of revision history
- purge of soft deleted members
The Stretch Database feature got enhancements in it’s configuration dialogs and the stretch portal.
SQL Server Management Studio
In order to cope with all those new features, SSMS also got a new release – SSMS December 2015 Preview (Version 13.0.900.73). New features/enhancements include better comparison of execution plans, better intellisense for inline columnstore indexes and several bugfixes.
I think today Microsoft’s product teams wanted to give us some early christmas/end-of-the year presents. Not only a new version of SQL Server 2016 got released….
- Announcing SQL Server Management Studio – December 2015 Preview Release – http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/12/17/announcing-sql-server-management-studio-december-2015-release.aspx
- ! SQL Server 2016 CTP 3.2 Feature Pack – https://www.microsoft.com/en-us/download/details.aspx?id=50390
- ! SQL Server 2016 CTP 3.2 Report Builder – https://www.microsoft.com/en-us/download/details.aspx?id=50389
- SQL Server 2016 CTP 3.2 Reporting Services Add-in for Sharepoint 2016 – https://www.microsoft.com/en-us/download/details.aspx?id=50393
- SQL Server 2016 CTP 3.2 Master Data Services Add-in for Microsoft Excel – https://www.microsoft.com/en-us/download/details.aspx?id=50388
- SQL Server 2016 CTP3.2 PowerPivot for Sharepoint 2016 – https://www.microsoft.com/en-us/download/details.aspx?id=50391
- SQL Server 2016 CTP 3.2 PowerPivot for Sharepoint 2013 – https://www.microsoft.com/en-us/download/details.aspx?id=50392
Well, what do I need to say more: happy testing!
- What’s new in SQL Server, December Update (CTP 3.2) – https://msdn.microsoft.com/en-us/library/bb500435.aspx
- SQL Server 2016 CTP 3.2 : Introducing end-to-end mobile BI
- SSAS Blog: What’s new for SQL Server 2016 Analysis Services in CTP 3.2 – http://blogs.msdn.com/b/analysisservices/archive/2015/12/17/what-s-new-for-sql-server-2016-analysis-services-in-ctp3-2.aspx
- SSRS Blog: Introducing mobile reports and a brand-new web portal
- SQL Server 2016 Release Notes – https://msdn.microsoft.com/en-us/library/dn876712.aspx
- Download: SQL Server Evaluation Center – Download SQL 2016 CTP3.2 from here!
- SQL Server 2016 Technical Documentation: https://msdn.microsoft.com/en-us/library/ms130214.aspx