JefClaes

using (var conn = new SqlConnection(@"Data Source=(LocalDb)\v11.0;Initial Catalog=Master;Integrated Security=True"))
{
    conn.Open();
    
    var cmd = new SqlCommand();
    cmd.Connection = conn;
    cmd.CommandText =  string.Format(@"
	IF EXISTS(SELECT * FROM sys.databases WHERE name='{0}')
	BEGIN
		ALTER DATABASE [{0}]

ericelliott

Essential JavaScript Links

I no longer mantain this list. There are lots of other very comprehensive JavaScript link lists out there. Please see those, instead (Google "awesome JavaScript" for a start).

cletusw

{
  // http://eslint.org/docs/rules/

  "ecmaFeatures": {
    "binaryLiterals": false,                    // enable binary literals
    "blockBindings": false,                     // enable let and const (aka block bindings)
    "defaultParams": false,                     // enable default function parameters
    "forOf": false,                             // enable for-of loops
    "generators": false,                        // enable generators
    "objectLiteralComputedProperties": false,   // enable computed object literal property names

samhocevar

#!/bin/sh
#
#  msys2-sshd-setup.sh — configure sshd on MSYS2 and run it as a Windows service
#
#  Please report issues and/or improvements to Sam Hocevar <sam@hocevar.net>
#
#  Prerequisites:
#    — MSYS2 itself: http://sourceforge.net/projects/msys2/
#    — admin tools: pacman -S openssh cygrunsrv mingw-w64-x86_64-editrights
#

alefteris

---
parser: espree
env:
  amd: false
  browser: false
  es6: false
  jasmine: false
  jquery: false
  meteor: false
  mocha: false

MonkeyDo

@link-hover-color: lightblue; //Change this to your needs
a{  
    color: @link-color;
    &:hover{
        color: @link-hover-color;
    }
    &:hover, &:focus{
        text-decoration: none;
    }
    &:visited:not(.btn){

sillage

#!/bin/bash
# file format: ARTIST/ALBUM/01-TITLE.flac
read -p "YEAR? " -n 4 YEAR
ALBUM="${PWD##*/}"              # ALBUM=$(basename "${PWD}")
ARTIST=$(echo $(cd .. && echo "${PWD##*/}"))

# delete all
metaflac --preserve-modtime --remove-all-tags *.flac
# artist, album, year and cover
metaflac --preserve-modtime --set-tag=ARTIST="${ARTIST}" --set-tag=ALBUM="${ALBUM}" --set-tag=DATE=${YEAR} --import-picture-from=Folder.jpg *.flac

sheastrickland

Lesson Learnt, Streaming Producer / Consumer issue using:

BlockingCollection<T> and Parallel.ForEach(_blockingCollection.GetConsumingEnumerable

Beware default Partitioner algo, which is chunking and buffering.

The GetConsumingPartitioner heading covers it, and also the first comment from Stephen Toub totally nails it. We implemented similar to what commenter Hernan pointed out. Stephen Toub Blog

My absolute saviour, NoBuffering in:

salarmehr

// a gulp task to clean up vendor folder files for production machine. 

var gulp = require('gulp');
var zip = require('gulp-zip');


gulp.task('zip-vendor', function () {
    return gulp.src(
        [
            'vendor/**/*',

albertpastrana

Single liner script to fetch and setup the useful git-prompt and git-completion utilities with your bash profile prompt

To use:

• Copy script, paste on command line, hit enter

Enjoy:

• Pretty colours man
• Clear directory path info
• If in git controlled dir, the current branch name (yay!)
• Hit tab when typing git commands to complete the commands, remotes, and branch names (soo goddamn yay!)