SQL Homework – October 2022 – Replication part 2

In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading

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