Blog

If you are using MS SQL Server and ever want to just obliterate your transaction log, you can use the following SQL (where your database name is "foo"): BACKUP LOG foo WITH TRUNCATE_ONLY DBCC SHRINKFILE(foo_log,2) Don't ever do this to a database you care about like, say, production. I wanted this because I am screwing around creating rainbow tables of SHA-1 hashes. The Cartesian product of joining a table to itself on 1=1 is very handy for producing all possible combinations of a set of characters. Inserting a few million records can put a lot of crap in your transaction log though.

A while back while building a monitoring tool for running processes on SQL Server 2005 I encountered the desire to color code SQL in the same manner of MS Query Analyzer (Or Management Studio) for HTML output. I hit up the CF-Talk list and Google for an existing ColdFusion implementation but got crickets. Not being one to give up, I created my own.

Hallelujah! According to Kristen Schofield's blog (ColdFusion Product Marketing Manager), the academic version of ColdFusion is now available for educational institutions teaching ColdFusion. http://www.webbschofield.com/index.cfm/2008/9/2/ColdFusion-8-Now-Available-to-Students-and-Educators-for-Free

I've built and consumed SOAP web services. I've consumed REST web services. It wasn't until a couple days ago I got a chance to consume an XML-RPC web service. I'll readily admit, I'm still a little unsure of the exact differences between the two, but the more I Google, the clearer it is becoming.

I was working on a friend's multi-meter today and found myself needing to run to RadioShack. I'd rather not elaborate why I needed to fix my friend's multi-meter. It involves a test lead in the Ohms plug, 120 Volts AC, 2 blown fuses, 1 smoked capacitor and me. Suffice it to say I set out to fetch a new ceramic capacitor with radial leads, measuring 82 pico farads that wasn't shorted out.

If you have ever used the iif() (inline if) function in ColdFusion you have probably found yourself using the de() (delay evaluate) function as well. I remember using that function for quite some time without ever really understanding when I needed it and exactly what it did. I found myself explaining it to someone last week and thought it would be an interesting topic to blog.

I installed SQL Server 2005 Express today on my home PC. For the most part it was painless, but there were a couple snags. First, it took me a couple tries to find the right download page. A bunch of the links on Microsoft's site kept redirecting me to the 2008 page. Still other pages wouldn't even mention 2005.

Have I been the only person constantly annoyed by the JavaScript error that pops up on EVERY SINGLE page at feeds.adobe.com? Apparently you only get the message in IE. It is related to some site tracking code called SiteCatalyst and apparently doesn't run for Firefox. I kept assuming Adobe would fix it, but it's been weeks, so I finally fired up MS Fiddler to have a look.

Adobe announced their free academic version of ColdFusion at CFUnited this year that would be available to educational institutions teaching ColdFusion. The release has been plagued by delays, but they promise it is coming soon. During a discussion today on the CF-Talk list about it, the topic of textbooks for teaching ColdFusion came up. I bugged Ben Forta about it and he stated that while they would love to release official teaching materials with it, they haven't received approval for it from the Adobe big cheese yet and he's not holding his breath.

I had a little time tonight to download and install FarCry 5.0.0 to play around. I mainly just wanted to see how it worked and what all you can do with it. It seems a lot of people complain that it is too complicated. I guess I'll see for myself.