Skip to content

Instantly share code, notes, and snippets.

View kolosovpetro's full-sized avatar

Petro Kolosov kolosovpetro

View GitHub Profile
@kolosovpetro
kolosovpetro / WinSoftware.ps1
Last active September 13, 2023 12:35
Windows software list using Chocolatey
# Install Chocolatey
Set-ExecutionPolicy Bypass -Scope Process -Force;
Invoke-Expression ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'));
# Upgrade Chocolatey
choco upgrade chocolatey
# List outdated packages
@kolosovpetro
kolosovpetro / win_restore.ps1
Last active October 11, 2023 16:35
To restore windows
sfc /scannow
chkdsk C: /f /r /x
chkdsk D: /f /r /x
DISM /Online /Cleanup-Image /CheckHealth
DISM /Online /Cleanup-Image /ScanHealth
DISM /Online /Cleanup-Image /RestoreHealth
DISM /Online /Cleanup-Image /RestoreHealth /Source:F:\Sources\install.wim
@kolosovpetro
kolosovpetro / Terraform_commands.md
Created August 20, 2023 14:25
Terraform commands

Terraform commands

  • Init examples:
    • terraform init -backend-config="azure.sas.conf"
    • terraform init -backend-config="azure.sas.conf" -reconfigure
  • Plan examples
    • terraform plan -var "prefix=${prefix}" -out "main.tfplan"
    • terraform plan -var "prefix=${prefix}" -var "sql_admin_password=$env:MANGO_TF_SQL_PASS" -out "main.tfplan"
    • terraform plan -var "prefix=${prefix}" -var "os_profile_admin_password=1wSWB2Mbl8918kFvtwac" -out "main.tfplan"
  • terraform plan -var-file='terraform.dev.tfvars' -var sql_admin_username='razumovsky_r' -var sql_admin_password='Zd2yqLgyV4uHVC0eTPiH' -out 'main.tfplan'
@kolosovpetro
kolosovpetro / id_rsa.pub
Created June 6, 2023 20:12
MY_PUBLIC_KEY
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDPj/qzriQWtt5OWALjr1Jg+V3xcehsuTE0cVc7IKYFKUjXsjfe6k7Z8MKT74Pz1eG+Ie96SD+LXd+MjhJtitUz6Uye/RkPNnthoADDUUmfWSnyoLWtwAhk/BmxekSCfCqWXGrB0Hm4+GfbBY7kXWsJKET5KRjWIK5TKk+AhN+3n4W/R/6uTIn0jtQ9cndxTg0Wz5elWk6EO35nhL6NMyVEj9lXUA0R+P20UBTCZEDkjRXyYfJoTVjzfupjhM3Zb/pSoD0EgTExRLs36bCwG0M9vRwVWz7HT1t6JznUvHD6EF2XNpe5gz5niXg9QPz2ls5U5QSF5GquIOEYtO2k9fH7 pkolosov@DESKTOP-74EAN6J
trigger:
batch: true
branches:
include:
- master
paths:
include:
- '*'
#trigger: none
@kolosovpetro
kolosovpetro / install-AzCopy.sh
Created May 21, 2023 11:20 — forked from aessing/install-AzCopy.sh
Install AzCopy on Linux
#!/bin/bash
# =============================================================================
# Install AzCopy on Linux
# https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-v10
# https://github.com/Azure/azure-storage-azcopy
# -----------------------------------------------------------------------------
# Developer.......: Andre Essing (https://www.andre-essing.de/)
# (https://github.com/aessing)
# (https://twitter.com/aessing)
# (https://www.linkedin.com/in/aessing/)
name: GitHub Pages Deploy
on:
push:
branches:
- github-pages
jobs:
build:
runs-on: ubuntu-latest
strategy:
@kolosovpetro
kolosovpetro / Connection_strings.md
Last active August 20, 2023 14:15
Database connection strings

MS SQL local

  • "Data Source=DESKTOP-RN0NICT;Initial Catalog=MoviesCodeFirst;Integrated Security=true;"
  • "Data Source=DESKTOP-CK5PEBD;Initial Catalog=MANGO_DEV;Integrated Security=true;TrustServerCertificate=True;"

MS SQL Docker

  • Server=localhost,1433;Database=MANGO_DEV;User Id=sa;Password=x2yiJt!Fs;TrustServerCertificate=true;

MS SQL Azure

  • Server=tcp:database_name.database.windows.net,1433;Initial Catalog=mango-dev-serverless;Persist Security Info=False;User ID={user_name};Password={pass};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
@kolosovpetro
kolosovpetro / .gitattributes
Last active March 26, 2023 11:43
.gitattributes
* text=auto eol=lf
*.html linguist-detectable=false
*.cshtml linguist-detectable=false
*.htm linguist-detectable=false
*.razor linguist-detectable=false
@kolosovpetro
kolosovpetro / .gitignore
Last active December 17, 2022 20:31
.gitignore
# User-specific files
*.rsuser
*.suo
*.user
*.userosscache
*.sln.docstates
# terraform
*.lock.hcl
*.tfplan