Pauls Blog

Setup Time Server on Windows Server 2012  https://support.microsoft.com/en-us/kb/816042

I haven't tested this, and it seems more complicated than what I need, but http://stackoverflow.com/questions/21848271/redirecting-standard-input-of-console-application

https://www.microsoft.com/en-au/download/details.aspx?id=35588

http://davidcummings.org/2012/08/26/saas-cost-of-goods-sold-for-startups/

#!/bin/bash now=$(date +"%m_%d_%Y") cd /e/DB_Structure_VersionControl git add . git commit . -m "Automatic Nightly Commit $now"  From Windows you could start this with something like sqlps -Command "&{C:\scripts\dbvc\dbvc.ps1}" "C:\Program Files\Git\bin\sh.exe" --login -i -- C:\scripts\dbvc\vcbash

FreeNAS makes it easy to replace a faulty drive in an array Instructions at  https://doc.freenas.org/9.3/freenas_storage.html#replacing-a-failed-drive  explain it well Basically, all the action is completed in drive status from the raid volume, and click the "Replace" button.  This is not immediately intuitive. You would think that you could also do this from "View Disks", but you cannot. From Volumes, select the row of root of the volume that is suffering, click the "Status" icon,   It looks like a bunch of rows. This takes you to another screen. Select the disk in question, if not already offline, take it offline.  Then, Press the replace button, and select the new drive from the pulldown (obviously, the new drive needs to be in the system) Depending on how you got the new disk into the machine, you may also need to "Detach" the old disk afterwards

I previously used a trigger to store previous versions of MSSQL stored procedures, documented elsewhere in my blog, at Version Control of Stored Procedures - MSSQL This was nice and provided a good automated backup for MSSQL structure changes, however I always wanted something to punch through to git. I now have it... Step 1: Create a SQLPS script  $ServerName = " DB\SQL " $SQL_Databases = @( "db1" , "db2 " ) $dbentities = @( "Tables" , "StoredProcedures" , "Triggers" , "Views" , "UserDefinedFunctions" ) $doTableTriggers = $true $dumpPath = "D:\DB_Structure_VersionContro l" foreach ( $db in $SQL_Databases ) { foreach ( $ent in $dbentities ) { $targetPath = " $dumpPath \ $db \ $ent \" $pathok = Test-Path $targetPath if ( ! $pathok ){     New-Item -ItemType Directory -Path $targetPath } foreach ( $tbl in Get-ChildItem SQLSERVER:SQL