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,231 reads
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
1,231 reads
This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.
2024-06-10
1,298 reads
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,092 reads
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
Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
2023-11-29
Coding for the new NoSQL JSON database service that supports SQL queries.
2023-11-22
Deploy resources in Azure using reusable code with Terraform modules.
2026-02-16 (first published: 2022-10-10)
12,923 reads
CosmosDB is a flexible, powerful database, but is it the best one? Steve has a few thoughts.
2022-03-21
229 reads
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
444 reads
2022-01-21
324 reads
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers