Azure Cosmos DB

Technical Article

Introduction to Continuation tokens in Azure CosmosDB

  • DatabaseWeekly

To understand what Continuation does in Azure CosmosDB, Let's look at how SQL Server handles query results first and try to compare SQL Server to CosmosDB. If you will run the following select statement in SQL Server. You will end up with all the data Orders table has. If there are 1 million rows, SQL Server will try to deliver 1 million rows to you like a warrior.

You rated this post out of 5. Change rating

2019-04-26

Technical Article

Why Partitioning is very important in Azure CosmosDB

  • DatabaseWeekly

In any Introduction level CosmosDB talk, Presenter will suggest you pay more attention to the Partitioning part of the talk. Microsoft wants you to create great solution by using Azure CosmosDB and there are a lot of resources out there for developers. The challenge in Azure CosmosDB is, you don't need a DBA in CosmosDB and developers may not pay attention to details like Partitioning when they create databases in Azure CosmosDB.

You rated this post out of 5. Change rating

2019-04-12

External Article

Introduction to Azure Cosmos DB Global Distribution

  • Article

Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.

2018-07-31

3,325 reads

External Article

Introduction to Azure Cosmos DB Emulator for Creating Applications

  • Article

Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure.

2018-07-26

3,673 reads

External Article

Controlling Access to Azure Cosmos DB

  • Article

Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.

2018-04-04

2,223 reads

External Article

Azure Cosmos DB Partitioning

  • Article

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.

2018-03-08

2,357 reads

Blogs

Announcements from the Microsoft Fabric Community Conference

By

A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...

T-SQL Tuesday #185: Video

By

This month’s invite is from Erik Darling, who invites you to make a video...

T-SQL Tuesday #185–Being a Video Star

By

This month we have an interesting invite. Erik Darling is the host, and since...

Read the latest Blogs

Forums

SSIS XML Source Columns Don't Match XML/XSD

By s15199d

In my SSIS package I have a Data Flow with a XML Source with...

Get days between 2 dates excluding weekends.

By bswhipp

Hello all. Trying to measure the time in days between to dates excluding weekends....

Running DML on a Primary AG Instance

By SteveOC

Kind of a DML question - but specific to an AG instance running on...

Visit the forum

Question of the Day

The Long String

I have a table (dbo.beer) with this data:

BeerIDBeerNamebrewerbeerdescription
-------------------------------------------------------------------------------------------------------------------------------------
1BecksInterbrewBeck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law
2Fat TireNew BelgiumToasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced.
3Mac n JacksMac & Jack's BreweryThis beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste.
4Alaskan AmberAlaskan BrewingAlaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste.
8KirinKirin BrewingKirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor.
Here is the DDL For the table:
CREATE TABLE [dbo].[Beer]
(
[BeerID] [int] NOT NULL IDENTITY(1, 1),
[BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
I run this code:
SET TEXTSIZE 20;
SELECT
  b2.BeerName
, b2.beerdescription
FROM dbo.Beer AS b2;
GO
What is returned?  

See possible answers