azure database – Frank's World of Data Science & AI

Frank La Vigne
@tableteer
Inquiries franksworldtv@gmail.com

CosmosDB
Closed
34 sec read

How to Troubleshoot Queries in Azure Cosmos DB

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:

Documentation – https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-getting-started
Hands-on lab – https://github.com/AzureCosmosDB/labs/blob/master/dotnet/labs/03-querying_in_azure_cosmosdb.md

SQL Server
Closed
36 sec read

Best Options for Database Migration using Azure Migrate

Microsoft Mechanics has SQL Server guru and recent Data Driven guest, Bob Ward on to talk about Azure Migrate.

Running SQL Server on-premises and looking to move to Azure? Review your best options for assessment and migration. Bob Ward, SQL Server database expert and engineering lead, joins host Jeremy Chapman to walk through different migration options for moving your SQL Databases into the cloud, and then shows how to perform a migration end-to-end.