A really handy feature in Kubernetes is port forwarding. This can be used to narrow down an issue when connections are failing to SQL Server running in a cluster....
2019-09-17 (first published: 2019-09-04)
1,012 reads
Statistics are very important in the query...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-09-04
206 reads
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-03
18 reads
So, if you’ve been following my blog you know my love for internals. Well, I needed to find out exactly how something worked at the startup of a SQL...
2019-09-17 (first published: 2019-09-03)
269 reads
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
123 reads
A quick post about pulling docker containers (this applies to docker run too)…when specifying the container image, the container image name and tag are case sensitive. We’re not going...
2019-09-03
290 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
27 reads
You only have a few more weeks to sign up for one of my favorite events, Techorama. This year is the second time the event will be held in...
2019-09-03
14 reads
SQL Server Integration Services is well designed for retrieving and processing data on the fly, directly in the data flow pipeline. However, there are circumstances that occasionally require the...
2019-09-03
40 reads
However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...
2019-09-13 (first published: 2019-09-03)
263 reads
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...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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