In this video, John Savill explores the SQL database features of Microsoft Fabric, demonstrating setup, usage, and integration points with analytics services and providing guidance on selecting the right SQL database for various scenarios.

SQL Database in Microsoft Fabric

Author: John Savill’s Technical Training

This video provides an in-depth overview and demonstration of using SQL databases within Microsoft Fabric for data analytics, transactional workloads, and integration with other Microsoft services.

Table of Contents

  • Joy of OneLake
  • Fabric Use of OneLake
  • Integration with Purview and AI
  • External Data Integration
  • Transactional SQL Database Needs
  • SQL in Microsoft Fabric
  • Creating a SQL Database
  • Using the SQL Database
  • Working with SQL and Analytics Endpoints
  • Copilot Assistance
  • Pricing Considerations
  • How to Choose the Right SQL Database
  • Summary and Resources

Key Highlights

  • Fabric & OneLake: Demonstrates how OneLake acts as a unified data lake in Microsoft Fabric, simplifying storage and accessibility.
  • Integration with Purview & AI: Shows the seamless integration with Purview for governance and discovery, as well as with AI functionalities.
  • External Data Integration: Discusses how SQL in Fabric can work with external data sources.
  • Transactional & Analytics Workloads: Explains the distinction between transactional needs and analytics scenarios within Fabric’s SQL services.
  • Hands-on Creation: Walkthrough of creating a SQL database in Fabric and operationalizing it.
  • FAQ and Supporting Materials: Direct links are provided for visual summaries, feature comparisons, decision guides, and Microsoft documentation.

Choosing the Right SQL Database

  • Compares Fabric SQL databases to other Microsoft database options.
  • Covers trade-offs between transactional and analytical offerings in Fabric.
  • Offers a framework for when to use each service.

Copilot and Endpoint Features

  • Brief coverage of how Copilot can be used with Fabric SQL services.
  • Demonstrates SQL endpoint and integration options for connecting analytic tools.

Closing Notes

  • Reference to additional learning paths, certification repositories, and community playlists.
  • Encouragement to engage with the content via comments and to review the FAQ.

For a complete, updated guide or follow-up questions, visit savilltech.com/faq.