I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...
2025-03-05 (first published: 2025-02-20)
128 reads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-02-10 (first published: 2025-01-31)
252 reads
With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...
2025-01-08 (first published: 2024-12-30)
1,746 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-12-09 (first published: 2024-11-27)
402 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-28 (first published: 2024-10-14)
257 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-10-21 (first published: 2024-09-30)
261 reads
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
42 reads
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-09-16 (first published: 2024-08-26)
143 reads
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-29 (first published: 2024-07-23)
475 reads
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-07-08 (first published: 2024-06-21)
200 reads
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Monoliths and Microservices
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers