Function Vs. Performance

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...

Daily Coping 3 Oct 2022

Today’s coping tip is to write down three things you appreciate about yourself. I don’t mind self-evaluation, but I struggle a bit to publicly talk about things I do...

Scary Scalar Functions - Part Four: Your Environment

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Part Four: Your Environment

Foreword
In the previous posts, we have learned why Scalar Functions (UDFs) are bad for parallelism...

Being a script magpie

Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading

Community Tools Month 2022 - dbatools

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September Community Tools Awareness Month.
In September, I want you to improve community knowledge about one free...

Storytelling with Data – Enertia User Conference 2022

Thank you to everyone who attended my session at the Enertia User Conference in Las Vegas earlier this month! It was a blast meeting everyone, and I can’t wait...

Data lake architecture

I have had a lot of conversations with customers to help them understand how to design a data lake. I touched on this in my blog Data lake details,...

Daily Coping 30 Sep 2022

Today’s coping tip is to find a new way to use one of your strengths or talents. I asked someone for strengths recently. Most of those items are things...

Why You Need Presentation Skills

And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as...

Daily Coping 29 Sep 2022

Today’s coping tip is to avoid saying “I should” and make time to do nothing, or do something fun. I’m writing this ahead of time, and I am doing...