On November 19, 2024, Microsoft introduced SQL databases to Microsoft Fabric. These databases utilize the same Fabric Capacity Units as other workloads, with separate billing for storage and backups.
Until February 1, 2025, SQL databases in Fabric are free to use.
From February 1, 2025, compute and data storage charges will apply.
From March 1, 2025, backup billing will apply.
What are SQL databases in Microsoft Fabric?
SQL databases in Microsoft Fabric are a part of the Fabric platform that allows you to easily deploy, manage, and integrate SQL databases. They integrate seamlessly with various tools and data sources, are quickly deployed and easy to manage. They offer features like real-time data replication, robust security, and AI optimization, making them ideal for modern data management and AI applications.
Key Benefits
- Simplicity: Setting up a SQL database in Fabric is straightforward. You just need to give it a name to get started.
- Integration: Fabric can connect with many different tools and data sources. You can easily import sample data, use data flows, and set up data pipelines. It also provides AI help in the Query Editor and through Copilot. Plus, you can quickly switch to using tools like Visual Studio Code and SQL Server Management Studio.
- Source Control: You can use SQL projects and connect them to a git repository. This allows you to save and update your database objects directly from the repository. It supports advanced workflows and helps maintain high-quality SQL code.
- Real-Time Analytics: Data is quickly copied to Azure OneLake, a unified data storage system for your entire organization, similar to OneDrive. OneLake is included with every Microsoft Fabric tenant and serves as the central location for all your analytics data. This setup allows you to perform both operational and analytical tasks without needing to move data around. The SQL analytics endpoint lets you efficiently query this replicated data.
- Autonomy: SQL databases in Fabric work autonomously. They are set up to be highly available and perform well automatically. This means you can concentrate on developing your applications without having to manage the database.
- Security: Fabric offers strong security features. These include user authentication with Microsoft Entra, data encryption both when stored and when being transmitted, and network security through Private Link. Additionally, Microsoft Purview improves security and compliance with auditing and centralized management.
- AI Optimization: SQL databases in Fabric are designed to enhance AI applications. They support advanced features like native vector processing and Retrieval-Augmented Generation (RAG). They also integrate seamlessly with AI platforms and are compatible with frameworks such as LangChain and Semantic Kernel. These capabilities make it easier to build and deploy AI applications.
Licensing
Fabric uses a capacity model for billing, with compute charges applying only when the database is in use. This auto-scaling feature ensures you only pay for what you need, with separate billing for storage and backups.
- Until February 1, 2025, SQL databases in Fabric are free to use.
- From February 1, 2025, compute and data storage charges will apply.
- From March 1, 2025, backup billing will apply.
For expert advice on licensing Microsoft Fabric, consult SCHNEIDER IT MANAGEMENT. We provide detailed guidance on how to best license this solution within your organization.
FAQ
Can I use SQL databases in Fabric for free?
Yes, SQL databases in Fabric are free to use until February 1, 2025. After this date, compute and data storage charges will apply, with backup billing starting on March 1, 2025.
How is billing handled for SQL databases in Fabric?
SQL databases in Fabric use Fabric Capacity Units for billing, similar to other Fabric workloads. Compute charges apply only when the database is in use, with auto-scaling to match demand. Storage and automatic backups are billed separately on a monthly basis.
What is the SQL analytics endpoint in Fabric?
The SQL analytics endpoint is a feature that allows you to query replicated data in OneLake efficiently. It provides a unified approach to operational and analytical work, enabling you to perform complex queries without moving data.
How does Fabric ensure high availability for SQL databases?
SQL databases in Fabric are automatically configured for high availability with zone redundancy. This means that the databases are designed to remain operational even in the event of hardware failures, ensuring continuous availability and reliability.
What AI capabilities are integrated with SQL databases in Fabric?
SQL databases in Fabric are optimized for AI applications, supporting features like native vector processing and Retrieval-Augmented Generation (RAG). They integrate with popular AI platforms and frameworks such as Azure AI, LangChain, and Semantic Kernel, making it easier to build and deploy AI applications.
More Information
- Get Started: https://www.microsoft.com/en-us/microsoft-fabric/getting-started.
- Announcement: https://blog.fabric.microsoft.com/en-us/blog/announcing-sql-database-in-microsoft-fabric-public-preview.
- More Info on Microsoft Fabric: https://www.microsoft.com/en-us/microsoft-fabric.
- Our Microsoft page: https://www.schneider.im/software/microsoft.
Please contact us for expert services on your specific Microsoft software and online services requirements.