I have a client who was upgrading some servers from pre-2022 versions of SQL Server to SQL Server 2022 CU7. They had some multidimensional SSAS cubes that were to...
2023-09-13 (first published: 2023-08-18)
158 reads
This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...
2023-09-06 (first published: 2023-08-17)
93 reads
If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...
2023-08-21 (first published: 2023-08-01)
296 reads
I recently created a treemap in Power BI for a Workout Wednesday challenge. Originally, I had set out to make a different treemap, but I ran into some limitations...
2023-08-07 (first published: 2023-07-14)
167 reads
One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...
2023-06-21 (first published: 2023-06-03)
217 reads
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from...
2023-05-01 (first published: 2023-04-21)
631 reads
Did you know that you can change the browser used by SQL Server Management Studio to authenticate using Azure Active Directory to a SQL database in Azure? I had...
2023-04-12 (first published: 2023-03-28)
283 reads
In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color...
2023-02-25 (first published: 2023-02-24)
46 reads
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power...
2023-02-06 (first published: 2023-01-24)
283 reads
In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
234 reads
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Guys, good night! I have a situation in my SQL Server Management Studio where...
I just upgraded SSRS from 2016 to 2022. This is my first time doing...
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...
Ask SSC