A Fine Slice Of SQL Server
Tyler Chessman is like an onion:
Building a multi-layer, medallion architecture using Fabric Real-Time Intelligence (RTI) requires a different approach compared to traditional data warehousing techniques. But even transactional source systems can be effectively processed in RTI. To demonstrate, we’ll look at how sales orders (created in a relational database) can be continuously ingested and transformed through a RTI bronze, silver, and gold layer.
Read on to see how.
Leave a CommentDennes Torres wants to know who is your daddy and what does he do:
If you check the text of the queries, at the end of the text you will find content like this:
OPTION (label = N”{“DatasetId”:”1269551b-bf26-47de-b0f0-974fa60f7b08″,”Sources”:[{“ReportId”:”01ab9208-399a-47ec-b444-d03633fc3e1d”,”VisualId”:”30ac676503a0bd357312″,”Operation”:”AutoPageRefresh”}]}”)
This has an interesting meaning:
- We can use this information to track the query lineage
- Applications can send lineage (or more) to SQL using OPTION (LABEL) statement
Click through to learn how you can use this information.
Leave a CommentKevin Hill broaches a challenging topic:
Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind the scenes. And if you’re responsible for keeping it running, you need the budget to do it right.
Here’s how to make your case without getting buried in tech jargon or glazed-over stares.
Dave Wentzel has a very solid response to this in the comments. My point of emphasis is working in business terms. Think in terms of return on investment, especially if you can calculate it. That’s a real challenge for technical people because we think in terms of capabilities and don’t have much information on the practical effects of whatever it is we do all day, but figure out what your company uses for cost analysis and try to work in those terms.
Leave a CommentMichael Mayer doesn’t want to wait:
From time to time, the following questions pop up:
- How to calculate grouped counts and (weighted) means?
- What are fast ways to do it in R?
This blog post presents a couple of approaches and then compares their speed with a naive benchmark.
Read on for multiple options and then a quick performance comparison.
Leave a CommentDave Stokes shares some queries:
I am (slowly) adding handy PostgreSQL queries to my GitHub, and Vacuum is the newest category. The end goal is to have a compilation of queries for those of us who need to keep an instance healthy.
I’ve always liked these compendia of helpful queries. The downside is that these are PDF images, making them harder to use. But even so, Dave is accepting pull requests.
Leave a CommentKoen Verbeeck answers a question:
We’re a relatively small shop that has been using Power BI for our analytical needs for years now. We’re very pleased with the product, but the recent introduction of Microsoft Fabric has made us a bit anxious. When comparing Microsoft Fabric vs Power BI, it all seems very complex and we’re not even sure we need it. What will happen with Power BI? Will it be replaced with Fabric?
Click through for Koen’s advice and thoughts on the matter.
Leave a CommentPatrick LeBlanc is back with another compendium:
Welcome to the Fabric April 2025 Feature Summary! This update brings exciting advancements across various workloads, including Low-code AI tools to accelerate productivity in notebooks (Preview), session Scoped distributed #temp table in Fabric Data Warehouse (Generally Available) and the Migration assistant for Fabric Data Warehouse (Preview) to simplify your migration experience.
This one isn’t quite as long as last month’s release, but there are still a couple dozen entries.
Leave a CommentKellyn Gorman shares a few tips with us:
After the initial overview of memory monitoring in Oracle, particularly around the SGA and PGA, I wanted to take a deeper dive into the most common Oracle memory configurations. These include how memory settings are defined, how they interact, and the combinations you’re likely to encounter across different workloads. Oracle memory is a no-brainer for many of us who’ve been in the space for an extensive time, but I’ve come to realize, it can be a bit overwhelming and especially with recent changes from Oracle 12c on.
Click through for Kellyn’s guidance.
Leave a CommentKendra Little fixes a problem:
Forcing plans with Query Store can be a powerful tool—until it mysteriously fails. In real production systems, plan forcing sometimes just… doesn’t work. One common culprit is the cryptic
OPTIMIZATION_REPLAY_FAILEDerror.If you’re hitting
OPTIMIZATION_REPLAY_FAILED,try re-forcing the plan using@disable_optimized_plan_forcing=1.
Click through for a summary of the problem and additional helpful information on the issue.
Leave a CommentAndy Leonard doesn’t need to ask for permission:
The problem we are trying to solve is: Grant an Azure Data Factory permission to execute the ReST API method calls against artifacts in a Fabric workspace.
I begin visiting the Azure Portal. If you don’t have an Azure account, you can create one. You can do a lot of things in Azure for little money, but you need an account and that account needs to be secured by a working source of funds in case you leave a virtual machine running for days. Hypothetically. BE CAREFUL. DO NOT LEAVE A VM RUNNING FOR DAYS.
Good en passant advice. I once blew through a $250 Azure credit by laving an HDInsight cluster on for, uh, a few hours.
Leave a Comment