Tech Tech Tech

Powershell Version:

if (test-path variable:psversiontable) {$psversiontable} else {[version]"1.0.0.0"}

SQL Server Versions:

$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances

foreach ($i in $inst)

{

  $p = (Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL').$i

  (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Edition

  (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Version

import subprocess

for bug:

'property declarations' can only be used in a .ts file.

in settings.json add:

http://stackoverflow.com/questions/20111242/how-to-avoid-errno-12-cannot-allocate-memory-errors-caused-by-using-subprocess

brew update brew install nvm source $(brew --prefix nvm)/nvm.sh

http://exponential.io/blog/2015/02/21/install-postgresql-on-mac-os-x-via-brew/

brew update brew install postgres  postgres -D /usr/local/var/postgres createdb `whoami`  psql 

Optional: Install Admin Pack 

psql postgres -c 'CREATE EXTENSION "adminpack";' 

Optional: Configure PostgreSQL to start automatically

apt-get update -y apt-get install keepalived -y echo " " >> /etc/sysctl.conf echo "# Used for Keepalived" >> /etc/sysctl.confs echo "net.ipv4.ip_nonlocal_bind = 1" >> /etc/sysctl.conf sysctl -p service keepalived restart

And the /etc/keepalived/keepalived.conf for MASTER

global_defs {  lvs_id server-name-01 } vrrp_script haproxy {  script "killall -0 haproxy"  interval 2  weight 2 } vrrp_instance VI_01 {  virtual_router_id 52  priority 101  state MASTER  interface eth0  virtual_ipaddress {    192.168.1.23 dev eth0  }  track_script {    haproxy  } } virtual_server 192.168.1.23 443 {  delay_loop 6  lb_algo lc  lb_kind DC  persistence_timeout 0  protocol TCP  real_server 192.168.1.24 443 {    weight 1    TCP_CHECK {      connect_timeout 3      connect_port 443    }  } } virtual_server 192.168.1.23 80 {  delay_loop 6  lb_algo lc  lb_kind DC  persistence_timeout 0  protocol TCP  real_server 192.168.1.24 80 {    weight 1    TCP_CHECK {      connect_timeout 3      connect_port 80    }  } }

And the /etc/keepalived/keepalived.conf for SLAVE

# Place this file in /etc/init/my-server.conf

start on runlevel [2345] stop on shutdown

respawn respawn limit 10 5

import os import json

CWD = os.path.dirname(os.path.abspath(__file__)) CONFIG_FILE =  CWD + '/config.json'

def main():     with open(CONFIG_FILE) as configFile:          config = json.load(configFile)

      if config:            start(config)       else:            print 'FAIL: Cannot open config'

def start(config):       pass

import socket

class BaseHandler(tornado.web.RequestHandler):     def initialize(self, config=None):         self.config = config

    def get_current_user(self):         return self.get_secure_cookie('secureCookie')

    def set_default_headers(self):         self.set_header("Access-Control-Allow-Origin", "*")

    def options(self, *args, **kwargs):        if "Access-Control-Request-Method" in self.request.headers:            self.set_header("Access-Control-Allow-Methods", self.request.headers["Access-Control-Request-Method"])

import os