Daily Coping 2 Aug 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...

Free Webinar – T-SQL Best Practices and Tuning for the BI/DWH Developer

I’m giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract: When building a data warehouse (DWH) in the Microsoft Data Platform stack, you typically have...

SQLSaturday Baton Rouge is back!

Looking forward to jambalaya at #SQLSatBR in THIS SATURDAY! Also looking forward to speaking and seeing all of you there, I guess... Register today: https://sqlsaturday.com/2022-08-06-sqlsaturday1026/After I stepped down from the...

Thank You Andy!

I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...

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

Daily Coping 1 Aug 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...

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

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

What's in a name? (T-SQL Tuesday #152)

Foreword
This month’s invitation is from Deborah Melkin (b|t), about venting anything you want. So let’s start this rant.

There are only two hard things in Computer Science: cache invalidation and...