Skip to content

Instantly share code, notes, and snippets.

@ernestasju
ernestasju / color order.ps1
Last active September 29, 2017 07:44
'Color order' minigame
$Colors = [System.Enum]::GetValues([System.ConsoleColor]) | ? { $_ -notin (
[System.ConsoleColor]::Black,
[System.ConsoleColor]::DarkGreen,
[System.ConsoleColor]::DarkCyan,
[System.ConsoleColor]::DarkYellow,
[System.ConsoleColor]::DarkBlue,
[System.ConsoleColor]::DarkRed,
[System.ConsoleColor]::DarkMagenta
) }
$NumberOfBoxes = 4
@ernestasju
ernestasju / _.sh
Created September 21, 2017 11:48
Install SQL Server 2017 on Ubuntu
sudo apt-get update
sudo apt-get install apt-transport-https ca-certificates curl software-properties-common
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list)"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
@ernestasju
ernestasju / CheckRapidStartExcel.ps1
Last active May 29, 2017 15:33
Validating [RapidStart] Excel files in directory parallel using XML maps (XML + XSD)
$LookAtFolder = 'C:\Users\ernjus.SOFTERA\Desktop\RS'
function Parallelize([int]$MinRunspaces, [int]$MaxRunspaces, [scriptblock]$ScriptBlock, [System.Collections.IDictionary[]]$Parameters)
{
$RunspacePool = [runspacefactory]::CreateRunspacePool($MinRunspaces, $MaxRunspaces)
$RunspacePool.Open()
$Commands = @()
foreach ($ParameterDictionary in $Parameters)
@ernestasju
ernestasju / Restore-SqlDatabase2.ps1
Created May 12, 2017 14:21
Restore MS SQL database with move.
#Requires -Module SqlServer
function Restore-SqlDatabase2
{
[CmdletBinding()]
param
(
[Parameter(Mandatory = $true)]
[string]
$BackupFile,