Azure SQL Containers

As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure.

I’ll cover the following different options for running Docker in Azure:

    • The Azure Container Registry
    • Azure Container Instances
    • Azure Container Services

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker (Docker for Windows) and want to know the different options that are available in Azure.

Each topic will be backed up with live demos which will show how simple it is to get up and running with these technologies.

SQL Server & Containers

There’s a lot of buzz about containers in tech at the moment and this technology has benefits that the SQL Server community simply shouldn’t be ignoring.

This demo based session will provide an introduction to SQL Server containers, explore the various options when running containers, and give a real-world example of implementing containers in a development environment.

Attendees will be taken through the following: –

    • The definition of containers
    • Virtual Machines vs Containers
    • Pulling SQL images from the docker repository
    • Running SQL Server containers
    • Creating custom container images
    • Persisting data in containers
    • A real world implementation of containers

An Introduction to Partitioning

Partitioning has been available in SQL Server since 2005 but there can be a lot of misconceptions around it. This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.

Session covers the following:-

    • Partitioning definition
    • Overview of partitioning functions & schemes
    • Considerations for selecting a partitioning column
    • Creating a partitioned table
    • Indexing considerations
    • Manually switching a partition
    • Manually merging a partition
    • Manually splitting a partition
    • Implementing sliding windows
    • Filegroup restores