SQL Meets Fabric: Migrate, Mirror, Build

Sukhwant Kaur demonstrates how to bring application development, analytics, and AI together using SQL database in Microsoft Fabric.

Overview

The video walks through an end-to-end workflow in Microsoft Fabric:

• Creating a SQL database in Fabric
• Migrating an existing SQL workload into Fabric
• Using automatic mirroring to make operational data available in OneLake without building a separate replication pipeline
• Following Git-based development and deployment workflows across Fabric and VS Code
• Exploring platform capabilities such as:
  • Serverless scaling
  • Automatic tuning
  • Built-in security

It then shifts into an AI-focused build:

• Generating embeddings from data stored in the Fabric SQL database
• Running vector similarity searches
• Building a product-search assistant using a RAG (Retrieval-Augmented Generation) pattern implemented in T-SQL

Finally, it highlights how this fits into the broader Fabric ecosystem via connections to:

• Power BI
• Notebooks
• GraphQL