HeLiBloks

## sed ish
$a -replace "([A-z])(23)","$1,$2"

##seq 1 10
1..10

##loop
for ($i=0;$i -lt 10; $i++) { echo $i }

##copy files recursive 

HeLiBloks

//##show message box
MessageBox.Show(Dts.Variables["YourVariableNameHere"].Value.ToString());

//regexMatch [[:number:]]
Regex.Match(Row.var, @"\d+").Value

//
Regex.Match(Row.var, @"[A-Za-z]+").Value

//date 09/12/1980

HeLiBloks

//## timeStamp 
(DT_STR,4,1252) DatePart("yyyy",getdate()) +
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("hour",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("minute",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("second",getdate()),2)

HeLiBloks

set nocompatible              " be iMproved, required
filetype off                  " required

" " set the runtime path to include Vundle and initialize
 set rtp+=~/.vim/bundle/Vundle.vim
 call vundle#begin()
" " alternatively, pass a path where Vundle should install plugins
" "call vundle#begin('~/some/path/here')

" " let Vundle manage Vundle, required

HeLiBloks

New-Alias -Name grep -Description grep Select-String

HeLiBloks

--GRANT ALL SQL SERVER

USE master;
go

use [the db];
CREATE LOGIN theUser WITH PASSWORD = 'ComplexPassword01';
CREATE USER  theUser FOR LOGIN theUser;

GRANT BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW,CREATE DATABASE,CONTROL,ALTER 

HeLiBloks

source! ~/.vimperatorrc.local
set editor=gvim -f
" vim: set ft=vimperator:
set hintmatching

set hlsearch
set ignorecase

"#set wildmode=auto
" cpt=1

HeLiBloks

" Modeline and Notes"{
" vim: set sw=4 ts=4 sts=4 et tw=78 foldmarker="{,"} foldlevel=0 foldmethod=marker filetype=vim noswapfile spell:
"}

let g:python_host_prog='/usr/bin/python2.7'
let g:python3_host_prog = '/usr/bin/python3'

set nocompatible              " be iMproved, required
filetype off                  " required

HeLiBloks

###
#   wget https://gist.githubusercontent.com/HeLiBloks/db58ff3978ed6ad8b171/raw/5d34ed59c4e760d22b309de4285bca391f55e1bd/WindowsServer12R2Labb
##

Set-ExplorerOptions -showHidenFilesFoldersDrives -showProtectedOSFiles 
Enable-RemoteDesktop
    Install-WindowsUpdate -AcceptEula
    Update-ExecutionPolicy Unrestricted

### See for details

HeLiBloks

-- This will insert X years worth of data into a Date table. All fields are INT apart from DayName and DateTime (NVARCHAR(10) and DATE respectively)
-- Update 19/12 now uses ISO Week Number

-- Define start (base) and end dates
DECLARE @basedate DATETIME = '20111101', @enddate DATETIME = '20150101';

DECLARE @days INT = 0, @date DATETIME = '20110101', @maxdays INT = DATEDIFF(dd, @basedate, @enddate);
WHILE @days <= @maxdays
BEGIN
	SET @date = DATEADD(dd, @days, @basedate);