A Windows Service is a program that starts up and runs when Windows Starts, and then it continues to run until Windows is turned off, or, until you stop the service.

NPM is a DOS command, I think released by the NODE group. I think it’s an installation tool for programmers. I use it to install programs on my computer.

For example I was looking for a typescript definition file for google analytics. I found this website: https://www.npmjs.com/package/@types/google.analytics. It gave me an npm command to install it. it went something like this:

1
2

cd \d\dev\node_modules
npm install --save typescriptdefs/google.analytics

what it did was created a folder named
\d\dev\node_modules\google.analytics
and placed the files I needed.

npm –version

This gives you the version of npm you are running.

SQL Server includes a programming language. That language supports the use of functions. You can create functions, or you can use functions built into SQL.

This article summarizes some of the built in functions.

Sometimes you want to concatinate data from multiple records into one field. For example a list of states could be

1
2
3
4

Alabama
Alaska
Arizona
:

or it could be

1

Alabama,Alaska,Arizona...

This second output is an example of concatenation

SQL Select statement

select UserName 
from employees 

for xml path(‘’)

appears to be a concatination mechanism, or a way to change the output to an XML block

select UserName 

                
            
        
        
            

MxLoader is a program developed by IBM and Bruno Portaluri that is used to import or export data to/from maximo into a spreadsheet.

In fact it is delivered as a spreadsheet with an add-in tab.

Micrsoft recommends you use the Path class, when you are playing with directories. The path class has a number of functions, here is a survey of a few:

The StringBuilder object is used to construct strings. It’s supposedly faster than contactinatng strings.

I’m a bit old fashioned of a programmer. I like Visual Basic, and I like sending stuff to a console. The language itself sort of supports this. There are debug.writeline, trace.writeline and a console.Writeline functions. I could write a console application which pushes stuff to the screen.

Windows comes with a built in Event Viewer. You can post information to the Event Viewer as an alternative to posting to logs. here are my notes