SQL Database in Fabric: Modern Operational & Analytical Apps at Scale
Description
Explore how SQL database in Fabric powers modern operational and analytical workloads in a single platform. Through a global automotive dealership network, learn how inventory, service records, test-drive logs, and customer activity are unified into Fabric to build high-performance apps, real-time insights, and AI-assisted analytics.
Key Takeaways
- Influence our SQL roadmap and ensure
- The Modern Data Platform Problem
- Why Operational + Analytical Workloads Must Converge
- Introducing SQL Database in Microsoft Fabric
- Why SQL Database in MS Fabric
- The Global Dealership Scenario
- Demo: Building the Dealership Intelligence App
My Notes
Action Items
- [ ]
Resources & Links
Slides
SQL Database in Fabric: Modern
Operational & Analytical Apps at
Scale
Anupama Natarajan
Data and AI Consultant
Pearl Innovations Limited
Microsoft MVP Data Platform and AI
MCT Community Lead
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel
Agenda
• The Modern Data Platform Problem
• Why Operational + Analytical Workloads Must Converge
• Introducing SQL Database in Microsoft Fabric
• Why SQL Database in MS Fabric
• The Global Dealership Scenario
• Demo: Building the Dealership Intelligence App
• Real-Time Analytics Without ETL
• AI-Driven Insights from Operational Data
• Key Takeaways
The Modern Data Platform Problem
Data Latency (hours or days)
Duplicate storage
Complex Pipelines
Expensive Infrastructure
Slow application insights
Why Operational + Analytical Workloads must Converge
Real-time Insights
Integrated Analytics
Built-in AI
Translytical workloads (OLTP + OLAP)
No complex ETL pipelines
Introducing SQL Database in Microsoft Fabric
Built on the SQL Server & Azure SQL Database Engine
First SaaS-native operational database in MS Fabric
Designed for developers, data engineers and IT teams
Enables secure, scalable application development
Fully integrated with the Fabric ecosystem
How SQL Database Fits inside Fabric
Why SQL Database in MS Fabric - Built for Next Generation of
Applications
Simple
• Provision database in
minutes
• Copilot powered editor
• Native T-SQL Support
• Built-in CI/CD
Autonomous and
Secure
Optimized for AI
• Automatic scaling
• High availability
• Disaster recovery
• Zero infrastructure
management
• SQL Auditing
• Vector data support
• Semantic search
• Retrieval Augmented
Generation (RAG)
• Seamless integration
(Microsoft Foundry,
Azure OpenAI)
Choosing the right data store
The Global Dealership Scenario
Dealership Platform Goal
Operational Apps run transactions
Analytics runs instantly
AI generates insights
Business dashboards update live
Dealership Intelligence App
DEMO
Real-Time Analytics Without ETL
NO ETL PIPELINES
NO DATA DUPLICATION
REAL-TIME ANALYTICS
SIMPLIFIED
ARCHITECTURE
AI-Driven Insights from Operational Data
• Predictive analytics
• Intelligent search and recommendations
• Real-time anomaly detection
• Automation through AI agents
• Context-aware decision support
Architecture Takeaways
Operational and Analytical workloads can coexist
OneLake simplifies Architecture
SQL database in Fabric removes ETL complexity
Real-time Analytics becomes practical
When to use SQL Database in MS Fabric
Operational Apps needing Analytics
SaaS Platform
Real-time BI Scenarios
AI-powered Applications
Operational Dashboards
Key Takeaways
Operational + analytical workloads are
converging
SQL Database in Fabric enables modern
application architectures
Real-time insights become native
AI can run directly on operational data
Fabric simplifies enterprise data architecture
Questions
Thank you for being part of this session
Demo Scripts
Anupama Natarajan
Data and AI Consultant
Microsoft MVP Data Platform and AI
MCT Community Lead
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel