Stefan Seeland stesee

## ReencodeAudio.sh
ffmpeg -i In.mp4 -map 0:v -c:v copy -map 0:a -c:a:0 aac Out.mp4

## mkvToMp4.sh
for f in *.mkv; do echo "Processing $f file.."&&ffmpeg -i "$f" -c copy "$f.mp4"&& rm "$f"; done

## Test-SqlConnection.ps1
function Test-SqlConnection {
  param(
    [Parameter(Mandatory)]
    [string]$ServerName,
    [Parameter(Mandatory)]
    [string]$DatabaseName
  )

  $connectionString = "Data Source=$ServerName;Integrated Security=true;Initial Catalog=master;Connect Timeout=3;database=$DatabaseName;"
  $sqlConn = new-object ("Data.SqlClient.SqlConnection") $connectionString

## enableSshCertAuthCheatSheet.sh
ssh-keygen
ssh-copy-id username@remote_host

## tvheadendHealthCheck.sh
#!/bin/bash
# install stuff before using this script
#   sudo apt install libxml-xpath-perl curl

#configure your kodi settings
URL=localhost
PORT=9981
USERNAME=kodi
PASSWORD=kodi

## robocopyUserProfiles.ps1
robocopy "$env:UserProfile\..\" F:\UserprofileBackup *.* /r:0 /w:0 /mir /sl /XJ

## VS16NoTelem.bat
@echo off

fltmc >nul 2>&1 || (
    echo This batch script requires administrator privileges. Right-click on
    echo the script and select "Run as administrator".
    goto :die
)

rem Change this path if you are using Community or Professional editions
set "VS_INSTALL_DIR=%ProgramFiles(x86)%\Microsoft Visual Studio\2019\Enterprise"

## gif2mp4.sh
ffmpeg -i source.gif -movflags faststart -pix_fmt yuv420p -vf "scale=trunc(iw/2)*2:trunc(ih/2)*2" destination.mp4

## InstallVeraPdf.sh
wget http://downloads.verapdf.org/rel/verapdf-installer.zip
unzip verapdf-installer.zip
cd verapdf-green*
./verapdf-install
echo run "java -jar ~/verapdf/bin/greenfield-apps-1.14.8.jar"

## listInstalledDotnetCoreSdks.ps1
$packages = Get-Package -Provider Programs -IncludeWindowsInstaller
foreach (${package} in ${packages}) {  if ($package.Name -match "Microsoft .NET Core SDK") { Write-Output $package.Name  }}
	function Test-SqlConnection {
	param(
	[Parameter(Mandatory)]
	[string]$ServerName,
	[Parameter(Mandatory)]
	[string]$DatabaseName
	)

	$connectionString = "Data Source=$ServerName;Integrated Security=true;Initial Catalog=master;Connect Timeout=3;database=$DatabaseName;"
	$sqlConn = new-object ("Data.SqlClient.SqlConnection") $connectionString
	#!/bin/bash
	# install stuff before using this script
	# sudo apt install libxml-xpath-perl curl

	#configure your kodi settings
	URL=localhost
	PORT=9981
	USERNAME=kodi
	PASSWORD=kodi
	@echo off

	fltmc >nul 2>&1 \|\| (
	echo This batch script requires administrator privileges. Right-click on
	echo the script and select "Run as administrator".
	goto :die
	)

	rem Change this path if you are using Community or Professional editions
	set "VS_INSTALL_DIR=%ProgramFiles(x86)%\Microsoft Visual Studio\2019\Enterprise"
	wget http://downloads.verapdf.org/rel/verapdf-installer.zip
	unzip verapdf-installer.zip
	cd verapdf-green*
	./verapdf-install
	echo run "java -jar ~/verapdf/bin/greenfield-apps-1.14.8.jar"
	$packages = Get-Package -Provider Programs -IncludeWindowsInstaller
	foreach (${package} in ${packages}) { if ($package.Name -match "Microsoft .NET Core SDK") { Write-Output $package.Name }}