Daily Coping 25 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...

SQLSaturday Orlando on October 8, 2022

This year we’re back at our usual location on the campus of Seminole State College for SQLSaturday #1030. You may remember that last year we couldn’t use the college...

Azure DevOps: Merging code to Main branch from a specific branch only

(2022-July-25) I really liked reading printed PC Magazines (https://www.pcmag.com/) or Computerworld newspapers (https://www.computerworld.com/) when I was in school. Those magazines pictured IT System or Database Admins as a special group...

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