Restore HEADERONLY and FILELISTONLY

Good day reader.  This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...

DevOps From Redgate

In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...

Daily Coping 4 Oct

Today’s coping tip is to free up time by canceling any unnecessary plans. I. Suck. At. This. I don’t like to blow things off, and I do like to...

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