March 2010 - Posts

• AutoAudit 1.10c

  AutoAudit is a free SQL Server (2005, 2008) Code-Gen utility that creates Audit Trail Triggers with: · Created, Modified, and RowVersion (incrementing INT) columns to table · Creates View to reconstruct deleted rows · Creates UDF to reconstruct Row History Read More... Posted Wednesday, March 17, 2010 10:16 PM by Paul Nielsen | 2 Comments Filed under: Audit Trails, AutoAudit, CodePlex

• There once was in Dublin a query

  For 6 months I’ve have been planning a secret trip to London in May as a surprise for my wife (of Irish heritage and accent) (I love how she says, "Aye laddie, kiss me I'm Irish." but that's for another blog.) The plan was to spend a week in London and Read More... Posted Thursday, March 11, 2010 11:00 AM by Paul Nielsen | 17 Comments Filed under: Dublin, Ireland, limerick, User Group

• Twitter will migrate from MySQL to Cassandra DB

  Since most of us are active on Twitter, I figured this would be of interest: http://www.dataprix.com/en/blogs/carlos/twitter-will-migrate-mysql-cassandra-db Read More... Posted Friday, March 05, 2010 4:48 PM by Paul Nielsen | 3 Comments

• Extensive library of Excel functions for SQL Server

  When SQL Server 2000 introduced user-defined functions I predicted that a few companies would release sets of cool financial/mathematical/statistical functions. It didn’t happen. When SQL Server 2005 introduced the CLR, I again predicted that a few companies Read More... Posted Tuesday, March 02, 2010 5:27 PM by Paul Nielsen | 0 Comments Filed under: Excel functions WestClinTech