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

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

A New Word: Fitzcarraldo

fitzcaraldo – n. a random image that becomes lodged deep in your brain – maybe washed there by a dream, or smuggled inside a book, or planted during a...

Creating a Speaking Failures Support Group

Earlier this week the emails went out to speakers who submitted to the PASS Data Community Summit 2023 conference. These were acceptances and rejections, letting people know the results...

The two hardest concepts of security are Who? and Where?

I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading