Docker with Microsoft SQL 2016 + ASP.NET

Right off the heels of the Microsoft Ignite event in Atlanta the SQL Server team have a great announcement

SQL Server 2016 released on June 1st 2016 is ready for Docker on Windows!

Docker and Microsoft partnered in 2014 and after over two years of hard work they've now brought Windows Server Core to the Windows 10 desktop which means you can run your existing business workloads in containers.

Windows does the Docker Voting app

I've re-written the Docker Voting app which was demonstrated at Dockercon 2016 and used in Docker's birthday contest as a hackathon.

This is what it looks like now:

Every container is running on Windows 10 through Windows Server Core including:

  • IIS
  • ASP.NET
  • .NET 4.5.1
  • Microsoft SQL Server (2016)

I have worked with this stack for over 10 years and over the last few weeks all the pieces are falling into place to allow businesses invested in a Microsoft stack to start taking advantage of Docker and containers. For me, it's really exciting to see the familiar Docker CLI bringing power to the Microsoft development stack.

Get the code:

The code along with Dockerfiles are available on Github: alexellis/aspnet-voteservice

SELECT * FROM DEMO

This is a quick overview of how everything works:

I've also recorded a longer deep-dive, so check back later or subscribe to me on YouTube to get notified when it goes up.

What does this mean?

It's never been easier to evaluate a new version of Microsoft SQL Server. All I did was pull down a container and run it and when I'm done, I can remove it in seconds.

Containers are coming to Windows and they're bringing the power and ease we've grown accustomed to on a Linux platform.

To install Docker on Windows right now check out this post by Michael Friis:

Want the deep dive?

If you want the deep dive then check out the longer edit of the video right here:

See also:

Alex Ellis

Read more posts by this author.

Subscribe to Alex Ellis' Blog

Subscribe to keep in touch. By providing your email, you agree to receive marketing emails from OpenFaaS Ltd

or subscribe via RSS with your favourite RSS reader

Learn Go with my new eBook

eBook cover

"Everyday Go" is the fast way to learn tools, techniques and patterns from real tools used in production based upon my experience of building and running OpenFaaS at scale.

Buy a copy on Gumroad