mwinckler

up_generate_data_dictionary

To use this sproc, after creating it in the database you want to document, execute it in SQL Management Studio and view the "Messages" tab. Copy the contents of the "message" tab out into a text file, save it with a .html extension, and open it in a web browser.

mwinckler

PostgreSQL things that might be useful

https://tomcam.github.io/postgres/

Expanded mode

\x changes query output to "expanded" mode so table columns in results are listed vertically instead of horizontally. Run \x again to disable.

How to quit/exit/terminate/leave

mwinckler

javascript:(function() { var input = document.createElement('input'); input.setAttribute('type', 'hidden'); input.setAttribute('name', 'title'); input.setAttribute('value', prompt('New title:')); document.getElementById('lockable-summary').parentNode.appendChild(input); })();

mwinckler

<?php

// Populate this array with your shortcode tag names (not including brackets).
$shortcodes = array( 'contextbox' );

// Leave this array alone; it's what we'll use to stash shortcode content in until wpautop has safely passed.
$shortcode_replacements = array();

// See wp-includes/default-filters.php for core WordPress filter priorities
// 9 comes right before wpautop at 10

mwinckler

remove_filter( 'the_content', 'wpautop' );
remove_filter( 'the_excerpt', 'wpautop' );

mwinckler

<?php
// functions.php

add_shortcode( 'contentbox', 'mw_shortcode_contentbox' );

function mw_shortcode_contentbox( $attrs, $content = '' ) {
    $parsed_attrs = shortcode_atts( array(
        'align' => ''
    ), $attrs );
  

mwinckler

[alias]
    alias = config --get-regexp ^alias
    editconfig = !sub ~/.gitconfig
    lol = log --graph --decorate --pretty=oneline --abbrev-commit --all
    mylog = log --graph --decorate --all --oneline
    tlog = !TortoiseGitProc.exe /command:log &
    ci = commit
    s = status -s
    lg = log --graph --decorate --all --oneline
    dt = difftool -y --dir-diff

mwinckler

location / {
	proxy_pass http://<ip-address-of-new-server>;
	proxy_set_header Host $http_host;
	proxy_redirect off;
	proxy_buffering off;
}

mwinckler

-- From http://stackoverflow.com/a/4849704/81554

SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%MyName%'

mwinckler

# Prompts for filename then base64-encodes the given file's contents and
# writes a new .base64 file in the same directory with the encoded contents.
# Handy for encoding stuff via irb.
require 'base64'
Proc.new {|filename| IO.write(filename.chomp(File.extname(filename)) + '.base64', Base64.strict_encode64(IO.binread(filename))) }.call([(print 'Filename: '), gets.rstrip][1])