Getting Started With Azure Cosmos DB for PostgreSQL
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,225 reads
Azure Cosmos DB
How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,280 reads
Quick and Effective Migration Between CosmosDB Collections Using ADF
This document aims to explain the process of using ADF (Azure data Factory) to make a copy of a Cosmos DB (Instance A) collection into a new collection in another Cosmos DB Instance effectively and cost effectively. For example, here is our Instance A in the Data Explorer: Here is Instance B: We are looking […]
2024-03-25
1,091 reads
Running Azure CosmosDB queries from SQL Server using ODBC driver
Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql.
2023-12-15
Working with Azure DocumentDB: SQL & NoSQL Together
Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
2023-11-29
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
Coding for the new NoSQL JSON database service that supports SQL queries.
2023-11-22
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2026-02-16 (first published: 2022-10-10)
12,875 reads
Is CosmosDB the One?
CosmosDB is a flexible, powerful database, but is it the best one? Steve has a few thoughts.
2022-03-21
229 reads
Backup Architecture
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
2022-02-21
442 reads
2022-01-21
324 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers