Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. [00:30] Introduction Denzil Ribeiro[01:40] Memory Grants Overview [02:49] Demo[13:05] Getting Started Resources:Performance impact of memory grants on data loads into Columnstore tables

Using Query Store Hints to Optimize Memory Grants, Improving Performance | Data Exposed

Channel 9 is a community. We bring forward the people behind our products and connect them with those who use them. We think there is a great future in software and we're excited about it. We want the community to participate in the ongoing conversation. This is the heart of Channel 9. We talk about our work but listen to the customer.

Technology

Tech News

Podcasting

Gadgets

Software How-To

Azure's best-kept secret is now a part of Synapse! Watch this episode of Data Exposed with Henning Rauch to learn how telemetry data can be analyzed using Azure Synapse Data Explorer. It comes with an amazing real-world IoT scenario. [01:04] Azure Synapse Data Explorer[01:26] Key pillars of Azure Synapse Data Explorer[02:02] Scenarios[03:12] The solution[04:31] Demo[08:23] HighlightsResources:IoT analytics with Azure Data ExplorerAzure Synapse Data Explorer documentationAzure Synapse Data Explorer preview announcement blog

Azure Synapse Data Explorer for Log & Telemetry Management | Data Exposed

OData (Open Data Protocol) can be considered an extension to REST that that defines an additional set of conventions  for building and consuming Web APIs. In this episode, Hassan Habib joins Jeremy to show us how we can easily add support for OData batch to our Web APIs [00:00] - Introduction[01:28] - What is OData?[03:20] - What is OData Batching?[09:07] - Setting up OData in an ASP.NET Core project[20:54] - Adding batching support in OData Useful Links All in One with OData $Batchhttps://www.odata.org/ASP.NET Core OData on GitHubSupercharging your Web APIs with OData and ASP.NET Core

OData Batching with ASP.NET Core | On .NET

Justin Yoo joins Scott Hanselman to demonstrate an extension he developed for adding OpenAPI capabilities to Azure Functions apps. See how easy it is to get HTTP-triggered .NET functions with OpenAPI support and deploy an Azure Functions app with Azure API Management from Visual Studio. ═══════════════ Watch the episode to the end and then submit your answers to our five-question quiz about the info Scott and Justin covered. Eligible participants who answer all five questions correctly will be entered into a Sweepstakes with a chance to be one of ten lucky winners to win a box of Microsoft swag! The Azure Friday Quiz Sweepstakes ends on Dec 10, 2021. Take the quiz! Terms and conditions Privacy statement═══════════════ [0:00:00]– Intro[0:03:15]– Create[0:09:20]– Publish[0:12:56]– Consume[0:22:48]– Wrap-up Create serverless APIs in Visual Studio using Azure Functions and API Management integration (preview)Azure Functions OpenAPI ExtensionCreate a free account (Azure)

Deploy OpenAPI enabled Azure Functions with .NET in Visual Studio | Azure Friday

Mike Rousos is back again! This time Mike shows us how to inspect and diagnose large Object Heap churn in .NET [00:00] - Introduction[01:36] - What tools can we use to look into performance?[03:35] - Diagnostics Demo in Azure App Service[08:50] - Collecting diagnostic traces using dotnet trace[12:56] - Reviewing stats in Perfview[19:56] - Inspecting GC Heap allocations[22:16] - Reducing allocations ArrayPool     dotnet-trace performance analysis utilityWhat is Application Insights?Analyze CPU usage without debugging in the Performance ProfilerKudu service overview

Large Object Heap Churn in .NET | On .NET

Jason Zander, executive vice president of the Azure Team joins Scott Hanselman to celebrate the 8th anniversary of Azure Friday. In this special crossover episode with Hanselminutes, they reflect on Azure's history and Jason's career at Microsoft during that timeframe. [0:00:00]– Introduction[0:01:13]– Jason's history at Microsoft[0:08:25]– Microsoft's evolution[0:10:44]– Cloud before the cloud [0:19:38]– Developers as execs[0:23:03]– Azure today[0:25:25]– Looking forward[0:30:33]– Wrap-up Hanselminutes Podcast 63 - Scott Guthrie and Jason Zander on SilverlightNew Team, New Challenges (Jason Zander's blog)Getting Started with Windows Azure, the SDK, and Visual StudioMicrosoft QuantumCreate a free account (Azure)

Using Query Store Hints to Optimize Memory Grants, Improving Performance | Data Exposed

Download our free app to listen on your phone