Skip to content

Instantly share code, notes, and snippets.

View huyttq's full-sized avatar

Huy Thái huyttq

  • Perth, Australia
View GitHub Profile
huyttq / Import-PfxCertificate.ps1
Created October 2, 2019 08:04 — forked from deadlydog/Import-PfxCertificate.ps1
PowerShell script that imports a .pfx certificate file. Useful to do before building the solution on a build server.
param($PfxFilePath, $Password)
$absolutePfxFilePath = Resolve-Path -Path $PfxFilePath
Write-Output "Importing store certificate '$absolutePfxFilePath'..."
Add-Type -AssemblyName System.Security
$cert = New-Object System.Security.Cryptography.X509Certificates.X509Certificate2
$cert.Import($absolutePfxFilePath, $Password, [System.Security.Cryptography.X509Certificates.X509KeyStorageFlags]"PersistKeySet")
$store = new-object -argumentlist "MY", CurrentUser
huyttq / RestoreDbWithReplace.sql
Last active July 11, 2018 06:26
Restore MS SQL Server DB with replace
use [master]
Declare @BackupFileLocation varchar(max)
Declare @BackupMDFFileName varchar(max)
Declare @BackupLogFileName varchar(max)
Declare @ImportTesterMDFFileName varchar(max)
Declare @ImportTesterLogFileName varchar(max)
set @BackupFileLocation =
huyttq / gist:2000353
Created March 8, 2012 10:42
Install imagemagick
mkdir -p ~/local
command -v identify > /dev/null
if [ $? -eq 1 ]; then
echo "${bldgrn}Installing imagemagick into ${txtwht}$HOME/local/imagemagick${txtrst}"
wget -N --retr-symlinks
tar -xzvf ImageMagick.tar.gz
cd ImageMagick-*
./configure --prefix=$HOME/local/imagemagick
huyttq / gist:1862679
Created February 19, 2012 09:06
Useful Vim commands
# Replace text across files
:args dir_path/*/* #(for 2 levels)
:argdo %s/, :expire.*)/)/gc | update
huyttq / gist:1814612
Created February 13, 2012 07:28
Rails & Jenkins notes
Setup Redis server
huyttq / gist:1814610
Created February 13, 2012 07:27
Ruby code quality
huyttq / gist:1813644
Created February 13, 2012 04:22
Zero downtime when migration
class << self
RemovedColumns = {'column_to_remove' => true}
def columns
cols = super
cols.reject { |col| RemovedColumns.has_key? }
huyttq / gist:1380019
Created November 20, 2011 08:54
Useful bash commands
History: Ctrl + r
Find: find /home/user -name abc.txt
Pipeline: vi `find /home/user -name abc.txt`
Ctrl-x, Ctrl-e will bring up an $EDITOR containing whatever is currently entered into the prompt. (opposed to editing last command actually entered)
Managing remote systems and trying to figure out what hardware you're on and whether it's healthy or not: dmidecode
Repeat last command with "sudo" prepended: sudo !!
Execute <command> with the argument to your previous command: <command> !$ / !* for get all args.
huyttq / gist:1363082
Created November 14, 2011 02:15
.vimrc for ruby
" General
set nocompatible
set history=1024
set cf " enable error files and error jumping
set ffs=unix,dos,mac " support these files
filetype on
filetype plugin on
filetype indent on
huyttq / gist:1354248
Created November 10, 2011 06:17
Slice specific param to work well with cabybara
<%= link_to("Send", send_task_admin_path(task, params.slice(:page))) %>