Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

The Azure SQL Workshop

Description

In this one day, hands-on, scenario-driven workshop, members of the SQL engineering team will help you translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. At the end of the day, you should have a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: security, performance, and availability. You will learn about not only the “what”, but also the “how” and the “why”. You’ll also walk away with resources and tools so you can go as deep as your scenario requires.

 

After the workshop, you should be able to…

  • Determine which Azure SQL deployment option (virtual machines, single databases, serverless databases, elastic pools of databases, hyperscale databases, and managed instances) and service tier should be used for scenarios that meet the needs of your application.
  • Deploy, configure, monitor, and troubleshoot security, performance, and availability scenarios in Azure SQL using both familiar and new tools and techniques.
  • Harness the “power of the cloud” including automation and intelligent capabilities of Azure SQL.
  • Translate your existing SQL Server expertise to Azure SQL expertise.

 

This day will be extremely interactive and the engineering team always provide details on “how it works”. All attendees are required to bring their own laptop which at minimum can connect to a Virtual Machine with a Remote Desktop application. At the end of the day you will walk away with all the materials, code, slides, and demos for future use.


Note: This session will run from 1pm to 7:30pm BST (12:00 to 18:30 UTC) to accomodate the Pacific time zone of the Microsoft speakers

Learning Objectives

Previous Experience

Tech Covered

Deploying, Securing, Cloud, Azure SQL Database, Managed Instance, Database engine, Move to the cloud, Developing, Managing, Monitoring, Optimising