A Primer on Attaching Databases with PowerShell Method AttachDatabase

A Primer on Attaching Databases with PowerShell Method AttachDatabase

Attaching a SQL Server database using PowerShell can be straightforward. Here's an effective and easy approach using the...

Updating Teslamate to the Latest Version

I noticed Teslamate wasn’t updated. In fact, I hadn’t had any data captured in nearly a month and I’ve been too busy to notice. I was concerned something had...

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