Troubleshooting SQL Server Error 8623: The query processor ran out of internal resources and could not produce a query plan

SQL Server Error 8623

At least once day, an application for one of the databases I manage gets this error:The query processor ran out of internal...

Friday Flyway Tips–The Version Control Blade

The Flyway Desktop Version Control tab is gone and a new blade has appeared in its place. This post looks at the changes and what that means for a...

A New Word: Candling

candling – v. intr. the habit of taking stock of your life on the occasion of your birthday, letting it serve as a kind of internal referendum on all...

Fabulous Stuff in Fabric – Part 3: Shortcuts

A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...

Using the Pure Storage PowerShellSDK2 - Part 4 - Classifying Workloads With FlashArray Tags

Welcome back to the fourth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, you’ll learn how to use Purity Tags to classify...

A temper, soft skills, and almost losing a job : T-SQL Tuesday #170

It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading

T-SQL Tuesday #170 – Learning from Failure

So what did I learn? I think a better question is, "What did I re-learn?"

Switching between different active physical relationships in a Power BI model

A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...

Using AI to create test data

Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...

Backing up the Teslamate Database

I was worried about some of my data, so I wanted to be sure I had a backup of my Teslamate system. This post covers the config I’d added...