mwinckler

		MapEditMode _mapEditMode = MapEditMode.normal;

		private void wpfMap1_MapClick(object sender, ThinkGeo.MapSuite.WpfDesktopEdition.MapClickWpfMapEventArgs e) {

					if (_mapEditMode == MapEditMode.add_text) {
				_mapEditMode = MapEditMode.adding_text;
				wpfMap1.Cursor = Cursors.Arrow;

				var canvas = new Canvas();
				TextEditor editor = null;

mwinckler

/* 
  Find all tables having more than X rows
  -----
  Prints table name if the table has more than @minRows rows
  Replace #{DBNAME} with database name
  Edit (or remove) where clause as desired
*/

select 'declare @name varchar(50), @ct int, @minRows int;
set @minRows = 0;'

mwinckler

declare @s varchar(4000);
set @s = null;
select @s = coalesce(@s + ', ' + column_name, column_name)
from information_schema.COLUMNS
where TABLE_NAME = 'sb_tmpSamplePAList';
select @s;

mwinckler

(function() {
	var boName = prompt('What do you want to name this build order?');
	var supply = 6;
	var orders = $('<ol></ol>').css({'list-style-type':'none'});

	// For the duration this window is displayed, suspend the
	// document events trapping selection/mousedown/etc so that
	// the user can select/copy/paste the build order. See the
	// click handler on the close buttons for event restoration.
	var docEvents = jQuery.extend(true, {}, $(document).data('events')); 

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

Start with a list that looks like this:

public string MyProperty
public int MySecondProperty
public bool HoweverManyPropertiesYouWant

...then run a Find/Replace using regular expressions as follows:

Find:

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])

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

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

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