A Fine Slice Of SQL Server
Osheen MacOscar creates a sparkline or three:
This is the second blog in a series about the {sparkline} R package for inline data visualisations. You can read the first one here. In this post I will be demonstrating how you can include sparklines inside HTML tables.
Read on for the instructions. Osheen implements box plots, bar charts, line charts, and even bullet charts in an HTML table.
Leave a CommentAmar Digamber Patil makes an announcement:
In our ongoing effort to enhance the visibility, accessibility, and efficiency of SQL database in Fabric, we are making a change that ensures organizations can make an informed decision before default enablement takes effect. We have changed the timeline for when SQL database will be enabled by default.
Initially, we planned to roll out the checkbox notification on February 8, 2025, and enable SQL Database in Fabric by default on March 8, 2025. However, based on the need for more flexibility, we have adjusted the timeline:
Click through for the new timeline. You can, of course, enable it on your own today if you are a Microsoft Fabric administrator with rights to change these settings.
Leave a CommentSteve Jones tries different methods:
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after he published it, he sent me an addendum to note that GENERATE_SERIES was available in Fabric and that could be used.
I ran a few tests last week, but as I read the comments on John’s article, I realized that there were 3 ways of setting up these tally tables that I’ve used and thought I’d summarize them a bit in this post. There’s a fourth way, but I haven’t used it.
My take on this is, it doesn’t really matter which technique you choose, especially if you’re using it to build a permanent tally table that you can later query from any app. In that case, it’s a one-time cost. If you’re building these on the fly often enough that the performance matters, then my first question, instead of “Which of these is fastest?” is, “Why can’t I just have a permanent tally table?”
Leave a CommentJohn Kerski notes a pain point:
“I hate to tell you this, but it’s not available for us yet.” This is an all-too-common phrase I find myself saying to customers in U.S. Sovereign Cloud tenants who come across new features in search engine results only to find they’re not available in our regions. For those unfamiliar, U.S. Sovereign Cloud regions allow U.S. government, public sector, and other highly regulated entities to use the cloud with the security, compliance, and data sovereignty required by their organizations.
If you do a search for “sovereign cloud,” you will find that most of the cloud providers have their own Sovereign Cloud if you are interested in the concept for any other cloud services you need to use. In this article, I am going to look specifically at how you extend this support to Power BI, and make a few suggestions for how I think it could work better.
I call John’s pains and raise him “We can only use Power BI Report Server here.”
2 CommentsPatrick Gruenauer checks out a new module:
The new PowerShell Entra ID Module is a powerful tool designed to streamline the management and automation of Microsoft Entra resources. This module is part of the Microsoft Graph PowerShell SDK and offers a range of functionalities to enhance administrative tasks.
One of the key benefits of the Microsoft Entra PowerShell module is its focus on usability. Unlike MS Graph, the module is more user-friendly to operate. Let’s dive in.
Click through for a demonstration of what you can do with it.
Leave a CommentKenneth Omorodion explains why you sometimes need to bust out the VACUUM:
Efficient data management in Microsoft Fabric is a necessity in maintaining large-scale partitioned Delta tables. In dynamic datasets with frequently generated new files, the need to ensure the removal of stale files becomes very important to prevent storage bloating. In settings with partitioned tables, where data is in a hierarchical structure (e.g., by year, month, day), this can be particularly challenging, and files must be cleaned without disrupting active data. Learn how the VACUUM operation can help optimize delta tables.
Read on to learn more.
Leave a Comment