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

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

Things I Carry in My Travel Bag

A friend asked me for some travel tips and ideas recently. One of their questions was on what types of things do I actually carry on the road, both...

Disable Activity is Finally Available in Azure Data Factory!

Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...

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

I’m speaking at the Data Saturday Holland!

As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...

T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?

It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...

A high level view of the most costly queries by CPU

A high level view of the most costly queries by CPU

I want to see at a high level i.e at batch or stored procedure level, not at the individual...

Assigning a Default Schema to a New User–#SQLNewBlogger

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