Category Archives: database

Use INFORMATION_SCHEMA to find data about your database

Posted on 02/21/2011 by Eric Fickes

Have you ever been in this situation?  You’re the new developer for a database powered application and you have to figure out what tables contain a specific column?  Or maybe you’ve got a legacy database that needs it’s stored procedures … Continue reading →

Posted in database, development, internets, SQL | Tagged , , , , , , , , , , , , , | 1 Comment

An aggregate may not appear in the set list of an UPDATE statement

Posted on 02/20/2011 by Eric Fickes

Ever seen the error “An aggregate may not appear in the set list of an UPDATE statement” when working with SQL Server?  I ran into this one recently after trying to put a COUNT in an UPDATE statement.  I was rewriting … Continue reading →

Posted in database, development, internets, microsoft, SQL, tips and tricks, tsql | Leave a comment

Eleven Coldfusion-ish tips from the field

Posted on 02/20/2011 by Eric Fickes

I’ve had this running list of Coldfusion tips on my wall for the last few years and it’s time to get these online.  All of the items in this list came from Coldfusion projects over the last few years, but … Continue reading →

Posted in adobe, coldfusion, database, tips and tricks | Tagged , , , , , , , , , , , , , , | 10 Comments

Today I took 30 minutes to save hours

Posted on 01/03/2011 by Eric Fickes

UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading →

Posted in database, development, SQL, tips and tricks | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment