What you can do is based on more than your direct permissions.

What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading

Registered for the Data Community Summit

I was reminded this week that I needed to get registered for the Data Community Summit 2022 since I’m speaking. I also needed a hotel, so I took some...

Daily Coping 5 Oct 2022

Today’s coping tip is to choose to see your mistakes as steps to help you learn. I preach this with the kids I coach. Mistakes will happen, but let’s...

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