A Fine Slice Of SQL Server
Steven Sanderson joins on multiple columns:
Let’s start with a simple scenario. You have two data frames, and you want to merge them based on two columns:
IDandYear. The goal is to combine the data where theIDandYearvalues match in both data frames.
All of the examples here use the merge() function, so check them out.
Marco Russo compares and contrasts:
What is the right choice between Direct Lake and Import mode in Power BI?
At SQLBI, we do not publish content until we have had enough time to experiment with and collect data about new features. We usually don’t break the news unless we have enough time to test a feature in preview and consider the released service solid enough. This did not happen with Direct Lake, and we have not published any Direct Lake content yet, but it seemed not urgent for reasons we will see soon. However, the feedback collected from many attendees of SqlBits 2024 and the first Microsoft Fabric Conference raised the alarm: too many people have an incorrect perception of Direct Lake, which should be addressed as soon as possible to avoid architectural mistakes and unnecessary additional implementation costs.
Click through for the tl;dr version, followed by the explanations.
Comments closedJosephine Bush sets up a failover group in Azure SQL Database:
In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to ensure your information is always within reach. Among these tools, failover groups shine, ready to jump into action whenever there’s a hiccup. So, let’s explore how failover groups in Azure SQL Database work their magic, ensuring your data stays safe and sound despite unexpected challenges.
Read on for the step-by-step instructions.
Comments closedElena Drakulevska takes us through some of the accessibility features in Power BI:
As data professionals, we’re constantly striving to create reports that effectively communicate insights to our audience. Did you know that within Power BI, there are hidden accessibility features that can enhance the usability for all users—with minimal effort on your part? Today, we’re digging into this overlooked aspect of Power BI and exploring how these features can elevate your data visualization projects.
Click through for three features.
Comments closedNikola Ilic performs a migration:
Here is my scenario: there is an existing Power BI semantic model in import mode (in reality, there are many of them, but for the sake of keeping things simple for this blog post, let’s pretend that there is only one semantic model to be migrated).
Click through to see what the current state of the semantic model looks like, as well as the way to migrate. It’s not trivial, but Nikola does take us through it step by step.
Comments closedChris Webb shows a map in a paginated report:
The built-in mapping functionality in Power BI paginated reports is fairly basic. However the integration of Power Query into Power BI paginated reports gives you an interesting new way of creating maps in paginated reports: you can call the Azure Maps API using Power Query and display the image returned in an Image report item. In this blog post I’ll show you how.
Click through for the demo.
Comments closedMuhammad Ali explains quite a few of the security terms in PostgreSQL:
PostgreSQL has a fine grained system for for managing user roles and privileges. This helps admins decide who can access certain data and what they’re allowed to do with it. It’s about managing permissions, where you can create different roles and roles can be a member of other roles.
In this blog, we will dive into PostgreSQL user roles and permissions, covering databases, schemas, and other objects level privileges, following a FAQ format.
Most of this is similar to security in SQL Server, though there are some differences to watch out for.
Comments closed