Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if you’re pulling a new container image. But what if you’re using a 2017 container running...
2019-11-20
13 reads
Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if you’re pulling a new container image. But what if you’re using a 2017 container running...
2019-12-02 (first published: 2019-11-20)
2,148 reads
Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost ... Continue reading
2019-11-29 (first published: 2019-11-20)
1,099 reads
At best these phantom backups cause undue headache in troubleshooting. At worst, they make it impossible to recover in the event of a database related disaster. Join me for...
2019-11-20
18 reads
At best these phantom backups cause undue headache in troubleshooting. At worst, they make it impossible to recover in the event of a database related disaster. Join me for...
2019-11-28 (first published: 2019-11-20)
1,321 reads
In April, I said I was going to start learning Jupyter Notebooks. It’s November. Let’s get going with your first Jupyter Notebook. A quick aside before we start. I...
2019-11-28 (first published: 2019-11-19)
720 reads
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
9 reads
Intro
To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than it...
2019-11-19
25 reads
Intro To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than...
2019-11-19
10 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-19
15 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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