Zum Hauptinhalt wechseln

SQL Server Hybrid Cloud: 1-day Virtual Workshop

Dynamics Edge

In this instructor-led workshop, you will design a hybrid cloud disaster recovery solution to handle large spikes in load, strengthen security to encrypt PCI data, and implement archival strategies.

This instructor-led virtual workshop details how to implement an end-to-end solution simulating high velocity data emitted from smart meters and analyzed in Azure. Create a lambda architecture, filtering a subset of the telemetry data for real-time visualization on the hot path, and storing the data in long-term storage for the cold path.

What You’ll Learn

  • Implement a simulator sending telemetry from smart meters
  • Capture and process both hot and cold data using Stream Analytics and HDInsight with Spark
  • Visualize hot data with Power BI

Prerequisites

  • Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design
  • We strongly recommend students take a Microsoft Azure Essentials course before enrolling in this workshop

Agenda

Workshop Outline

Module 1: Whiteboard Design – Internet of Things

  • Review the customer case study
  • Call to action: Design a proof of concept solution
  • Call to action: Present the solution

Module 2: Hackathon – Internet of Things

  • Before the hackathon
  • Environment setup
  • IoT Hub provisioning
  • Completing the Smart Meter Simulator
  • Hot path data processing with Stream Analytics
  • Cold path data processing with HDInsight Spark
  • Reporting device outages with IoT Hub Operations

Monitoring

  • Cleanup
https://gallery.azure.com/artifact/20151001/dynamicsedge.de40510-sql-server-hybrid-cloud.1.0.2/Artifacts/SampleImage/ed8cb9f7-6147-4ded-aa88-98e04a8acbdc.png
https://gallery.azure.com/artifact/20151001/dynamicsedge.de40510-sql-server-hybrid-cloud.1.0.2/Artifacts/SampleImage/ed8cb9f7-6147-4ded-aa88-98e04a8acbdc.png