From the course: SQL Databases in Microsoft Fabric

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

SQL database: The big picture

SQL database: The big picture

From the course: SQL Databases in Microsoft Fabric

Start my 1-month free trial Buy for my team

SQL database: The big picture

“

- Now that we've covered the basics of Fabric, let us talk about how SQL Database in Fabric work. As mentioned in the intro, they cater to new use cases and personas. So after this big picture of how things work, we will also discuss how databases in Fabric are different to, for example, Azure SQL DB, but also other offerings in Fabric. like Warehouses or Lakehouses. Your SQL database in Fabric can of course be reached using a SQL connection, and there is not one single but actually two options, the SQL Endpoint and the SQL Analytics Endpoint. You may already have come across the latter in the context of other Fabric experiences. Both can all be used through the portal, but also through tools like SSMS or any other SQL client. Just with other experiences using it, the SQL Analytics Endpoint has limited capabilities. It is, for example, read-only, so it is great for analytical queries, but not usable for OLTP workloads, for example. That is what you would use this SQL Endpoint for. In…

Contents