Press "Enter" to skip to content

Day: August 4, 2023

Blocking Trees in sp_HumanEventsBlockViewer

Erik Darling talks up a famous Canadian:

I know there’s been a lot of blog content about the creation of and updates to my stored procedures lately. I try to consolidate as much as possible, but this one comes from Valued Contributor©.

The one, the only, the Canadian: Michael J Swart (b|t) recently contributed a really cool piece of code that I’ve been dying to have since I created sp_HumanEventsBlockViewer: the entire blocking chain is visualized in the results.

Click through to see what it looks like, and next time you see Michael, give him a thumbs up.

Comments closed

Connecting to SQL Server 2022 via Azure AD

Deepthi Goguri makes a connection:

Applicable to-

SQL Server 2022 on-prem on Windows and Linux and SQL Server 2022 hosted on Windows Virtual Machines.

Once you install the SQL Server, there are three different authentication methods that you can use to connect SQL Server along with the Windows and SQL Server authentication. They are –

  1. Azure Active Directory Universal with Multi-Factor Authentication
  2. Azure Active Directory Password
  3. Azure Active Directory Integrated

Read on for the pre-requisites as well as a detailed guide on how to set everything up.

Comments closed

Logging Notebook Runs in Microsoft Fabric

Reitse Eskens checks the logs:

I reported an issue yesterday with Microsoft Support and during the following call today (they’re really quick to set up an initial meeting), the support engineer showed me where I can find a lot of logging information.
Suppose you’ve got a notebook that has been run a few times. The front-end will only retain the information from the last run. If you see an error, for example this one

Click through to learn where you can find these execution logs.

Comments closed

Range-Based Groupings in Power BI

Gilbert Quevauvilliers pulls back the curtain:

I was once again working with the grouping feature in Power BI Desktop.

This time I had a lot of values that I wanted to put into multiple groups. I also did not want to select the individual values (I have previously shown this in my blog post Creating a group with all values (Even if not in the data) in Power BI)

It is amazing that sometimes it takes me a while to fully understand how to use some features in Power BI and today was one of those days!

Click through to see what Gilbert learned and how you can use that information to group by ranges instead of individual values.

Comments closed

Business Problems and Business Solutions

Kurt Buhler tells a story:

Bink the Data Goblin is a Data Analyst who supports her department by making, maintaining and helping others with Power BI solutions. Bink is quite proficient at Power BI, and is recognized in her user community as a go-to person for answers to Power BI questions. Recently, Bink was promoted to a position in their Center of Excellence to help her department make the most of Power BI.

One day, Bink receives a message on Teams from Bonk the Business Goblin. Bonk is an Analyst who works in Finance and is typically responsible for the reporting on behalf of the Finance team. Bonk asks…

I think some of this is a little idealized (or I’m a bit cynical) but it’s a good reminder that the technical domain is important but not the only thing to think about.

Comments closed