Wednesday, 2:45 PM — 3:05 PM PDT — Forecasting Demand in the e-Commerce Space
This is the first time I’m giving a public presentation explicitly related to what my company does. Typically, I present on tangential things: database administration, data science, security. But here, it’s front-and-center. This made it an interesting challenge to provide useful information without laying out any proprietary company information
What: SQL Saturday Brisbane. Where: Internet Australia. You have to turn your monitor upside-down to see it correctly. When: Saturday, May 30th. Admission is free. Register on the SQL Saturday website.
Please note that all of the times are in Australian Eastern Standard Time (AEST). This is UTC+10, so if you’re on the Eastern Daylight Time zone like me (UTC-4), that’s 14 hours ahead. In other words, I present on Friday starting at 10:15 PM EDT.
I’m presenting a full-day training at PASS Summit again this year. Here are the details:
SQL Server on the Edge: IoT with SQL Server and .NET Core
In this day-long training session, you will learn about Azure SQL Database Edge, the version of SQL Server intended to run on Internet of Things (IoT) devices. We will discuss the types of scenarios we might try to solve using IoT devices. From there, we will learn about device management through the Azure IoT Hub, including installation of applications from the Azure marketplace, as well as the development and deployment of custom Docker containers in an Azure Container Registry. Over the course of the day, we will build out a practical scenario and take a look at features in Azure SQL Database Edge, including handling time series data and machine learning on edge devices. As we expand out from a single device, we will learn how to automate deployment and updates at scale using capabilities in Azure IoT Hub.
Prerequisites: A solid knowledge of T-SQL, a basic understanding of Docker and containers, some knowledge of .NET (C# or F#).
What Can You Expect?
I’m still working out all of the details, but here are the top-level items:
Module 0 — Prep Work
In the first module, we will understand why we might want to care about the Internet of Things, looking at the types of scenarios IoT can solve.
Module 1 — Configuring Azure IoT Edge Devices
In this module, we will set up Azure IoT hub, take a look at the Raspberry Pi 4, and install Azure IoT Edge on the Pi. We will also see how to connect a virtual machine to Azure IoT Hub to assist with testing.
Module 2 — Azure SQL Database Edge Installation
Once we have a device in Azure IoT Hub, we will see how to install Azure SQL Database Edge, including configuration and deployment of dacpacs on a VM and on a Raspberry Pi 4.
Module 3 — Developing and Deploying an Application
With a database in place, we will work on an IoT solution in .NET Core and connect to our Azure SQL Database Edge instance.
Module 4 — Diving into Time Series
One of the main promises of Azure SQL Database Edge is the support for time series, and we will investigate what is available on that front.
Module 5 — Machine Learning on the Edge
In this module, we will review ONNX, the Open Neural Network Exchange. We will see how to train a model on a host, deploy it to Azure SQL Database Edge, and predict using the native PREDICT operator.
Module 6 — Device Management
The final module will extend us beyond a single device, as scale is the name of the game with IoT. We will also look at tools available for monitoring and providing insights.
Upon completion of this course, attendees will be able to:
Configure an Azure IoT Hub
Connect IoT edge devices (such as the Raspberry Pi) to Azure IoT Hub
Deploy Azure SQL Database Edge to edge devices en masse
Develop and deploy custom .NET code using containers
This is the first ever virtual SQL Saturday, so I’m glad I could take part in it. Although it’d be nicer if I could be in Richmond and present in person, I’m happy to have the opportunity at least to present from afar.
If your user group needs a remote speaker, especially over the next couple of months, I’d be happy to step in. Check out my list of presentations. If that didn’t scare you off and you still want to get ahold of me, hit me up on Twitter, LinkedIn, e-mail (if you know the address), or put your contact details in a trap cleverly designed to look like a SQL Saturday.
Or Just Watch Our Group
Also, if you are a user group attendee jonesing for a bit more content and missing your user group over the next couple of months, come check out the Triangle SQL Server User Group. We’re going to be remote-only through April, but we meet three times a month and broadcast nearly all of our user group meetings on Twitch. You don’t need an account to watch, but if you want to follow and chat, registration there is free.
What: SQL Saturday South Florida, BI Edition. Where: Microsoft FLL, 6750 N Andrews Ave, Suite #400, Fort Lauderdale, Florida, 33309 When: Saturday, February 22nd. Admission is free. Register on the SQL Saturday website.
What: SQL Saturday Austin, BI Edition. Where: East Williamson County Higher Education Center, 1600 Innovation Blvd, Hutto TX When: Saturday, February 8th. Admission is free. Register on the SQL Saturday website.
What: SQL Saturday Cleveland. Where: Strosacker Hall, Baldwin Wallace University, 130 E Grand St, Berea, Ohio, 44017 When: Saturday, February 1st. Admission is free. Register on the SQL Saturday website.