vkhazin

sudo apt-get update &&
sudo apt-get install default-jre -y &&
curl https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo apt-key add - &&
echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" \
| sudo tee -a /etc/apt/sources.list.d/elastic-7.x.list &&
sudo apt-get update && 
sudo apt-get install elasticsearch &&
sudo systemctl start elasticsearch

vkhazin

sudo apt-get update && sudo apt-get install apt-transport-https -y &&
sudo apt-get install default-jre -y &&
curl https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo apt-key add - &&
echo "deb https://artifacts.elastic.co/packages/6.x/apt stable main" \
| sudo tee -a /etc/apt/sources.list.d/elastic-6.x.list &&
sudo apt-get update && sudo apt-get install elasticsearch &&
sudo systemctl enable elasticsearch.service &&
sudo service elasticsearch start

vkhazin

$webclient=New-Object System.Net.WebClient
$creds=Get-Credential
$webclient.Proxy.Credentials=$creds

vkhazin

sudo systemctl enable elasticsearch.service
sudo systemctl enable logstash.service
sudo systemctl enable kibana.service

vkhazin

# To get list of available features, run from PowerShell: Get-WindowsFeature

# To install IIS:
Install-WindowsFeature -name Web-Server -IncludeManagementTools
Install-WindowsFeature -name Web-Dyn-Compression

# To enable classic ASP:
Install-WindowsFeature -name Web-ASP

vkhazin

# NginX reverse proxy for jenkins: https://gist.github.com/rdegges/913102
FQDN="ec2-18-222-184-237.us-east-2.compute.amazonaws.com"

sudo apt install nginx -y
sudo rm /etc/nginx/sites-enabled/default

CONFIG="upstream kibana {
  server $FQDN:5601 fail_timeout=0;
}

vkhazin

--https://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

vkhazin

USE <db name>
CREATE LOGIN <login name> WITH PASSWORD = '<password>'
create user <login name> for login <login name>
exec sp_addrolemember 'db_owner', '<db name>'

vkhazin

# Installing dependencies locally using terminal
```pip install module-name -t ./python_modules```

# Referencing locall dependencies in python module:
```
import sys
sys.path.insert(0, "./python_modules")
```

vkhazin

# Installing Java
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer -y

# Downloading
username='[email protected]'
curl -O -u $username 'https://downloads.datastax.com/enterprise/DataStaxEnterprise-4.8.9-linux-x64-installer.run'

# Installing