Copy Files to a Docker Container
One of the things that’s handy when working with containers is being able to move files in and out of the container. Certainly you can do this from a...
2019-08-16 (first published: 2019-07-31)
411 reads
Automating Replication On Your Server
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
82 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration […]
The post MaxDOP Added...
2019-07-31
21 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration in SQL 2017+) and...
2019-07-31
11 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration in SQL 2017+) and...
2019-07-31
127 reads
Header Query Crossword
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
58 reads
How to store a password in a database
Hello, and welcome to today’s class on storing passwords in a database. Don’t store passwords in a database. Thanks for attending. Photo by James Sutton on Unsplash.
The post How...
2019-07-31
261 reads
Off-Topic Origem HS-3 Headphones Review
I’m a big fan of music when I’m moving through life, and I use a lot of headphones. Between the gym, travel, and downtime between volleyball matches, I often...
2019-08-05 (first published: 2019-07-30)
265 reads
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
The post Make Sure Your SQL Servers...
2019-07-30
8 reads
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
The post Make Sure Your SQL Servers...
2019-07-30
40 reads
Blogs
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...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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