Statistics and the Ascending Key Problem

I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...

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