CFML Advisory Committee Update and ColdBox

Posted by Brad Wood
Apr 11, 2009 07:25:00 UTC
Just a couple things I wanted to mention... The first is that the CFML Advisory Committee has been at work drafting their first version of the CFML language spec. Also, while looking through I noticed they are using CodexWiki which runs on ColdBox which is pretty cool. Speaking of ColdBox...

Sean Corfield's Blog Running Ralio

Posted by Brad Wood
Mar 29, 2009 08:01:00 UTC
I've been following Sean Corfield's nice series, Railo for Dummies on installing Railo, Tomcat and Apache. (Does that make me a dummy?) His latest entry showed the simple steps he followed to convert his blog over from Java 1.4 and CF7 to Java 1.6_13 and Railo

SQL Server: Extracting JUST Time From Datetime Value

Posted by Brad Wood
Mar 26, 2009 08:18:00 UTC
Tonight I found myself needing to extract just the time from a datetime column in SQL Server 2000. After a bit of Googling, it became clear that there are about 1 million articles on how to extract just the date from a datetime, but not very many articles taking about just getting time. For reference, this is how I ended up doing it.

SQL Server DTS: I Love It When A Plan Comes Together... Then Falls Apart Again.

Posted by Brad Wood
Mar 23, 2009 04:52:00 UTC
At work, we are building some content management utilities to keep track of our training materials and document all of our content in a database. To get a head start, our marketing team started a large Excel spreadsheet to list, categorize, label, and tag our hundreds and hundreds of resources. We decided to attempt to automatically import some of the content directly from Excel to keep them from having to hand-enter it again. Seeing as how we are wandering around in the cold, dark, stone ages of SQL Server 2000 I thought I would throw the .XLS file at a DTS package and see what happened.

Add Your Own Custom Tools To CF Administrator- How Did I Miss This?

Posted by Brad Wood
Mar 21, 2009 18:58:00 UTC
This is a really cool feature of ColdFusion 8 that I had totally missed but I stumbled across an article on Ray Camden's blog today. (Thanks Ray!) Basically, you can modify your ColdFusion Administrator menus to include custom tools of your own choosing. Several pre-built ones out there including SpoolMail, a nifty util to re-copy your undeliverable mail back into the spool folder; and Cache Clearer, an easy way to clear out specific folders of trusted cache.

JQuery Corners-- What Will They Think Of Next?

Posted by Brad Wood
Mar 21, 2009 06:26:00 UTC
I have consistently been impressed by the number and quality of JQuery plugins that abound. Today at work we ran across JQuery Corners. This friggin' awesome plugin allows you to put rounded corners on your divs and it's oh, so easy.

ColdFusion Administrator: Why Can't I Browse The Server?

Posted by Brad Wood
Mar 19, 2009 20:03:00 UTC
I went to add a custom tag path onto my dev server this morning. Feeling a little lazy and not wanting to type in the full path by hand, I clicked the "Browse Server" button. There are similar buttons for adding ColdFusion mappings and searching for file-based databases while adding data sources. The Browse Server page uses an applet to let you choose directories or files off your server. I was greeted with an error message:
Server Error
IO error on server communication

Great Developer Resource: CF411

Posted by Brad Wood
Feb 19, 2009 08:04:00 UTC
This is a reminder of a great developer resource right here in our community. If you ever find yourself looking for a list of blog aggregators, hosting providers, job listings, code formatters, database tools, cf tools, editors, debuggers, time tracking apps or anything vaguely related to programming, you don't need to look much farther than

SQL Server Performance: How Are My Indexes Being Using?

Posted by Brad Wood
Feb 14, 2009 20:42:00 UTC
You may have a full-time DBA where you work, but a lot of us share the CF developer and DB developer hats. Your SQL Server's performance can be an easy thing to overlook if your database is very small, or your website gets very little traffic. The easy (but not always correct) answer to most performance problems is "add an index". Some indexes are an obvious help, but how do you tell if the less obvious ones are really being used? It is possible to have too many indexes. In addition to bloating the size of your database, they take time to update which can actually slow your application DOWN on inserts and updates.

SQL Server Gotcha: Implicit Unicode Conversion

Posted by Brad Wood
Feb 14, 2009 06:54:00 UTC
A recent thread on CF-Talk brought up this very good topic. It deals with the performance hit you can get when SQL Server implicitly converts your data to nchar and nvarchar for you when you have enabled Unicode support in your data sources. Unicode text cannot be stored in normal char or varchar fields. It must use nchar or nvarchar. These data types use two bytes per character, which means you can only store half as much text in them (limit 4,400 instead of 8,800). The problem is two fold:
  1. SQL Server cannot directly compare a varchar and nvarchar value so it must convert one.
  2. String manipulation or conversion on an indexed column will render the index useless

Site Updates

Entries Search