This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Verifying that +vardars is my Bitcoin username. You can send me #bitcoin here: https://onename.io/vardars |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT CONVERT (varchar, getdate(), 126) AS runtime, | |
mig.index_group_handle, mid.index_handle, | |
CONVERT (decimal (28,1), migs.avg_total_user_cost * migs.avg_user_impact * | |
(migs.user_seeks + migs.user_scans)) AS improvement_measure, | |
'CREATE INDEX missing_index_' + CONVERT (varchar, mig.index_group_handle) + '_' + | |
CONVERT (varchar, mid.index_handle) + ' ON ' + mid.statement + ' | |
(' + ISNULL (mid.equality_columns,'') | |
+ CASE WHEN mid.equality_columns IS NOT NULL | |
AND mid.inequality_columns IS NOT NULL | |
THEN ',' ELSE '' END + ISNULL (mid.inequality_columns, '') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# http://blog.dantup.com/2012/05/free-dependency-graph-generation-using-powershell-and-yuml/ | |
function Get-ProjectReferences | |
{ | |
param( | |
[Parameter(Mandatory)] | |
[string]$rootFolder, | |
[string[]]$excludeProjectsContaining | |
) | |
dir $rootFolder -Filter *.csproj -Recurse | | |
# Exclude any files matching our rules |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# merge text files into one | |
# for %f in (*.txt) do type "%f" >> output.txt # v1 | |
forfiles /p C:\input\ /s /m *.txt /c "cmd /c type @file >> C:\output\output.txt" #v2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Drawing; | |
using System.Text; | |
namespace AsciiPainter | |
{ | |
class Program | |
{ | |
static void Main() | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# by http://github.com/jehiah | |
# this prints out some branch status (similar to the '... ahead' info you get from git status) | |
# example: | |
# $ git branch-status | |
# dns_check (ahead 1) | (behind 112) origin/master | |
# master (ahead 2) | (behind 0) origin/master | |
git for-each-ref --format="%(refname:short) %(upstream:short)" refs/heads | \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
npm install html-to-text -g | |
curl -s http://whatthecommit.com | html-to-text --ignoreHref=true |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
import sys, re | |
from subprocess import check_output | |
branch = check_output(['git', 'symbolic-ref', '--short', 'HEAD']).strip() | |
commit_msg_filepath = sys.argv[1] | |
with open(commit_msg_filepath, 'r') as f: | |
content = f.read() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$solutionName = "$$$SOLUTION_NAME$$$" | |
$systemRoot = $env:systemroot | |
$msbuildExe = "$systemRoot\Microsoft.NET\Framework\v4.0.30319\msbuild.exe" | |
$currentPath = Convert-Path(".") | |
$currentDate = Get-Date -format yyyyMMdd-HHmm | |
function ZipFiles( $zipfilename, $sourcedir ) | |
{ | |
Add-Type -Assembly System.IO.Compression.FileSystem |