Learn about seven different database paradigms and what they do best.

Contents:

  • 00:00 Intro
  • 00:45 Key-value
  • 01:48 Wide Column
  • 02:47 Document
  • 04:05 Relational
  • 06:21 Graph
  • 07:22 Search Engine
  • 08:27 Multi-model

Data modeling is the process of establishing patterns and rules for how data is stored in database documents and containers and how it is accessed.

You can significantly improve speed and performance of Azure Cosmos DB – especially for your most frequent queries – by choosing the data model that best fits the needs of your application.

In less than two minutes, learn about the key considerations for choosing the right data model, the differences between embedding and referencing data, and how the Azure Cosmos DB change feed can eliminate data duplication.

For more on data modeling, visit:

Gaurav Sen explains NoSQL databases in this introductory video.

NoSQL is a popular database storage method. It keeps data as key value pairs. The advantages and disadvantages of NoSQL compared with RDBMS (which uses SQL) are discussed here, using the Cassandra architecture as an example.

Video index:

  • 1:08 NoSQL explanation and comparison
  • 10:27 Cassandra Architecture
  • 18:00 Quorum
  • 21:30 Compaction of SST tables

Discover ways to troubleshoot and optimize queries in Azure Cosmos DB using the Core (SQL) API. Program Manager Tim Sander demonstrates.

Content Index

  • 0:30 Request Units (database throughput capacity)
  • 3:30 Including necessary paths
  • 8:30 Optimizing ORDER BY queries
  • 11:30 Optimizing JOINs
  • 13:15 Avoiding cross-partition queries

Get started:

In this video, discover the unique capabilities and features of Azure Cosmos DB, a fully managed #NoSQL database system for scalable and real-time applications.

Product Manager Andrew Liu leads a demo of the key features and then shares common use cases and app scenarios. This includes, real-time IoT telemetry, personalized recommendations, how customers use Azure Cosmos DB most often, the top four things you should know before you start, and resources to help you.

Databricks recently streamed this tech chat on SCD, or Slowly Changing Dimensions.

We will discuss a popular online analytics processing (OLAP) fundamental – slowly changing dimensions (SCD) – specifically Type-2.

As we have discussed in various other Delta Lake tech talks, the reliability brought to data lakes by Delta Lake has brought a resurgence of many of the data warehousing fundamentals such as Change Data Capture in data lakes.

Type 2 SCD within data warehousing allows you to keep track of both the history and current data over time. We will discuss how to apply these concepts to your data lake within the context of the market segmentation of a climbing eCommerce site.

 

In this video from Microsoft Developer, learn anout Accelerated Database Recovery, and how it can solve many availability challenges with no operational or application changes.

Find out more about ADR here: https://docs.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-concepts?view=sql-server-ver15?WT.mc_id=dataexposed-c9-niner

[00:00] – Introduction
[00:40] – What is Accelerated Database Recovery (ADR)
[01:36] – The current SQL Server Database Recovery process
[03:00] – Database Recovery process with ADR
[04:58] – Benefits of ADR
[06:00] – Enabling ADR
[07:02] – Truncating transaction log strategy with ADR
[07:44] – Summary and wrap-up

Learn more about the deployment options for Azure SQL Database. 

More information.

[00:00] – Introduction
[00:41] – Deployment options in Azure SQL Database, including elastic pool, single database and Managed Instance
[03:33] – DTU service tiers (Basic, Standard, Premium)
[07:08] – vCore service tiers (General Purpose, Hyperscale, Business Critical)
[08:08] – General Purpose tier: Provisioned vs Serverless
[09:16] – Compute Generation: Gen4 vs Gen5
[10:01] – Decision points for Provisioned vs Serverless compute tiers
[13:25] – Saving money with Azure Hybrid Use Benefits
[13:58] – Business Critical tier and read scale-out
[15:42] – Hyperscale tier
[21:03] – Summary of deployment options
[22:17] – Finalizing the creation of a new Azure SQL Database
[23:02] – Summary and wrap-up