June 2025
Beginner to intermediate
446 pages
10h 46m
English
Content preview from Fundamentals of Microsoft Fabric
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 10. SQL Databases
In Chapter 9, we talked about Power BI, which is the most well-known feature in the Fabric landscape since it has been around for more than 10 years. In this chapter, we’ll introduce one of Fabric’s newest features: SQL databases.
SQL databases in Fabric bring together the trusted power of SQL Server and Azure SQL Database engines and integrate them into the Fabric ecosystem. This integration offers the familiarity and strength of SQL within a robust, scalable platform, unlocking advanced analytics and smooth data integration opportunities. They therefore bridge the gap between the analytical world, which we’ve mostly focused on in this book, and the operational data world, allowing you to bring them to the same place.
In a nutshell, SQL databases give us the capabilities of SQL Server and Azure SQL, but with fewer knobs and handles. As a result, we profit from more simplicity, but in exchange we have less control. Their combination of automation, AI integration, governance, and seamless data operations makes these databases a suitable solution for enterprise-scale applications while maintaining efficiency and reliability.
In application development scenarios, developers can leverage SQL databases in Fabric to modernize and improve their operations. With the introduction of built-in vector data types, teams can store and query product and customer information to enable advanced semantic search, enhancing AI-driven functionalities.
Tip
A vector data type ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.