StockAnalyser NodeJS: Connecting to an Existing MSSQL database (1)

Important:
This blog shows my learning curve in different programming languages. Take my code with a large grain of salt.

The NodeJS script shall connect to an existing MS SQL database. This blog post summarizes some of the initial investigations to make this happen.

The connection string is:

The different components of the connection string are:

• Integrated Security means that I am not using a username/password.
• AttachDbFileName points to the file on the file system
• Data Source refers to the MS SQL Server instance.

First step is to find and control the SQL Server software. Sometimes, it comes with the installation of Microsoft Visual studio. The software SQL Server Data Tools isn't included in my MSVC installation  (2017) and I need to add it using the MSVC installer.

The settings for my local database

Normally, the SQL Server Data Tools provides the server to other applications. For some reason I don't have it so I will install MS SQL Server on top of MSVC in the next blog post.

Railroads: Four Tracks, Soon Near My Backyard

I've been busy with our future home in Åkarp, and therefore the blog has been quiet for a couple of weeks.

From April on, I'll be able to follow a very interesting railroad project closely. The Swedish Southern Main Line (Södra Stambanan) will be expanded from two to four tracks between Arlöv (5 km North East of Malmö) and one km south of Lund. The existing commuter stations Burlöv, Åkarp and Hjärup will be rebuilt, and Lund will get its fourth station, Klostergården (south of Lund C).

The first step is to build two temporary tracks, parallel to the existing tracks. After that, the old tracks are removed and the embankment is lowered six meters. Four tracks are added and finally, the temporary tracks are removed:

Initially, there are two old tracks on the ground level

Two temporary tracks are added next to the old tracks

A six meter deep trench for new tracks is built where the two old tracks were.

Four hundred meters of the tracks are covered in Åkarp.
A public park is planned to be put on top of the tunnel.. 

The temporary tracks are removed, and the bottleneck is resolved.

I'll explore this project further in future blog posts.

I'll write about this project alongside with my personal pet projects.