A Fine Slice Of SQL Server
Gilbert Quevauvilliers backs into a number:
I was recently working with a customer and one of the questions they had is we are going to be running an ingestion process. We want to know how much Fabric Capacity this will be consuming.
The challenge with this question is that in Fabric a background capacity gets smoothed over 24 hours.
For example, when looking at the Capacity Metrics App I can see my overall usage, but HOW MUCH CAPACITY IS IT CONSUMING?
Read on for the answer.
Comments closedArindam Chatterjee and QiXiao Wang show off some preview functionality:
Building event-driven, real-time applications using Fabric Eventstreams and Spark Notebooks just got a whole lot easier. With the Preview of Spark Notebooks and Real-Time Intelligence integration — a new capability that brings together the open-source community supported richness of Spark Structured Streaming with the real-time stream processing power of Fabric Eventstreams — developers can now build low-latency, end-to-end real-time analytics and AI pipelines all within Microsoft Fabric.
You can now seamlessly access streaming data from Eventstreams directly inside Spark notebooks, enabling real-time insights and decision-making without the complexity & tediousness of manual coding and configuration.
Click through to learn more.
Comments closedRob Sewell walks through a recent experience:
Firstly, an apology to my friends (especially Randolph) in the documentation team at Microsoft. I know how hard you work to produce accurate and useful documentation, and I appreciate your efforts. This is not a criticism of your work, but rather an observation about the challenges I faced.
This is a story about a recent experience and the lessons learned along the way.
Read on for the issue and what Rob had to do. This is a case study in how hard it is to write good documentation, especially around the edges of what is possible.
Comments closedMichal Bar shows off a new capability:
A frequent request we receive from dashboard authors is the ability to have greater control over color settings.
Until now, color assignments in real-time dashboards were largely automatic. While this worked for basic scenarios, it often fell short in operational and reporting use cases where color isn’t decoration—it’s meaning. Data Series Colors is a new capability that gives authors direct control over how colors are applied to their visuals.
Read on to see how it works for real-time dashboards.
Comments closedGilbert Quevauvilliers performs some testing:
In this blog post I am going to show you how I completed the automated testing and then the results where I am going to compare Direct Lake, Import and DirectQuery and which one appears to be the best.
As always, your testing may very or be different to my tests below.
I would highly recommend that you use the method I have used and apply this testing technique to your data to understand and validate which semantic model would be best for your capacity.
Click through for details on the tests, query durations, and how the three major modes of data loading into Microsoft Fabric semantic models (Import, Direct Lake, Direct Query) fare.
Comments closedOlivier Van Steenlandt troubleshoots an issue:
When setting up database mirroring from Azure SQL to Microsoft Fabric for one of my demo databases, I ran into an issue while trying to connect to my Azure SQL database.
As you can see in the screenshot above, it seems that a setting on my logical SQL Server in Azure is misconfigured. Let’s resolve that in a couple of steps.
Click through for the screenshot, the specific error, and how Olivier was able to get things working.
Comments closedJon Lunn digs into a somewhat-new feature:
So first off, what are they? They are basically a table object that is based on a query. (Yes I know they are called ‘Views’… more on that later) So like a view, it is defined by a SQL query, but it doesn’t just sit over tables and runs that SQL when you query that view. What it does do is take the ‘View’ SQL query that defines the Materialised Lake Views, runs it and stores the query result data into a delta table. So when you query that view, you get the data from that object, and not the underlying tables. Neat! Save a bit on computing query time!
Read on to learn more about what they are, how they work, and when they can be useful.
Comments closedPankaj Arora announces a new preview feature:
Until now, surge protection applied only at the capacity level—meaning all workspaces shared the same rules.
What’s new: workspace-level surge protection
We’re taking surge protection to the next level with workspace-level controls. This update gives you more granular management of compute usage across your organization.
Read on to see what this means for organizations using Microsoft Fabric.
Comments closedLaura Graham-Brown continues a series on variable libraries in Microsoft Fabric:
Lakehouse shortcuts are a popular addition to the Fabric set of tools to access data easily without copying it. Using a variable library in lakehouse shortcuts means its easy to point shortcuts to an alternative location. This great for ALM using development, test and production workspaces.
Read on to see how it all works.
Comments closedAaron Merrill announces a new preview offering:
Microsoft Fabric continues to expand the OneLake security surface with new granular REST API support for role management, giving developers and platform teams far more control over how security policies are created, retrieved, and managed programmatically. In addition to the existing batch role API, Fabric now offers discrete Create, Get, and Delete role APIs, making it easier to build incremental, automation-friendly security workflows that align with modern DevOps and governance practices.
Click through for a quick explanation of how things did work and how they will work going forward.
Comments closed