My Blog

Here you can find my private notes about programming that I wanted to share with you. Feel free to filter based on the topic you want or search for something specific.

    Copy all rows from one table to another new table in MSSQL

    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:

    Read the complete article

    Connect to an MSSQL Database running on a Docker Container

    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.

    Read the complete article

    How to solve the "ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified" error when setting up an ODBC connection

    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”

    Read the complete article

    How to install Windows SSL certificates into your Docker Linux container

    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.

    Read the complete article

    A work-in-progress list of my favorite Git commands

    I was planning to write an article as a reference for the Git commands I use the most. In the following list you see these commands and an explanation for each one of them:

    Read the complete article