Unity Catalog in Databricks provides a single place to create and manage data access policies that apply across all workspaces and users in an organization. It also provides a...
2022-11-28 (first published: 2022-11-23)
24 reads
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
218 reads
Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things. I choose...
2022-10-07 (first published: 2022-09-26)
206 reads
I’ve now helped people with this issue a few times, so I thought I should blog it for anyone else that runs into the “mystery”. Here’s the scenario: You...
2022-08-31 (first published: 2022-08-20)
226 reads
You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I...
2022-07-18 (first published: 2022-06-30)
166 reads
For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their...
2022-07-15
106 reads
I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs...
2022-07-06 (first published: 2022-06-22)
218 reads
I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long...
2022-03-30 (first published: 2022-03-22)
211 reads
I have been in Azure DevOps pipelines a lot recently, helping clients set up automated releases. Many of my clients are not in a place where automated build and...
2022-03-09 (first published: 2022-02-22)
373 reads
I’ve been working on a project to populate an Operational Data Store using Azure Data Factory (ADF). We have been seeking to tune our pipelines so we can import...
2022-01-17 (first published: 2022-01-06)
166 reads
I am writing this blog post as contribution to #NewStarNovember and what got me...
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...
By James Serra
The big announcement at the PASS Data Community Summit 2022 was that SQL Server...
Comments posted to this topic are about the item Basic Checks on a New...
Comments posted to this topic are about the item Assigning a Server Role
Comments posted to this topic are about the item Cloud First Software
Ask SSC