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:
- SQLSaturday
- DataSaturday
- NewStarsOfData



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) ..

Intelligence Platform
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
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

Integration of Purview and Synapse

Integration of Power BI and Purview

Integration of SQL Logic (Stored Procs…)


Pingback: Complete Analytics Fabric – Azure Synapse and Power Query (Power BI) better together | workingondata
Pingback: PASS Data Community Summit Keynote Review – Curated SQL