A Fine Slice Of SQL Server
Arun Sirpal shows off how to scale an Azure Redis Cache instance:
Let’s assume that you started off with the lower editions and capacity with Redis and your developers tell you to scale the Redis cluster. Well first to use a cluster you need premium
Click through for a walkthrough of how you can scale out Azure Redis.
Comments closedRobert Cain continues a series on KQL:
In my previous post, we saw how the
searchoperator was used to limit the results of a query. This post will focus on thewhereoperator, which performs a similar function.Whereas
searchis used to limit based on matching of a string, thewhereoperator is used to match based on a condition. In this post we’ll see some of the conditions that can be used with awhereoperator to narrow down a dataset.
Read on for plenty of uses of the operator.
Comments closedMarco Russo and Alberto Ferrari explain one of the most important DAX functions:
CALCULATE, with its companion function CALCULATETABLE, is the only function in DAX that can change the filter context. Its use is very intuitive at first, and most DAX developers start using CALCULATE without knowing the most intricate details of its behavior. Then, sooner than later the use of CALCULATE becomes frightening because CALCULATE starts to misbehave. When this happens, it is nothing but a signal that you need to learn more theory and deepen your understanding of the behavior of CALCULATE.
In this article, we do not introduce the most complex behaviors of CALCULATE. Instead, we provide a beginner’s guide to CALCULATE, and we try to avoid making things simpler than they are. CALCULATE is definitely a complex function. Here we introduce its base behaviors, with a solid theoretical foundation.
Definitely a must-read if you work with Power BI and don’t have CALCULATE() down pat.
Tom Collins has some guidance for us:
-The Hashicorp database secrets engine (database secrets engine) supports a plugin for SQL Server
-It supports root credential rotation, dynamic roles , static roles , username customization
-Vault needs to be configured a user that at minimum :
Click through for those configuration notes.
Comments closedDany Hoter shows off dynamic M parameters in Power BI:
The user is creating an application in which he wants to embed Power BI.
The same Power BI report will be used in different contexts and the user wanted to have a different header each time and to provide the header as part of the URL.
There may be other ways to solve this problem(?) but as the solution was already using ADX, the user came with a way that involves Direct Query and a dynamic parameter to solve the dynamic header.
Click through to see how to solve this problem.
Comments closedSoheil Bakhshi’s reports get the Kate Moss treatment:
Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many reports.
A Thin Report is a report that connects to an existing dataset on Power BI Service using the Connect Live connectivity mode. So, we basically have multiple reports connected to a single dataset. Now that we know what a thin report is, let’s see why it is best practice to follow this approach.
Read on for Soheil’s thoughts on the topic and a tutorial on how to create a thin report.
Comments closed