andreasbotsikas’s gists

andreasbotsikas / Program.cs

Created December 15, 2016 01:33

Sync folders by copying only new files, ignoring moved files on target path

	class Program
	{
	static void Main(string[] args)
	{
	var fromPaths = ConfigurationManager.AppSettings["FromPath"].Split(';');
	var toPaths = ConfigurationManager.AppSettings["ToPath"].Split(';');

	if (fromPaths.Length != toPaths.Length)
	{
	throw new ApplicationException(string.Format("From paths must be equal to to paths. Got {0} from and {1} to", fromPaths.Length, toPaths.Length));

andreasbotsikas / SelectDateFromTimestamp.sql

Last active December 15, 2016 01:26

SQL convert unix timestamp to date

	-- To select min max dates
	select
	dateadd(S, min([time])/1000, '1970-01-01') as startdate,
	dateadd(S, max([time])/1000, '1970-01-01') as enddate
	FROM HistoricTable

	-- To add a calculated column per row
	BEGIN TRANSACTION
	GO
	ALTER TABLE HistoricTable ADD

andreasbotsikas / ExportTableFromArchiveDBs.ps1

Created December 15, 2016 01:21

Export tables to csv via powershell

	# These databases contain a dbo.VfiTagNumHistory and a dbo.VfiTagStrHistory table
	$Database = @("VfiTag","VfiTag_0_1427961614083","VfiTag_1427961614084_1397948399843","VfiTag_1427961614084_1403650799757","VfiTag_1427961614084_1409957999664","VfiTag_1427961614084_1415401199875","VfiTag_1427961614084_1420239599988","VfiTag_1427961614084_1423609199863","VfiTag_1427961614084_1425941999989")

	# For each database
	$Database \| foreach {
	# export num history to csv using the bcp tool
	$command = "cmd.exe /C ""C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\bcp.exe"" $_.dbo.VfiTagNumHistory out C:\Work\Personal\Optimus\$($_)_Num.csv /S. /c /t, -T"
	Invoke-Expression -Command:$command
	#export the string history to csv using the bcp tool
	$command = "cmd.exe /C ""C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\bcp.exe"" $_.dbo.VfiTagStrHistory out C:\Work\Personal\Optimus\$($_)_Str.csv /S. /c /t, -T"

andreasbotsikas / Program.cs

Last active October 9, 2023 10:38

Move Azure blobs from one container to another

	using System;
	using Microsoft.WindowsAzure.Storage;
	using Microsoft.WindowsAzure.Storage.Blob;
	/// <summary>
	/// Moves blobs from one container to another
	/// Install-Package WindowsAzure.Storage
	/// </summary>
	namespace MoveBlobs
	{
	class Program

andreasbotsikas / GenerateStrongerKeysAndFixFiddler.bat

Last active August 29, 2015 14:24

Generating localhost certificates and modifying fiddler's CA

	@ECHO OFF
	@rem Check for visual studio tools if not already loaded
	if defined VCINSTALLDIR goto GenerateCerts
	@rem Ensure that visual studio is available
	if not defined VS120COMNTOOLS goto msbuild-not-found
	if not exist "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat" goto msbuild-not-found
	call "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat"
	@rem Check that vs is properly loaded
	if not defined VCINSTALLDIR goto msbuild-not-found

andreasbotsikas / GeneratePxf.bat

Last active January 21, 2020 17:37

Generate windows phone and win8 app certificate

	REM The following is a relic from the visual studio command line era.
	call "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat"

	REM https://docs.microsoft.com/en-us/previous-versions/dotnet/netframework-4.0/bfsktky3(v=vs.100)
	makecert -n "CN=MyName" -r -h 0 -eku "1.3.6.1.5.5.7.3.3,1.3.6.1.4.1.311.10.3.13" -e 01/01/2200 -sv private.pvk cert.cer

	REM In powershell you can just add the windows sdk path for pvk2pfx
	REM $Env:Path += "C:\Program Files (x86)\Windows Kits\10\bin\x64\"
	pvk2pfx -pvk private.pvk -spc cert.cer -pfx certificate.pfx

andreasbotsikas / FiddlerCAGenerator.bat

Last active August 29, 2015 14:18

Generate CA certificate for Fiddler

	@ECHO OFF
	@rem Check for visual studio tools if not already loaded
	if defined VCINSTALLDIR goto GenerateCerts
	@rem Ensure that visual studio is available
	if not defined VS120COMNTOOLS goto msbuild-not-found
	if not exist "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat" goto msbuild-not-found
	call "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat"
	@rem Check that vs is properly loaded
	if not defined VCINSTALLDIR goto msbuild-not-found

andreasbotsikas / ConfigureProxy

Created April 1, 2015 20:26

Proxy Setting

andreasbotsikas / CreateUsers.ps1

Created March 8, 2015 15:34

Create multiple local users

	# Script based on http://stackoverflow.com/questions/383390/create-local-user-with-powershell-windows-vista
	# Creates 30 users that are administrators and belong to the Remote Desktop Users group.

	function create-account ([string]$accountName) {
	$hostname = hostname
	$comp = [adsi]"WinNT://$hostname"
	$user = $comp.Create("User", $accountName)
	$user.SetPassword("pass@word1")
	$user.SetInfo()
	$User.UserFlags[0] = $User.UserFlags[0] -bor 0x10000 #ADS_UF_DONT_EXPIRE_PASSWD flag is 0x10000

andreasbotsikas / GenerateLocalhost.bat

Created February 10, 2015 14:10

Certificates

	@ECHO OFF
	@rem Check for visual studio tools if not already loaded
	if defined VCINSTALLDIR goto GenerateCerts
	@rem Ensure that visual studio is available
	if not defined VS120COMNTOOLS goto msbuild-not-found
	if not exist "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat" goto msbuild-not-found
	call "%VS120COMNTOOLS%..\..\vc\vcvarsall.bat"
	@rem Check that vs is properly loaded
	if not defined VCINSTALLDIR goto msbuild-not-found

Andreas Botsikas andreasbotsikas