Off to THAT Conference

I’m in Round Rock, TX today at THAT Conference. I attended THAT Conference in Wisconsin Dells last summer, and it was fun. I took my wife, but I wish...

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

Videos from MITRE ATT&CKcon 4.0

If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...

A New Word: Lyssamania

lyssanmania – n. the irrational fear that someone you know is angry at you, that as soon as you wander into the room, you’ll be faced with a barrage...

Exploring the Spark Connect gRPC API

All Spark Connect Posts
Code
Goal of this post In the first two posts, we looked at how to run some Spark code, firstly against a local Spark Connect server and...

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

I can no longer recommend Liquid Web for hosting

I’ve had a really disappointing experience with the Liquid Web sales team, regarding the web server that hosts this blog post you’re reading right now. My disappointment is compounded...

SQL Server documentation refresh: Logical and physical showplan operator reference

Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...

T-SQL Tuesday #170 – Learning from Failure

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

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