Learning more Kubernetes
I’ve been slowly working my way through the 50 days of Kubernetes (K8s). As you might have guessed if you remember my first post, this has been more than...
2019-08-08 (first published: 2019-07-15)
427 reads
Blog Posts
PASS Summit 2019 – spending the time
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
28 reads
Rename Azure VM OS Disk
In a recent post about creating Azure VMs using PowerShell, I noted a common issue that I run into where the name of the OS disk does not conform...
2019-08-08 (first published: 2019-07-16)
8,987 reads
T-SQL Tuesday #117 Invitation – When Have You Used MOT Tables?
When Memory-Optimized Tables (MOT) were announced for SQL Server, there was a lot of excitement about the technology. After this was released on SQL Server 2014, feelings waned with...
2019-08-08
58 reads
All Day Seminar on DevOps in Oslo
In just a couple of weeks, I’ll be presenting an all day session on DevOps for databases. It takes place on Friday, August 30th. You can click here now...
2019-08-07
11 reads
Gatekeeping and why language matters
This is the second in a series of posts about gatekeeping in Information Technology and other fields. Negative terminology The language we use matters. In the first post I...
2019-08-07
26 reads
How I Continuously Learn About SQL Server
Watch this week’s episode on YouTube. In order to stay current in a technology you have to immerse yourself in community content. Documentation is good for knowing the specification...
2019-08-07 (first published: 2019-07-16)
997 reads
Is it just me or does msdb feel a lot like a user database?
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
662 reads
Microsoft Azure and Oracle Cloud
Microsoft and Oracle recently announced a joint cloud partnership (I have seen the word multi/cross-cloud to explain this) which I found very fascinating to read. It is currently in...
2019-08-07
32 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
In the...
2019-08-06
8 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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