AI in the DBeaver Query Editor - 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
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
Hello everyone! Just a quick note. I’ve removed all my slide decks from SlideShare. I found they were inserting ads into the slides and I didn’t sign up for that when I initially used that platform to share my slides. My slides are now located on GitHub. I didn’t move every slide deck. I have […]| Grant Fritchey
26May 2025 by Grant Fritchey No Comments | Grant Fritchey
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll give it a shot. One aspect of my job is to provide support to our clients. No, I’m not on call (thank the gods), but I’ll […] The post T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events appeared first on Grant Fritchey.| Grant Fritchey
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that the New Session window in SSMS for Extended Events always opened to the wrong size. Here’s SSMS 20: At the bottom of the screen on the […] The post SSMS 21 Fixes Irritating Problem appeared first on Grant Fritchey.| Grant Fritchey
I’m working on an update to my Query Performance Tuning book for SQL Server 2025 and I found myself wondering, will a query hint be immediately apparent in an execution plan without runtime metrics (AKA, Estimated Plan)? My assumption was a resounding yes, but you have to check. Query Hint in Estimated Plan I’ve got […] The post Query Hints and Estimated Plans appeared first on Grant Fritchey.| Grant Fritchey
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love visiting Poland… Anyway… Great event. Worth your time to attend, and if you’re a speaker, oh, you don’t want to miss this one. The data community there is just amazing. I always walk through the vendor floor to see what’s what. […] The post Do Yourself a Favor, Check Out Woodler appeared first on Grant Fritchey.| Grant Fritchey
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get an answer, is great. No question. How that was handled, tone of moderation, other stuff, maybe it wasn’t all handled as well as it could have […] The post Stack Overflow & AI appeared first on Grant Fritchey.| Grant Fritchey
Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio 21 for a little over a week now. You should check it out. It’s been mostly stable (I got a crash. I didn’t report it because […] The post SSMS 21 appeared first on Grant Fritchey.| 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
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with Steve). Because of this, I’m going to bend the rules a little (sorry Steve) and give you a few days to get your posts together. In […]| 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
