PASS Data Community Summit – Keynote

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

Community is about working together and for each other..

The #AzureDataCommunity has grown in the past months… >70k members, 130+ user groups around the world…

The Azure Data Communtiy grew within the last months around the globe – >70k members and almost 40 countries

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/

Overview about the SQL 2022 features

Bob Ward demos (and Connor joined 🙂 the “it just gets faster without code changes” in SQL Server 2022 (Parameter sensitive plan optimization)

Bob and Connor discussing 🙂
No code change required – only the compatibility level of the database is changed.. and the magic happens

More about the (Azure) SQL Family

The (Azure) SQL family

“Build once – deploy anywhere”

Azure Arc-enabled data services

Azure Cosmos DB

Announcement: Azure Managed Instance for Apache Cassandra

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.

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.
Analyze the effects of Automatic Aggregations
Hybrid Tables – Import for historical data + Direct Query for the most up-to-date data.

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

About wolfgang

Data Platform enthusiast
This entry was posted in Azure, Azure Purview, Azure Synapse Analytics, Conference, SQL Server. Bookmark the permalink.

2 Responses to PASS Data Community Summit – Keynote

  1. Pingback: Complete Analytics Fabric – Azure Synapse and Power Query (Power BI) better together | workingondata

  2. Pingback: PASS Data Community Summit Keynote Review – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s