Microsoft Open Technologies Inc. on Web Camp TV

May 29, 2013

I have been working with Microsoft Open Technologies Inc. for the past several months on their brand new web presence. It officially launched a couple weeks ago and is still a work in progress with many cool expansions in the works. Channel 9 has a monthly show called Web Camp TV that recently featured Jaffe

How to retrieve a usable date format from the Telligent REST API

April 23, 2013

Telligent’s Community Server has a REST API that allows developers to tap into almost every aspect of the database. While creating an importer for WordPress I was attempting to backfill posts with the correct publish date. Telligent provides the publish date through a field called PublishedDate, however in its default format the date is not

First Experiences with WebMatrix 2 and Windows Azure Website

February 16, 2013

WebMatrix is a free web development tool produced by Microsoft. WebMatrix is a complete development environment that not only provides a code editor, it also creates a new private instance of IIS Express to debug your project in, and downloads any dependencies your project may need, I.E. SQL Server Express, MySQL, PHP, etc. I was

Count lines of code in files recursively

January 26, 2013

If you are attempting to find a count of the total lines of code in files in a directory recursively from Linux or Mac OS X the following command will do what you want. This particular command prints out all lines contained in any file with a .php extension, then counts the number of lines

MySQL: Show count of records in each table of a database

December 12, 2012

I recently did a dump of my database on this site and it was almost 300 megabytes! That is pretty huge for a simple personal site. Curious as to where all that data was hiding I whipped up a quick SQL query that calculates the total number of rows per table in a single database.