Microsoft SQL Server on Docker (part 2) – Use AdventureWorks

sql_on_dockerIn part one of this series, I provided some info on Microsoft’s implementation of Sql Server on Docker and provided a method to have your SQL Server databases saved on your Docker host system so that they would remain persistent if the SQL Server container was shutdown. This time around, we’ll look at how to restore Microsoft’s sample database AdventureWorks to your SQL Server container.

DOWNLOAD ADVENTUREWORKS

If you followed my instructions from part 1 of this article you have a SQL Server container up and running with a data folder on your Docker host. Within that folder, you have several subfolders that SQL Server uses. You need to download a copy of AdventureWorks and save it in that folder. There are multiple versions available, as Microsoft provides a new version with every upgrade to SQL Server. The 2014 version should work fine for this purpose (If you download the 2016CTP version the restore command below will not work because that version includes FILESTREAM as part of the backup. An addition MOVE command needs to be supplied to include that in the RESTORE). Go to this website, and download Adventure Works 2014 Full Database Backup.zip. I renamed the file to just AdventureWorks.zip to make it easier to transfer to my Docker host system and used scp to transfer it: Continue reading

Docker Fun – Play Text Adventures

zorkThis time around in the Docker Fun series, we are getting a little more ambitious. Zork was one of the first popular text adventures, building on the work of Will Crowther and Dan Wells who created the mainframe game Colossal Cave (aka Adventure). Zork was originally written to run on a DEC PDP-10 system, and was later ported to just about every personal computer that was available. While text adventures at that time were struggling with two word commands like “Open Door”, Zork understood much more elaborate command like “Hit the grue with the Elvish sword”. The developers of Zork founded Infocom and eventually released a number of sequels and prequels to Zork as well as several dozen other text adventures in a number of different genres. Eventually the company was sold to Activision and the Infocom games have since lapsed into a sort of purgatory. Technically the download file for Zork is in violation of copyright laws, so feel free to substitute one of the many free Z5 files available on the Internet.

Continue reading

Docker Fun – Star Wars

robotsWelcome to the latest in my series of using Docker in some fun and unusual ways. Previously I covered how to display a Matrix screen similar to the movie and showing a locomotive animation in your Docker session . This time, we’ll look an amazing telnet animation that’s been around for quite awhile (since 1997 according to this website). It shows the entire Star Wars Episode 4 movie using ASCII characters. Continue reading

Docker Fun – Locomotive

trainWelcome to the second in my series of using Docker in some fun and unusual ways. In the first installment, I showed how to display a Matrix screen similar to the movie. This time, we’ll look at showing a steam locomotive engine in motion in a Docker container. I’m not sure where this application originated, but it seems to have started as an Easter Egg in Linux to tweak people who misspell the system command ‘ls’.

Like last month’s this is an easy container to implement, consisting of only a three line Dockerfile.

Continue reading