With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (aka CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code.

The CLR is also available in Azure SQL Database Managed Instance.

In this video, Anna Hoffman and Colin Murphy go over what CLR is, how to set it up in Azure SQL Database Managed Instance, and simple example of Regular Expressions in Azure SQL Database Managed Instance.

Azure Maps Mobility Services make the life of an IoT developer easier and they contribute towards a great end user experience.

Watch this episode to see Outi Nyman, Senior Program Manager, Azure Maps, step through the APIs for these services.

Designed to support developers creating smart city applications that move people and things from one place to another, they help create applications that decrease traffic congestion and increase air quality.

The Mobility Service APIs for Azure Maps are brought to life in partnership with Moovit, Inc. Moovit combines information from public transit operators and authorities with live information from its user community to offer a real-time picture of public transit services, including stops, route information, and travel time estimations.

In this fascinating episode, watch how Ofir Barzilay, Principal Engineering Manager for IoT Security, demonstrates a brute force attack (https://aka.ms/iotshow/ascforiot) on a Raspberry Pi IoT device connected to Azure IoT Hub. You will see how Ofir attacks the device to discover its password.

Watch how he downloads a payload and infects the device. You will see him gain control over the device, connecting it to his command and control server to fully own it, showing how he can exploit it for crypto mining, DDOS and more.

At the end of the demo, Ofir demonstrates how Azure Security Center for IoT has monitored, detected, and reported on the entire attack. He also shows how Azure Security Center for IoT leverages Microsoft Threat Intelligence to flag suspicious devices. Solution builders using Azure IoT security will sleep better after watching this show.

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

Learn how VISEO (https://aka.ms/iotshow/viseo) is analyzing large amounts of data (1 GB to 1 TB) collected from drones and other vehicles flying over 32,000 km of railway tracks in France for Altametris, a subsidiary of SNCF Réseau.

VISEO’s Vincent Thavonekham, Head of Smart Factory, and Igor Leontiev, Chief Cloud Solution Architect, show three demos in this amazing episode. Vincent and Igor demonstrate how VISEO processes 42 billion laser dots and other data collected from 450 km of railroad tracks from Paris to Lyon.

Using VISEO’s custom data model and Azure IoT Edge, data at the edge is now prepared for upload to the Cloud in days instead of weeks. From the Cloud, Altametris analyzes the data to track and maintain its railroad assets remotely reducing expenses and increasing safety.

Watch Paul de Carlo, Microsoft Cloud Developer Advocate, step through his Intelligent Edge Hands-on Lab (https://aka.ms/iotshow/intelligentedge — which is open source and available for you to try)

During this lab, Paul deploys an IoT Edge module to an NVIDIA Jetson Nano development board to allow for detection of objects from the live video stream of a Webcam. In this episode, the webcam is scanning the floor at Microsoft Ignite 2019 and detects people, backpacks, chairs and more, in real time.

The same setup can detect objects in YouTube video streams, RTSP streams, or HoloLens Mixed Reality Capture and stream up to 32 videos simultaneously. Object Detection is accomplished using YOLOv3-tiny with Darknet.

Learn why Paul and Olivier are never going to give you up, never going to let you down during this memorable episode.