Microsoft added several features to SQL Server 2019 that can improve performance without changes to code.

One of these is T-SQL Scalar UDF Inlining.

The use of UDFs is a red flag when tuning queries, but, in some cases, the engine will treat these as if the underlining code was added directly to the select statement.

Tune in to this session with Kathi Kellenberger to see when this new feature will help, and, more importantly, when it won’t.

Content index:

  • 0:00 Introduction
  • 1:10 What are UDFs?
  • 1:47 Performance Issues
  • 2:30 UDF Scalar Inlining
  • 3:15 Demos
  • 11:40 Control when inling is used

Jimmy Campbell is back to show Scott Hanselman how to use App Configuration for feature management.

Traditionally, shipping a new application feature requires a complete redeployment of the application itself, and testing a feature often requires multiple deployments of the application. Now you can use feature flags in App Configuration to grant early access to new app functionality in production.

Index:

  • [0:00:00]- Introduction
  • [0:00:24]- Episode start
  • [0:03:47]- Demo: Simple feature flags
  • [0:06:56]- Exploring the code
  • [0:12:26]- Demo: Conditional processing with feature filters
  • [0:19:35]- Episode wrap-up

Related Links:

ANSYS is a leader in simulation world.

ANSYS Twin Builder and Microsoft Azure Digital Twins teams came together to integrate physics-based simulations with IoT Data. In this video, Olivier and Sameer Kher (Senior Director at Ansys) discuss the benefits of this joint solution.

The ANSYS Twin Builder combines the power of physics-based simulations and analytics-driven digital twins to provide real-time data transfer, reusable components, ultrafast modeling, and other tools that enable teams to perform “what-if” analyses, and build, validate, and deploy complex systems more easily.

Parallel run in Azure Machine Learning enables big data processing in distributed manner.

In this video, learn more about Azure Machine Learning dataset; how it can help manage your data in machine learning workflow; and how to use dataset in parallel run to accelerate your big data processing.

Learn More:

POWERful Devs showcase how developers can leverage the Power Platform to build applications faster and with far less effort.

Connect with industry-recognized ProDev influencers, Microsoft Cloud Advocates, trusted and diverse community leaders, and members of the Power Platform Team.

Azure Time Series Insights Gen2 is now GA.

In this video, learn how customers can create an Industrial IoT analytics platform using Azure Time Series Insights (TSI)

Learn more at https://aka.ms/iotshow/timeseriesinsightsAzure Time Series Insights Gen2 is now GA. In this episode we look at how customers can create an Industrial IoT analytics platform using Azure Time Series Insights (TSI)

Learn more at https://aka.ms/iotshow/timeseriesinsights

Insight has developed a Detection & Prevention solution to improve health and safety in businesses and public spaces. Utilizing video, IoT Edge and Azure, this solution enables organizations to detect conditions indicative of contagious disease and help to assure social distancing practices are in place.

Learn more at https://aka.ms/iotshow/InsightConnectedPlatform

And if you want to dive into Ben’s guidance for IoT Edge development, check out his blog post:
https://www.linkedin.com/pulse/azure-iot-edge-development-strategies-ben-kotvis .