1. Trace
  2. Report execution time
  3. Indentation
  4. sprockit.handler
  5. SQL Server Backup and Restore
  6. sprockit.Handler
  7. Saving changes to tables
  8. Get column metadata
  9. Calculating age in SQL
  10. crib
  11. Cosmos DB cribsheet

crib cosmosdb

Cosmos DB cribsheet

crib, cosmosdb

This is a personal cribsheet intended for my own use. If it's useful to you, great, but it doesn't cover the subject exhaustively.

Objects

https://docs.microsoft.com/en-us/azure/cosmos-db/account-databases-containers-items

  • Cosmos DB Account (⇐ 50/subscription)
    • Database
      • Container (collection/table/graph)
        • Item (document/row/node,edge)

Count items in container

SELECT VALUE COUNT(1) FROM c
Sidebar

Find me

  • Email
  • LinkedIn
  • Bluesky
  • GitHub
  • RSS feed

Find something else

Recent posts

  • 04-Apr-2025 – com.microsoft.cdm for Synapse Spark v3.4
  • 28-Mar-2025 – Deploy TMDL semantic models to Power BI
  • 03-Mar-2025 – Unreliable logging in data factory pipelines
  • 10-Sep-2024 – Two-aggregate pivot
  • 13-Aug-2024 – DevOps for SQL databases

More...

Top tags

adf adftesting admin azure blog catalog cicd configuration crib csharp dataops development devex devops disk dokuwiki dos dynamic etl excel extended_events fabric functions git google_analytics graphviz housekeeping linked_servers linux metadata php powerbi powershell running setup spark sprockit sprockitviz sql sql_server ssis ssms ssrs synapse tempdb testing tmsl tsql tsqltuesday windows
I use cookies on my website to help me improve the site and your experience here.
Policy