vkhazin’s gists

vkhazin / redshift-grant.sql

Created December 7, 2023 18:17

How to grant read-only access to all tables in a AWS Redshift schema

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

vkhazin / CloudWatch Parse LogsInsight

Created September 9, 2022 02:59

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

vkhazin / git-pull-push.sh

Last active September 3, 2022 02:22

	# 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 / bigquery-timestamp-nginx.sql

Created September 1, 2022 19:19

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

vkhazin / cisco-vpn-dns-metrics.ps1

Created April 15, 2022 01:57

Fix DNS resolution for WSL2 using Cisco Vpn

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

vkhazin / purge-cdn.ps1

Last active March 26, 2021 12:15

Azure DevOps purge CDN End-Point

	# 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 / linux-sudo-without-password

Created July 30, 2020 16:02

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

vkhazin / gist:c97c1175ddedb58837eca2760f6c63e5

Created April 10, 2020 15:45

PowerShell restore Sql Server database


	$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 / Install ElasticSearch v7 on Ubuntu 18.04

Created March 24, 2020 13:26

Install ElasticSearch v7 on Ubuntu 18.04

	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 / gist:998b73ddd7301209fc5bc18f5945eb2e

Last active March 28, 2019 13:28

Install ElasticSearch on ubuntu 16.04

	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

Vlad Khazin vkhazin