All About SQL

Blog Post

Snowflake + Azure blob

Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...

2024-10-18 (first published: )

154 reads

Blog Post

Blockchain + RWAs

Blockchain technology is still at the hype stage for an emerging technology cycle, it gets a bad image from all the dodgy web3 “crypto” fake projects out there (based...

2024-09-05

11 reads

Blog Post

WHAT IS A SPV?

Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...

2024-08-09

16 reads

Blog Post

Tech in 2030

What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...

2024-08-09 (first published: )

116 reads

Blog Post

Azure SQL MI License free?

A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...

2024-03-11 (first published: )

428 reads

Blog Post

Azure chaos STUDIO

Chaos engineering is fun but especially important when building solutions in the cloud. It is great leveraging the cloud to build something, whether that’s a globally distributed website with...

2023-06-28 (first published: )

264 reads

Blogs

AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery

By

In an era where cloud computing drives innovation, understanding its fundamentals is no longer...

Moving to Rancher Desktop

By

I’ve been very happy with Docker Desktop for years, running it on both laptop...

Logging in Azure Data Factory data flows

By

(2025-June-15) Long gone are the days when a data engineer could simply focus on building...

Read the latest Blogs

Forums

SQL - Conditional merge join

By SQL Bee

I want to add a condition in the joining columns part of the merge...

Is there a way to implement ROWS between logic?

By water490

Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...

Tracking changing prices and recalculating inventory value

By pietlinden

I'm trying to figure out a how to do average costing over time in...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers