ChatGPT Lied To Me
I’ve been seeing more and more noise about how ChatGPT can help with technical stuff, writing code, all that. Well, I wanted to know how best to set up...
2023-04-21 (first published: 2023-04-10)
814 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Keeping Things Running
Today and tomorrow, as I write this, the Green Country Hamfest will be running up in Claremore, OK. Tomorrow morning, I'll be there to check out the tables and maybe pick up some new radio gear. I'll also be volunteering to help run the doors. Largely it involves just checking to be sure people paid […]
2023-04-08
82 reads
20 Minute Sessions: A Couple of Thoughts
At the most recent SQL Bits, I gave two 20 minute sessions. I also gave one last year. There is a little bit of controversy around these (nothing real,...
2023-03-20
19 reads
#PGSQLPhriday 006: Wrap Up & Summary
Your mission, if you chose to accept it, was to share a single tip/hint/fact/something that you wish you’d known about PostgreSQL when you were just getting started learning it....
2023-03-17 (first published: 2023-03-06)
124 reads
Restore AWS RDS Databases On-Premises
Did you know that you can restore AWS RDS databases to a SQL Server 2022 instance running locally using native backup and restore? Well you can. Let’s talk about...
2023-03-13
45 reads
Sources of Inspiration
I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on […]
2023-03-12 (first published: 2023-03-11)
91 reads
What Happens on Azure SQL Database?
Last week I posted the results from using Extended Events to snoop on what happens inside an AWS RDS database. This week, I’m taking a look at what happens...
2023-03-06 (first published: 2023-02-27)
434 reads
#PGSQLPhriday 006: What I Wish I Knew While Learning PostgreSQL
Well, for those who don’t know me, I’m just barely started on my PostgreSQL journey. So, what the heck can I contribute to this conversation? Not much, but I...
2023-03-03
33 reads
One Thing You Wish You Knew While Learning PostgreSQL: PGSqlPhriday #006
I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
18 reads
Query Store Data Cleanup
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
282 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers