SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

PASS Summit 2016 – Announcements

There have been different announcements for new and upcoming features in the Microsoft Data Technology ecosystem. The one today I am hearing about is Data Migration Assistant (DMA) tool v2.0 GA and Tech Preview of DEA – Data Experimentation Assistant. James Serra blogged about it here - http://www.jamesserra.com/archive/2016/10/pass-summit-announcements-dmadea/. The DEA helps you with understanding the performance improvements by upgrading.

image

The next one the Tech Preview of building PowerBI reports in SQL Service Reporting Services. For more info go to the PowerBI Community Blog - https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/10/28/create-power-bi-reports-in-the-sql-server-reporting-services-technical-preview/

The most exciting one for me is the Azure Analysis Services. It is only Tabular Models, right now, but OLAP is said to be in the works. This is interesting because it once was in the Cloud and then that cloud disappeared. It will be nice to see creating a DW in the Azure DWU, then connect to that data in Analysis Services and reporting in PowerBI, all in Azure. Never though I would say that Smile

 

image

 

Go read about Azure SSAS here - http://sqlmag.com/sql-server/microsoft-announces-azure-analysis-services-preview-pass-summit-2016 and https://azure.microsoft.com/en-us/blog/introducing-azure-analysis-services-preview/

Chris Webb has already wrote his first thoughts about Azure Analysis Services - https://blog.crossjoin.co.uk/2016/10/25/first-thoughts-on-azure-analysis-services/

PASS New Logo

image

Devin Knight presenting Advanced PowerBI

Media preview

Community Zone

image

The Smiling DBA

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

Comments

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...