Scary Scalar Functions - Part Three: The Cure

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance
Part Three: The Cure

Foreword
In the first two parts, we have seen why the Scalar functions (UDFs) are a problem for the...

Adopting a DevOps Process for your Database – SQL Saturday New Jersey 2022

I had a great talk today at SQL Saturday New Jersey 2022 on DevOps and databases. Good crowd and good questions. Got caught in a spotlight picture as well:...

Daily Coping 22 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Daily Coping 21 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

SSMS Put pinned tabs in their own row

A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that ... Continue reading

Daily Coping 20 Jun 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Power BI: Dynamically Removing Errors From Columns in M

If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your data...

Storing sp_BlitzIndex to a Table Between Reboots

I mentioned in my New Database Job – The 90 Day Plan blog how I have a trick for storing index usage stats up until close to the next reboot...

SSRS Subscription E-Mail Error

It is that time again.  This time coming to you from a Mcdonald’s so my son can get out some energy, and it is 105 degrees outside. This will...

Thank You Wendy!

I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...