SQL

sql server setup commands

sudo systemctl stop mssql-server
   42  sudo /opt/mssql/bin/mssql-conf set-sa-password
   43  sudo systemctl start mssql-server
   44  ls
   45  sudo mssql -u sa 
   46  sqlcmd /S  /d -U -P 
   47  sqlcmd
   48  systemctl status mssql-server --no-pager
   49  clear
   50  sudo apt-get update 
   51  sudo apt install curl 
   52  curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
   53  curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
   54  sudo apt-get update 
   55  sudo apt-get install mssql-tools unixodbc-dev
   56  clear
   57  sqlcmd -S localhost -U SA -P 'cummings@2021'
   58  sudo apt-get update 
   59  sudo apt-get install mssql-tools 
   60  echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
   61  echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
   62  source ~/.bashrc
   63  sqlcmd -S localhost -U SA -P 'cummings@2021'
   64  clear
   65  ls
   66  sqlcmd -S localhost -U SA -P 'cummings@2021'
   67  history