Tim Sander joins Scott Hanselman to discuss composite indexes and correlated subqueries using the SQL API in Azure Cosmos DB.

A Request Unit, or RU, is the measure of throughput in Azure Cosmos DB. Learn how to optimize queries with a composite index to decrease the RUs needed for a given query.

They also showcase correlated subqueries and examples of how they can make it easier to query arrays in Azure Cosmos DB.

              Related Links:

              Anavi Nahar joins Donovan Brown to show how virtual network peering enables you to connect networks seamlessly in Azure Virtual Network.

              The virtual networks appear as one for connectivity purposes.

              The traffic between virtual machines uses the Microsoft backbone infrastructure. Like traffic between virtual machines in the same network, traffic is routed through Microsoft’s private network only.

              Gaurav Malhotra joins Scott Hanselman to show how wrangling data flows in Azure Data Factory.

              This provides  a code-free, serverless environment that simplifies data preparation in the cloud and scales to any data size with no infrastructure management required.

              It uses the industry-leading Power Query data preparation technology (also used in Power Platform dataflows, Excel, and Power BI) to prepare and shape the data. Built to handle all the complexities and scale challenges of big data integration, wrangling data flows enable use Apache Spark execution to help you easily prepare data at scale.

              Container startup time is the price of admission, but startup time is also an inhibitor for many serverless scenarios.

              Steve Lasker joins Lara Rubbelke to show how Project Teleport eliminates the download and decompression of layers by directly mounting expanded layers, potentially unlocking many new scenarios.

              Related Links

              Aman Bhardwaj and Yaron Schneider join Scott Hanselman to talk about the core concepts of Distributed Application Runtime (Dapr).

              Dapr is a portable, event-driven runtime that makes it easy for developers to build resilient, microservice stateless and stateful applications that run on the cloud and edge and embraces the diversity of languages and developer frameworks     

              Dapr Resources

              Sydney Smith joins Scott Hanselman to show the rich editing experience provided by the PowerShell extension in Azure Data Studio by creating a SQL Server in a Linux Docker container with external storage—all using PowerShell Core in Azure Data Studio.

              To get started with the notebook used in the episode check out: PowerShell/vscode-powershell

              [00:01:36] Demo – Getting started – installing modules

              [00:04:45] Demo – Creating a new editor file

              Miao Jiang joins Scott Hanselman to walk through a conceptual framework for building a CI/CD pipeline to automate the deployment of APIs into Azure API Management.

              Learn about common automation challenges with API Management and how the suggested approach addresses these challenges. For a demonstration, see: Build a CI/CD pipeline for API Management, Part 2.

              Related Links:

              When a live site issue or outage occurs, quickly determining the root cause is critical. Standard monitoring solutions might alert you to a problem.

              They might even indicate which component is failing.

              But this alert won’t always immediately explain the failure’s cause. You know your site worked five minutes ago, and now it’s broken.

              What changed in the last five minutes?

              This is the question that Application Change Analysis is designed to answer in Azure Monitor.

                Azure Monitor Related Links

                Ziv Rafalovich joins Donovan Brown to introduce Azure Dedicated Host, which is a service that provides physical servers – able to host one or more virtual machines – dedicated to one Azure subscription.

                Dedicated hosts are the same physical servers used in our data centers, provided as a resource. You can provision dedicated hosts within a region, availability zone, and fault domain. Then, you can place VMs directly into your provisioned hosts, in whatever configuration best meets your needs.     

                Azure Dedicated Host Related Links