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
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
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
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
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.