The PASSDataCommunitySummit 2021 kicks off with a Keynote presented by Rohan Kumar
- Limitless cloud database services – choose the way / service that serves you best for your data
- Unmatched analytics and insights – choose the technology / services to analyze your data and get insights out of it
- Unified data governance – Rohan compares it to a shield around your data stores and analytic technologies to get the unified overview.
It’s the #DataCommunity
The #AzureDataCommunity has grown in the past months… >70k members, 130+ user groups around the world…
Some events / initiatives from and for the community are presented:
SQL Server 2022 – Preview
The first (early access) private preview is announced – https://cloudblogs.microsoft.com/sqlserver/2021/11/02/announcing-sql-server-2022-preview-azure-enabled-with-continued-performance-and-security-innovation/
Bob Ward demos (and Connor joined 🙂 the “it just gets faster without code changes” in SQL Server 2022 (Parameter sensitive plan optimization)
More about the (Azure) SQL Family
“Build once – deploy anywhere”
Azure Arc-enabled data services
Azure Cosmos DB
Announcement: Azure Managed Instance for Apache Cassandra
Azure Synapse Link for SQL Server (2022+)
The Azure Synapse Link family is extended to SQL Server (2022+) and will be available in the future. Synapse Link is more than “just a linked server” -> Synapse Link publishes changes to Synapse and can then be used for analytics in Power BI.
Azure Synapse Link for Dataverse
It’s GA. Do some of you remember the Export to DataLake functionality? yes.. Synapse Link for Dataverse is definitely MORE than that…
From Dataverse to Azure Synapse to your the reporting tool of your choice.
Data is pushed from Dataverse to the landing part in Azure Synapse. A Spark database (containing external table definitions to the linked tables) is created. You can use this tables in either Spark or SQL Serverless (using the shared metadata approach) ..
Arun takes over the stage
Empower every individual / every team / every organization
Power BI + Teams integration
Power BI + Excel integration
Power BI Goals
The Complete Analytics Fabric => Power BI and Synapse
Announcements for Power BI
- Patrick talks about Hybrid Tables and Automatic Aggregations.
Azure Purview – Data Governance
If you want to learn more about #AzurePurview – there is a video quickstart series available: https://workingondata.wordpress.com/2021/08/31/azure-purview-quickstart-series/
Data Lineage is one of the key features required for a good understanding of your data landscape. Btw. if you want to learn more about data lineage, g2.com has a very good introduction: https://learn.g2.com/data-lineage