This session is designed for DBAs, Developers and Sysadmins who want to learn about running SQL Server in containers on Windows Server 2016. This session assumes that attendees have a working knowledge of SQL Server and a basic knowledge of Windows Server administration but all concepts will be explained as the session progresses.
Attendees do not need to have any prior knowledge of containers as this session aims to give an introduction into the technology so that the attendees have a base of knowledge on which they can build on.
Attendees will be taken through the following:
- Defining what containers are (benefits and limitations)
- Configuring Windows Server 2016 to run containers
- Installing the docker engine
- Pulling/Pushing SQL images from/to the docker repository
- Running SQL Server containers
- Committing new SQL Server images
- Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
The session will explain concepts via powerpoint slides which will be backed up by demos.
Attendees do not need to bring anything to the session but if they want to follow along they could (emphasize could as they really don’t have to) have a VM running Windows Server 2016 with the containers feature enabled.
Why I Want to Present This Session:
I’ve been working with containers for most of this year and have seen the benefits that they can bring to an organisation. I’ve also seen the downside and am well equipped to talk about the potential pitfalls that are lurking out there.
This is a new technology available to SQL Server Professionals, one that I think hasn’t realised its full potential. I’m excited about where this could lead in the future and how working with SQL Server could change because of it.