vkhazin

grant select on all tables in schema {schema_name} to {db_user};
grant usage on schema {schema_name} to {db_user};

vkhazin

fields @message
| filter @message like 'Carlsberg'
| parse @message '"material":"*"' as material
| filter not isempty(material)
| display material, @message

vkhazin

# Place the file in the root folder of git repos to sync
# Run the script: python3 ./git-pull-push.py source_remote target_remote branch_name

import os
import sys

errors = []

def main():
    source_remote = sys.argv[1]

vkhazin

cast(UNIX_SECONDS(PARSE_TIMESTAMP("%d/%b/%Y:%H:%M:%S %z", time)) as string) as time

vkhazin

 Get-NetAdapter | Where-Object {$_.InterfaceDescription -Match "Cisco AnyConnect"} | Set-NetIPInterface -InterfaceMetric 6000

vkhazin

# https://docs.microsoft.com/en-us/powershell/azure/authenticate-azureps?view=azps-5.6.0#password-based-authentication
# https://docs.microsoft.com/en-us/azure/cdn/cdn-manage-powershell#purgingpre-loading-cdn-assets

param (
    [string]$applicationId,
    [string]$tenantId,
    [string]$accessKey,
    [string]$resourceGroupName,
    [string]$profileName,
    [string]$endpointName,

vkhazin

echo "$USER    ALL=(ALL) NOPASSWD:ALL" | sudo tee --append /etc/sudoers

vkhazin

$AZFileShareURl = "tsqlbackup.file.core.windows.net"
$AZUserName = "Azure\tsqlbackup"
$AZPassword = "7RODyFgfsXx1nML/SfFifKL+ozoCVag89D8B/bCgTbDakqaB7gSVM41BzcF0uvRHugmHRMLYoPyecAzJGPzxrA=="
$BackupFileName = "sqlbackup\DBExport.bak"
$DownloadLocation = "f:\DBExport.bak"
        
$SQLServer = "VM2016"
$BackupFileLocation = "f:\DBExport.bak"
$DatabaseName = "DBTest"

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