Power BI Monthly Digest – March 2020
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-03-24
47 reads
Blog Posts
Using Azure Data Factory Mapping Data Flows to populate Data Vault - PASS Video
(2020-Mar-15) Video recording of my webinar session on Using Azure Data Factory Mapping Data Flows to populate Data Vault at the recent PASS Data Architecture Virtual Group meeting.It was based...
2020-03-24 (first published: 2020-03-15)
477 reads
Your team can’t stop writing crappy code. Will Intelligent Query Processing fix it?
People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...
2020-03-24
32 reads
Connecting to the SQL Server Community Online: Uplifting Folks
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...
2020-03-23
24 reads
Daily Coping–23 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-23
24 reads
DROP IF EXISTS
It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to ... Continue reading
2020-03-23
299 reads
Extended Events: Live Data Explorer, Grouping
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
97 reads
SQLpassion in the time of Covid-19
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-03-23 (first published: 2020-03-16)
333 reads
SSIS Package Execution Failure – When google fails you :(
We have all done it, get some sort of cryptic error and the first place we go to search is Google hoping the sea of message boards and blog...
2020-03-23 (first published: 2020-03-14)
689 reads
T-SQL Tuesday Live–A Neat Solution
Travel is limited, or banned, in many cases these days. Events are cancelled or postponed, and there is a limit to how much contact we should have with each...
2020-03-23
20 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers