From the course: Learning Microsoft Fabric
Join today to access over 24,900 courses taught by industry experts.
Using SQL database in Fabric - Microsoft Fabric Tutorial
From the course: Learning Microsoft Fabric
Using SQL database in Fabric
- So when would you want to create a Lakehouse, Warehouse, or SQL DB? If you want to create a stored procedure with a temp table, right now, the only way to do it is with SQL DB. SQL DB can be used for smaller databases of only four terabytes or smaller. It'll perform better than a Lakehouse or a Warehouse for SQL tasks, because unlike both of those data stores, there are a lot more options for index improvements and functionality that you can create. Like Warehouse and Lakehouse, data inside a fabric SQL DB is immediately copied to one lake, and this means that changes are made to the data are immediately available in Power BI if you're connecting via direct lake. Fabric SQL DB is de designed with a lot of low maintenance features to decrease the need to know or do a lot of database tuning. A full backup of the database is created every week, and differential backups are created every 12 hours. Transaction log backups are taken every 10 minutes, and this means that if something…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.