var knex = require('knex') (
    {
        client: 'mssql',
        connection: {
            // host : '169.254.194.146',
            host : '127.0.0.1',
            user : 'simadmin',
            password : 'password',
            database : 'AdventureWorks2016'
        },
        pool: {
            min: 0,
            max: 10
        }
    });