db_ddladmin Jr.

A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading

Tracking the Inaccurate Cardinality Estimates

Tracking the Inaccurate Cardinality Estimates

When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release  of SQL...

Altering the Default Schema for a User

I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...

Tech Lunch News

Červencové novinky ze světa dat byly trochu prázdninové a odpočinkové, ale i tak jsme se podívali na pár zajímavých a šikovných demíček, které by se vám mohli hodit.
Co nového...

Tech Lunch News

Microsoft Fabric: Lakehouse vs Warehouse video

Since Microsoft Fabric became available, I blogged about it and have an introduction video on Fabric that you can view here. I wanted to follow up with a short 30-minute video...

How do I tell if a user is orphaned or actually created without a login?

One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading

Steps to Have a Service Principal Take Over a Dataset in Power BI When Using Data Gateways

A little background for those new to using Power BI and Data Gateways. If the data source for your Power BI dataset lives on-prem or behind a private endpoint,...

Azure DevOps: Enterprise Power BI report deployment with connections to Shared datasets

(2023-July-15) Let's say you have a collection of Power BI .pbix files stored in a git-based source control system (GitHub, Azure DevOps, or any other system). Among these files, one...

Enhancements I’d Like to See in the Power BI Treemap Visual

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...