Persisting SQL Server Data in Docker Containers – Part 1
What’s the number one thing a data professional wants to do with their data…keep it around. Let’s talk about running SQL Server in Containers using Docker Volumes on a...
2019-09-01
13 reads
Blog Posts
Persisting SQL Server Data in Docker Containers – Part 1
What’s the number one thing a data professional wants to do with their data…keep it around. Let’s talk about running SQL Server in Containers using Docker Volumes on a...
2019-09-01
804 reads
Persisting SQL Server Data in Docker Containers – Part 2
So in my previous post, we discussed Docker Volumes and how they have a lifecycle independent of the container enabling us to service the container image independent of the data...
2019-09-01
16 reads
Persisting SQL Server Data in Docker Containers – Part 2
So in my previous post, we discussed Docker Volumes and how they have a lifecycle independent of the container enabling us to service the container image independent of the data...
2019-09-01
118 reads
Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
11 reads
Persisting SQL Server Data in Docker Containers – Part 3
In the first two posts in this series we discussed the need for data persistency in containers then we discussed where the data actually lives on our systems. Now...
2019-09-01
197 reads
September on the Road
I am so excited for the next three weeks. This is a trip that has been in the planning for nearly 2 years. I have always loved travelling and...
2019-09-01
21 reads
The Journey to SQL Server 2019 – where does your own journey start?
[read this post on Mr. Fox SQL blog] A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was...
2019-08-31
23 reads
The Journey to SQL Server 2019 – where does your own journey start?
[read this post on Mr. Fox SQL blog] A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was...
2019-08-31
67 reads
Actual Kubernetes
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). I completed the first 3 sections (Days...
2019-08-30 (first published: 2019-08-19)
392 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