Grant Fritchey

30Apr 2025 by Grant Fritchey No Comments

So You Think You Should Get a Radio

Misc

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 the US and yesterday's massive power outage in Spain, Portugal and France. There have been others as well. Before I go further, my heart goes out to all the people affected in Europe. I hope no one was too hurt by the outage and you all recover quickly. What's been somewhat unique in all these cases is that cel phone services have gone out, on a massive scale. Which means everyone is cut off, and…

21Apr 2025 by Grant Fritchey 2 Comments

Can AI Read Execution Plans?

SQL Server

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 Query Here's a query: SELECT c.CustomerID, a.City, s.Name, st.Name FROM Sales.Customer AS c JOIN Sales.Store AS s ON c.StoreID = s.BusinessEntityID JOIN Sales.SalesTerritory AS st ON c.TerritoryID = st.TerritoryID JOIN Person.BusinessEntityAddress AS bea ON c.CustomerID = bea.BusinessEntityID JOIN Person.Address AS a ON bea.AddressID = a.AddressID JOIN Person.StateProvince AS sp ON a.StateProvinceID = sp.StateProvinceID WHERE st.Name = 'Northeast' AND sp.Name = 'New York'; This query results in this execution plan: There are some tuning opportunities here.…

11Apr 2025 by Grant Fritchey 2 Comments

Using AI for Data Conversion

Tools

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, radio, the Baofeng DM-32UV. I'm writing this blog post about how I am using an AI for data conversion to make it a little easier to use this radio. The Problem The DM-32 is a Digital Mobile Radio (DMR) as well as an analog radio. You can follow the link to understand all that DMR represents when talking radios. I want to focus on the fact that you have to program the behaviors into a…

31Mar 2025 by Grant Fritchey 4 Comments

How Do You Pick Events in Extended Events?

SQL Server

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: Familiarity (more comfort in Trace or DMVs) Lack of Knowledge (just don't know how it works) XML (I agree) Event Overload (there are just too many) For this blog post I want to focus on the last one, Event Overload. There really are a lot of events in Extended Events. I don't just think that's a good thing. I think it's a GREAT thing. However, I get it. I hit the same problem, regularly. Which events do I use to do thing that I'm trying to do? Except for blogs like this one, there's not always…

24Mar 2025 by Grant Fritchey 2 Comments

Can You Tell Why a Plan Didn’t Go Parallel?

SQL Server

Let's face it, most of the time, you probably don't want your SQL Server execution plans to go parallel. After all, that's why, instead of adjusting the Cost Threshold for Parallelism (as you should have), you've set the Max Degree of Parallelism to 1 (I see you out there). However, some of you recognize that, in fact, some queries need to run in Parallel. Yet, sometimes, a query you think should run in parallel doesn't. Can you tell why a plan didn't go parallel? If It's Not Parallel, Why Not? The good news is, this question is really simple to answer. I'm sure you'll be shocked when I tell you that it's right there in the execution plan. The bad news is, you're going to have to open up the…

20Mar 2025 by Grant Fritchey 3 Comments

Sic Transit Gloria Community

Professional Development

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 a single word, to describe the data community. I chose 'Splintered.' Why? It's because of social media. We leaned pretty hard on having a limited number of channels for communication within the community. There were really only a couple of choices. Today though, we're scattered to the four winds. BlueSky has brought in some people. Others are on Mastodon. You'll still find people on X or Facebook. However, even more are on LinkedIn. Don't forget…

17Mar 2025 by Grant Fritchey No Comments

Can You See Table Valued Parameters in Extended Events?

SQL Server, You Can't Do That In Profiler

I live for questions and this was an interesting one. Can you see Table Valued Parameters that have been passed in to Extended Events? I literally have no idea. I'm sure we'll see something, I just don't know what. Time to find out. Table Valued Parameters I don't want to get in to whether or not table valued parameters are a good or bad thing. Like anything else, I'm sure they can be used for good or for evil. However, just like knowing what value was passed to an integer, I can see why you may want to know what was passed in to a table valued parameter. To get started, let's create a table type: CREATE TYPE ErrorList AS TABLE ( ErrorTime DATETIME, UserName sysname, ErrorNumber INT, ErrorMessage NVARCHAR(4000)…

13Feb 2025 by Grant Fritchey No Comments

Free PostgreSQL Performance Monitoring with pgNow

PostgreSQL

I've been putting together a new PostgreSQL session called "Performance Monitoring for the Absolute Beginner." There are several ways to get an understanding of how well your queries are running in PostgreSQL, but, frankly, all of them are a bit of a pain to someone coming from the land of Extended Events (ah, my one true love). Because of this, I saw it as an opportunity to help those just getting going in PostgreSQL. I'll be presenting it for the first time at Postgres Conference in Orlando on March 19, 2025. Come on by. Anyhoo, wouldn't it be nice to maybe have a shortcut, an easier way to look at this information? Well, there is. Redgate has been working on a completely free tool for leveraging just this sort of…

07Oct 2024 by Grant Fritchey 4 Comments

RDS Connectivity

AWS, PostgreSQL, RDS

I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time, connectivity, while not the greatest, isn't that bad, or hard. I run a VPN on my phone and laptop. I can set up my RDS connectivity by getting whatever IP address I've been assigned, and I'm good to go. However, recently, for whatever reason, I could not make a connection to AWS RDS no matter what I tried. I even switched over to my phone. I dropped my existing database (which hurt, just a test database, but now I have to rebuild it). Nothing. I validated every single possible problem. I went through all the troubleshooting steps. Nothing. It's Nice to…

30Sep 2024 by Grant Fritchey 5 Comments

The Only Valid Test of a Backup is a Restore

Professional Development

Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I'm happy that you have backups. That's great. Can you restore them? Let's tell a story. I Play With Radios "WE KNOW! SHUT UP ABOUT IT! Damn radio people. Worse than crossfitters." Cool, cool! I won't get into the radio stuff.... too much. Just a quick setup. Please bear with me. There's an organization in the US, American Radio Relay League (ARRL). Founded back in the dawn of time, more or less the first radio club. Now, the ARRL does a lot of stuff for radio users in the US, but also everywhere, but there's controversy (when isn't there). One thing they did was build this…