From Zero to Governed : Implementing Microsoft Purview with Fabric and Azure SQL
Proposed session for SQLBits 2026TL; DR
This session introduces the foundations of enterprise data governance using the unified Microsoft Purview experience, with Microsoft Fabric and Azure SQL Database as governed data sources.
Learn how Purview automatically discovers and catalogues data assets, organises them using collections and governance domains, and supports a federated governance model. You will also see how governed, curated data products are created to align technical assets with business ownership, enabling trusted and reusable analytics across the organisation.
Session Details
Effective data governance is built on visibility, ownership, and shared understanding of data across the organisation. As organisations move to AI-powered analytics and cloud platforms like Microsoft Fabric, old methods such as manual documentation and ad-hoc controls can’t keep up. They’re too slow and inconsistent to manage the scale and complexity of modern data, making it hard to maintain trust and compliance.
This session introduces enterprise data governance using the new unified Microsoft Purview experience, with Microsoft Fabric and Azure SQL Database used as governed data sources throughout.
You will learn how Purview establishes a consistent governance foundation by automatically discovering data assets, organising them within a governed structure, and enriching technical metadata with business context to create trusted, business-aligned data products.
We begin with the Purview Data Map, demonstrating how Fabric Lakehouses, Warehouses, and Azure SQL databases are discovered, catalogued, and connected through lineage.
From there, we introduce Governance Domains, showing how they enable federated data governance by aligning data assets to business ownership rather than technical platforms, while maintaining central visibility and control.
The session then focuses on creating and managing Data Products, illustrating how curated Fabric and SQL assets are formalised as governed products with defined ownership, certification, and intended use.
Finally, we explore data asset curation, including custom classifications, endorsements, and metadata enrichment, to improve data discoverability, compliance readiness, and user trust across the organisation.
By the end of this session, you will understand how to establish a scalable data governance foundation in Microsoft Purview that enables data access and reuse while maintaining accountability, control, and confidence in enterprise data.
Topics Covered
• Introduction to Data Governance and Microsoft Purview
• Data Map and Managing Data Sources (Microsoft Fabric & Azure SQL Database)
• Governance Domains and Federated Governance Models
• Creating and Managing Data Products
• Curating and Classifying Data Assets
This session introduces enterprise data governance using the new unified Microsoft Purview experience, with Microsoft Fabric and Azure SQL Database used as governed data sources throughout.
You will learn how Purview establishes a consistent governance foundation by automatically discovering data assets, organising them within a governed structure, and enriching technical metadata with business context to create trusted, business-aligned data products.
We begin with the Purview Data Map, demonstrating how Fabric Lakehouses, Warehouses, and Azure SQL databases are discovered, catalogued, and connected through lineage.
From there, we introduce Governance Domains, showing how they enable federated data governance by aligning data assets to business ownership rather than technical platforms, while maintaining central visibility and control.
The session then focuses on creating and managing Data Products, illustrating how curated Fabric and SQL assets are formalised as governed products with defined ownership, certification, and intended use.
Finally, we explore data asset curation, including custom classifications, endorsements, and metadata enrichment, to improve data discoverability, compliance readiness, and user trust across the organisation.
By the end of this session, you will understand how to establish a scalable data governance foundation in Microsoft Purview that enables data access and reuse while maintaining accountability, control, and confidence in enterprise data.
Topics Covered
• Introduction to Data Governance and Microsoft Purview
• Data Map and Managing Data Sources (Microsoft Fabric & Azure SQL Database)
• Governance Domains and Federated Governance Models
• Creating and Managing Data Products
• Curating and Classifying Data Assets
3 things you'll get out of this session
A clear, practical understanding of how to implement enterprise data governance using Microsoft Purview with Microsoft Fabric and Azure SQL Database
Hands-on insight into organising data assets into governance domains and data products that align technical platforms with business ownership
Confidence to curate, classify, and enrich data assets to improve discoverability, trust, and compliance readiness across the organisation
Speakers
Manish Kumar's other proposed sessions for 2026
AI Fundamentals for SQL and Data Professionals: Your First Step to AI-900 Certification - 2026
Data Modernisation with Open Standards: Apache Iceberg in Fabric, Databricks and Snowflake - 2026
GenBI - A new world where AI meets BI - 2026
SQL in Fabric - Isn't it confusing? - 2026
From Dashboards to Conversations: How Fabric Data Agents and Copilot Studio Transform Analytics - 2026
SQL Server 2025: AI, Vectors, and Beyond – What’s New and Why It Matters - 2026
AI and Your Data Platform: Preparing Data for Intelligent Decision-Making with Microsoft Cloud - 2026
From Metadata to Momentum: Accelerating Self-Service Analytics with Microsoft Fabric and Purview - 2026
From T-SQL to Lakehouse: A SQL Server Professional’s Guide to Microsoft Fabric - 2026
From Zero to Governed : Implementing Microsoft Purview with Fabric and Azure SQL - Part 2 - 2026
Open Source Databases for Azure SQL Database Professionals: What Transfers, What Changes - 2026
Manish Kumar's previous sessions
Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance.
We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server.
Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
Performance Tuning of Azure SQL DB
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
Haider Raza
Haider Raza's other proposed sessions for 2026
AI Fundamentals for SQL and Data Professionals: Your First Step to AI-900 Certification - 2026
Data Modernisation with Open Standards: Apache Iceberg in Fabric, Databricks and Snowflake - 2026
GenBI - A new world where AI meets BI - 2026
SQL in Fabric - Isn't it confusing? - 2026
From Dashboards to Conversations: How Fabric Data Agents and Copilot Studio Transform Analytics - 2026
SQL Server 2025: AI, Vectors, and Beyond – What’s New and Why It Matters - 2026
AI and Your Data Platform: Preparing Data for Intelligent Decision-Making with Microsoft Cloud - 2026
From Metadata to Momentum: Accelerating Self-Service Analytics with Microsoft Fabric and Purview - 2026
From T-SQL to Lakehouse: A SQL Server Professional’s Guide to Microsoft Fabric - 2026
From Zero to Governed : Implementing Microsoft Purview with Fabric and Azure SQL - Part 2 - 2026
Open Source Databases for Azure SQL Database Professionals: What Transfers, What Changes - 2026
Azure SQL PaaS service - Basic to advance - 2026
SQL Server 2025 vs Azure SQL PaaS: Modern Data Architecture Without the Confusion - 2026
Haider Raza's previous sessions
Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance.
We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server.
Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.