FlashDevelop: A great SDK for actionscript

Flash Develop Site

Mongo DB

This article has a recommended reading list to get acquainted with mongoDB:

• Interactive Online Shell Tutorial - 5 minute hands-on demonstration of mongoDB by Kyle Banker.  I also recommend his other posts on mongoDB.
• Case Study on Switching to mongoDB - Very insightful and well-written article on why a company went from MySQL to MongoDB and the issues involved in their migration by David Mytton.
• Getting Started - mongoDB quick start reference.

Gmail Notifier

The Gmail Notifier tool will give you a popup notification on your desktop when you get an email in your gmail inbox.

JavascriptMVC - a fabulous framework

http://javascriptmvc.com/

I did a sample project with this.  Looks exciting, but there is definitely a learning curve.

There is a nice discussion of the merits of even attempting to do this in javascript here. 

Stored Procedure to Count Rows in Dynamic SQL

The first parameter contains the dynamic SQL string. The second parameter is an optional column name the count statement operates on; the default is *.

/*
 Counts the number of records in a dynamic sql string.  Example usage:
 declare @records int
 exec @records =  usp_CountRowsInDynamicSQL   'select recordId=5 union select recordId=6', 'recordId'
 print @records
 
*/
Create proc  usp_CountRowsInDynamicSQL (@sql varchar(800), @colNameToCount varchar(50) = '*' ) AS
 declare @rowCount int
 create table #tmpRowCount (row_Count int) 
 set nocount on
 set @sql = 'insert into #tmpRowCount (row_Count) select count(' + @colNameToCount + ') from ( ' + @sql + ') x'
 exec(@sql)
 set @rowCount = (select top 1 row_count from #tmpRowCount)  
 set @rowCount = isnull(@rowCount,0)   
 set nocount off
 drop table #tmpRowCount
 return @rowCount