T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
6 reads
T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
15 reads
T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
38 reads
Adding a Column with a Default Constraint
Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing...
2019-07-24 (first published: 2019-07-16)
478 reads
Painless Synchronization of Azure Blob Storage with AWS S3
Synchronization
Moving data between two cloud providers can be painful, and require more provider scripting if doing api calls. For this, you can benefit from a tool that abstracts the...
2019-07-16
23 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
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
How I Continuously Learn About SQL Server
Watch this week's video 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 of a...
2019-07-16
12 reads
How I Continuously Learn About SQL Server
Watch this week's video 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 of a...
2019-07-16
7 reads
Azure Service Logging in the Modern Data Warehouse
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-07-16
22 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