My Blog

When you want to create a new table in a Database B and fill it with the rows of another table in Database A, then you can use the SELECT … INTO format like in the following query:

Running an MSSQL Database inside a Linux Docker Container can be done for many reasons. You might want to host your dockerize your whole web application or even the DB part of it. When using such a Container you want to have an easy way to see the content of the Database. For that we can use the SQL Server Management Studio tool.

Lately I was setting up a web application inside a Docker. container which communicates via ODBC with a database. In order to be able to query the database, I had to add the name of the database and the credentials into the odbc.ini and odbcinst.ini files. My queries were failing with the following message: “ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified”

When using web applications inside a Docker Container you might come across SSL certificates that have to be installed on the running Container. Things get a little bit more complicated when you want to install Windows certificates into a Linux Image. Following you can see the steps to achieve this task.

The following list is a reference to the Git commands I use the most. Beneath every command there is an explanation of its use.

As of September 2024, I updated the list with more helpful Git commands.