TypeScript 0.8.2 on AppHarbor

It doesn’t look like AppHarbor is supporting TypeScript yet, which makes sense considering that TypeScript is in preview. So if you want to use AppHarbor to build your TypeScript files as part of its continuous integration/deployment, you’ll have to do a little bit of manual work. Before going through the steps below, make sure you have followed the steps in the Compile-on-Save TypeScript post. Copy C:\Program Files\MSBuild\Microsoft\Visual Studio\v11.0\TypeScript and C:\Program Files\Microsoft SDKs\TypeScript into some place in your repository....

February 10, 2013

Describing Tables in MSSQL

There are 2 particularly good stored procedures in SQL Server for getting information about a particular table. sp_columns returns detailed information about each of the columns in the table. Thanks to Vincent Ramdhanie StackOverflow answer sp_columns @tablename sp_help returns detailed information about the entire table including the columns and constraints. Thanks to Brannon for his StackOverflow answer sp_help @tablename

February 9, 2013

Remove a Passphrase from a SSH Key

If you are using GitHub for Windows with non-GitHub repositories, you may have run into the limitation that you cannot sync using an SSH key with a passphrase. One workaround is to push/pull from the shell, but if don’t mind removing the passphrase from the key, use the following command. ssh-keygen -p -P "my_old_password" -N “” -f my_key_file_name After you remove the passphrase you should be able to sync from within the GitHub for Windows client....

February 4, 2013

Pass a Connection String to a Generated DbContext

The default DbContext generated with your Entity Data Model has one constructor that takes no arguments. If you need to build the connection string programatically and pass it to the DbContext, you will have to add your own constructor. However, if you do this in the generated file, {ModelName}.Context.cs, you will lose your changes the next time the {ModelName}.Context.tt script is run. The solution is to edit the script, {ModelName}.Context.tt. Just add the following code after the code to generate the default constructor (around line 71)....

February 3, 2013

Home Network Guide

Lately I’ve been working on improving my home network, so I’ve decided to write up some posts on my experience. Most of them will probably be pretty short and reference other sites and tutorials, but I plan on pointing out some of the issues, tips and tricks I’ve discovered along the way. Here’s some of the things that I’ll be going over. As I make posts about each of these, I’ll place links to them here....

February 2, 2013