SQLGeordie's Blog

Below are a collection of links I’ve used as reference throughout my journey of Docker and running SQL Server containers. These have been invaluable in knowledge gathering and troubleshooting throughout this (at times) painstaking process.

First and foremost I would like to put a huge shout out to Andrew Pruski (b|t) for his Container Series which if you haven’t had a look at then I suggest you do, like now! He has put together some great content for anyone looking to get started with Containers.

I have tried to section them to make things easier to refer to and more than happy for others to suggest others to add:

Getting Started with Docker:

• Docker 101: https://www.slideshare.net/Docker/docker-101-nov-2016?next_slideshow=2Docker 101 – Nov 2016
• https://www.simple-talk.com/sysadmin/virtualization/working-windows-containers-docker-basics/
• Hello World on nanoserver: https://docs.microsoft.com/en-us/virtualization/windowscontainers/quick-start/quick-start-windows-10
• Terminology: http://itproguru.com/expert/2016/10/docker-create-container-change-container-save-as-new-image-and-connect-to-container/

Tutorials

• Docker Container Tutorial #1 Containers vs Images – Focuses on Ubuntu
• Learn Docker in 12 Minutes
• Learn Docker in 20 Minutes
• Jarrin Consultancy YouTube channel (work in progress)

SQL Server on Linux:

• SQLPAL: https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/

Use cases:

• Docker introduction (slide 21)

General:

• https://blog.sixeyed.com/windows-containers-and-docker-5-things-you-need-to-know/

Licensing:

• https://blog.docker.com/2017/01/docker-windows-server-image2docker/

Installing:

• https://mathaywardhill.com/2017/04/12/installing-sql-server-vnext-on-linux-using-docker-on-windows-10/

Setup on Windows 10 VM:

• Nested Virtualisation (for VMs): https://www.youtube.com/watch?v=ycCK1EyJG6Y

SQL Server On Linux:

• https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker
• https://roadtoalm.com/2017/01/06/running-a-linux-sql-server-in-a-docker-container/

Connecting to SQL Server via sqlcmd:

• http://searchsqlserver.techtarget.com/tip/Use-these-commands-to-deploy-SQL-Server-Docker-containers

Legacy SQL Server Containers

• Windocks: https://www.windocks.com/blog-2/Windows-Containers-at-Work
• Windocks: https://dbafromthecold.com/2016/12/07/sql-server-containers-part-four/

Performance

• https://sabin.io/blog/sql-server-container-performance/
• https://facility9.com/2017/01/how-do-i-update-my-sql-server-docker-container/

Issues and Troubleshooting

• Error pushing image (add collaborators):  http://stackoverflow.com/questions/41984399/denied-requested-access-to-the-resource-is-denied-docker/42403423

Using Volumes

• http://paper.li/e-1483951345?read=http%3A%2F%2Fthedatafarm.com%2Fdata-access%2Fmashup-sql-server-on-linux-in-docker-on-a-mac-with-visual-studio-code%2F
• http://www.tricksofthetrades.net/2016/03/14/docker-data-volumes/
• https://www.richard-banks.org/2017/03/connecting-to-sql-on-docker.html

Hyper-V containers

• https://www.simple-talk.com/sysadmin/virtualization/working-windows-containers-docker-stride/?utm_source=simpletalk&utm_medium=pubemail&utm_content=20170512-slota2&utm_term=simpletalkmain
• https://hyper-v.nu/archives/hvredevoort/2015/05/nested-hypervisor-in-windows-server-vnext/
• https://blogs.technet.microsoft.com/uktechnet/2016/01/11/windows-containers-what-they-are-and-how-they-work/
• Windows Server and Docker – The Internals Behind Bringing Docker and Containers to Windows by Taylor Brown and John Starks

Videos

• SQLGeordie – Youtube Video Series