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,028 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
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
542 reads
CosmosDB is a flexible, powerful database, but is it the best one? Steve has a few thoughts.
2022-03-21
226 reads
In this article, we will explore the HTAP capabilities of Cosmos DB. The goal is to derive real-time insights from transactional changes made to Cosmos DB, in a cost-effective manner with minimal overhead. I want the solution to be scalable, reliable and overall simple to maintain.
2021-11-03
2,237 reads
Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.
2019-05-21
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,781 reads
The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.
2018-02-09
2,650 reads
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Hello, I am working with a company on their database administration. I am trying...
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers