Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your grubby fingers on the bits for SQL Server 2022 a few nanoseconds after you heard...
2021-11-29
67 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
It's All About the Gratitude
I'm writing this the day after the US holiday of Thanksgiving. Lots of things are said about Thanksgiving, positive, negative, in between. The core concept of the holiday is to take a moment to take stock of what you have. It's a good idea. Every so often, look around and acknowledge, depending on anyone's situation, […]
2021-11-27
108 reads
SQL Server 2022 and Learning
Microsoft announced the release of the next version of SQL Server, 2022. There's a bunch of new enhancements that we can all get excited about. I can't wait to test the "Parameter Sensitive Plan" optimization myself. We can look forward to seeing this stuff in action, and in detail, at the PASS Data Community Summit […]
2021-11-06
431 reads
Learning Is Challenging, So, Forgive Yourself
In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
2021-10-16
277 reads
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-15 (first published: 2021-10-04)
245 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-10-06 (first published: 2021-09-27)
581 reads
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-04
17 reads
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find that a lot of people seem to be resistant to the concept. I’m always surprised...
2021-09-29 (first published: 2021-09-20)
486 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
8 reads
Volunteer For Something
I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some […]
2021-09-25
228 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