30Apr 2025 by Grant Fritchey No Comments | Grant Fritchey
Too many people are unaware of the importance of using the Cost Threshold for Parallelism to address query performance and the need to change the value.| Grant Fritchey
26May 2025 by Grant Fritchey No Comments | Grant Fritchey
A quick tutorial on how to use AI in DBeaver as a fundamental tool to help you write PostgreSQL code a little faster and better.| Grant Fritchey
Intimidating Databases and Code| Grant Fritchey
31Mar 2025 by Grant Fritchey 4 Comments | Grant Fritchey
This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on. Figured I’d just let you know up front. In the last year there have been several very large scale emergency events, examples include Hurrican Helene in […]| Grant Fritchey
Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML and the AI will read the execution plan. I had to test it out and then overshare my results with all of you. We Need A […]| Grant Fritchey
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and Cross Fitters, we tend to be shy and withdrawn about our predilections. BWA-HA-HA! Ok, like Vegans and Cross Fitters, you can’t get a ham to shut up about playing radio. Anyhoo, I’ve been experimenting with a brand new, and somewhat buggy, […]| Grant Fritchey
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of the biggest blockers would be: For this blog post I want to focus on the last one, Event Overload. There really are a lot of events […]| Grant Fritchey
Answering the question "Can You Tell Why a Plan Didn't Go Parallel" within SQL Server using Execution Plan properites.| Grant Fritchey
When Covid took out the PASS organization, I had someone say to me, “Well, that’s the end of the data community.” My response was pretty simple, “Nope. The community is the people, and they’re not going anywhere.” I was right. And I was wrong, but not because of PASS. Splintered I was asked recently, in […]| Grant Fritchey
Answering the question, can you see table valued parameters in Extended Events. The answer, is pretty surprising.| Grant Fritchey
Just a bit of a rant to try to get people to use your voice so that you can do more to advance your career.| Grant Fritchey
Reading through an execution plan to understand window functions can be a little tricky, so stick to the basics.| Grant Fritchey
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple question: What do you think about PostgreSQL events? Prior to this year, I’d never attended an event focused on PostgreSQL. Heck, I’d never attended an event that had an intentional track or learning pathway, or whatever, focused on PostgreSQL. In the […]| Grant Fritchey
In my entry for T-SQL Tuesday #166, I discuss the reasons why not extended events, which circle right back around to how search engines work.| Grant Fritchey