Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

CFML Caching Tools

• CF_Accelerate, free, from Brandon Purcell's (Inspired by older CF_SuperCache). There's also a variant based on that, by Tom Dyson, to support file-based caching
• CF_CacheOMatic, free, from Eric Jansson (as discussed in and downloadable from a devX article)
• CF_TurboCache, free, from HotFusion
• cfmemcached, open source, from Jon Hirschi
• JohnnyCache, open source, from Andy Powell
• ScopeCache, open source, from Ray Camden
• I welcome additions/corrections/feedback.

About this series

This entry is part of an ongoing series, sharing each of the 100+ categories and the tools and resources I (and others) have identified. They're designed to answer the questions we hear, like , "does anyone know of tools or resources to help with ...?"

I've decided to start offering each category here as a blog entry, to give the list more exposure and to make sure I'm not missing anything. For now I'm offering each day one list from the resources and then another from the tools categories. To see the list of all categories, see Part 1 of this series. I may in the future offer an RSS feed of any updates made to the list.

I hope people will get great value out of the lists, here or on the tools and resources page. Please try to remember to point the list out to people you see asking for these kind of tools and resources. Thanks.

Additions/Corrections

The tools/resources list is a perpetual work in progress. I definitely welcome additions or corrections to it. If you have any to offer, you can leave them here as a comment on this blog entry and I'll move them to the list on my site.

BTW, before you offer an update here, please do check the category on the real list. I won't be coming back here to update these blog entries to sync them if I add new items to the real list.

Next up will be a category from the Resources section, CFML Frameworks/Methodologies. There are a lot more than you may think.

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

CFMAIL Replacements/Enhancements

• ActivMail, once commercial, now to be open source, from Zrinity (formerly from CFDev)
• InFusion Mail Server (IMS) and FusionMail, commercial (with free Developer edition), from CoolFusion
• Spoolmail, open source, from Ray Camden
  • Nice review of/introduction to it by Sam Farmer
• See also the Adobe Developer's exchange on tags/functions/apps related to CFMAIL, though it may contain very old variants that no longer work or are supported
• See also Brian Rinaldi's Open Source CF list of Email tools
• Note, as well, that the CFMAIL tag itself has evolved significantly over the years, so some of the various alternatives may not always be needed. 6.1 added replyto/failto/username/password/wraptext attributes, support for multiple mail servers in the server attribute, and several configuration options to the ColdFusion Administrator Mail Settings page. 6.1 also added support for HTML email via CFMAILPARAM and multipart email with CFMAILPART. You can even optionally not use the spooling process via an optional SpoolEnable as of 6. Finally CF 8 added priority, useSSL, and useTLS attributes.
• I welcome additions/corrections/feedback.

About this series

This entry is part of an ongoing series, sharing each of the 100+ categories and the tools and resources I (and others) have identified. They're designed to answer the questions we hear, like , "does anyone know of tools or resources to help with ...?"

I've decided to start offering each category here as a blog entry, to give the list more exposure and to make sure I'm not missing anything. For now I'm offering each day one list from the resources and then another from the tools categories. To see the list of all categories, see Part 1 of this series. I may in the future offer an RSS feed of any updates made to the list.

I hope people will get great value out of the lists, here or on the tools and resources page. Please try to remember to point the list out to people you see asking for these kind of tools and resources. Thanks.

Additions/Corrections

The tools/resources list is a perpetual work in progress. I definitely welcome additions or corrections to it. If you have any to offer, you can leave them here as a comment on this blog entry and I'll move them to the list on my site.

BTW, before you offer an update here, please do check the category on the real list. I won't be coming back here to update these blog entries to sync them if I add new items to the real list.

Next up tomorrow will be CFML Documentation/Help Tools and Resources and CFML Caching Tools.

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Returning to the tools section, and continuing in alphabetical order, the next category is Bug/Defect Tracking Tools.

Bug/Defect Tracking Tools

I've split this list into those written in CFML, and the rest, both open source and commercial.

Written in CFML

• cfdefect open source, from Qasim Rasheed (also at http://code.google.com/p/cfdefect/)
• Lighthouse Pro, open source, from Ray Camden
• Project Tracker, open source, from Joe Danziger
• Skweegee, open source, from Russ Johnson
• See also Brian Rinaldi's Open Source CF list of bug tracking tools
• I welcome additions/corrections/feedback.

Written in other than CFML (some downloadable, others as services; some open source, others commercial)

• Bugzilla, open source, from Mozilla
• Eventum, open source, from MySQL
• Fogbugz, commercial, from Fog Creek Software
• Gemini (for .NET, commercial, with free 5-user license), from Countersoft
• Jira, commercial, from Atlassian
• Mantis, open source, from MantisBT
• OnTime, commercial, with free single-user license, from Axosoft
• Rational BuildForge, commercial, from IBM
• Scarab, open source
• TestTrack Pro, commercial, from SeaPine
• Trac, open source
• Also, note that Mylyn, free, for Eclipse, offers intergration to popular defect tracking tools
• I welcome additions/corrections/feedback.

Additions/Corrections

This tools/resources list is a perpetual work in progress. I definitely welcome additions or corrections to it. If you have any to offer, you can leave them here as a comment on this blog entry and I'll move them to the list on my site.

BTW, before you offer an update here, please do check the category on the real list. I won't be coming back here to update these blog entries to sync them if I add new items to the real list.

About this series

This entry is part of an ongoing series, sharing each of the 100+ categories and the tools and resources I (and others) have identified. They're designed to answer the questions we hear, like , "does anyone know of tools or resources to help with ...?"

Someone may ask why I'm blogging each of these categories, when they're available online anyway. It's just that, through aggregation and feeds, blogs present a way to reach a wider (and new) audience who may not otherwise come across the list of tools and resources. This also widens the pool of eyes for possible updates to the list. I want it to be as accurate and up to date as possible. I may in the future offer an RSS feed of any updates made to the list.

Otherwise, I hope people will get great value out of the lists, here or on the tools and resources page.

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Today I'll jump from the resources section of the list to the tools section. It's just coincidental (well, alphabetical) that the first items in each list is about blogging (Part 2 was on CF-oriented blog aggregators.)

This entry is about CFML-based blogging tools, both downloadable and hosted.

Blogging Tools

The following are blogging tools (tools for creating a blog) that are written in CFML. Of course, you can find blogging tools written in many other languages that you may choose to use on your site (as well as hosted solutions, where the code platform doesn't matter to you). I don't want to try to keep here a list of all such CMSes, so this focuses on those that are written in CFML and that you can download. I list, after that, hosted solutions written in CFML.

• 1ssBlog, open source, from Ed Tabara
• AVBlog, open source, from Andrea Veggiani
• BlogCFC, open source, from Ray Camden
• BlogCFM, open source, from Rick Root
• CFBloggy, open source, from John Ramon (see also his blog)
• Fuseblog, open source, from James Husum (not updated in some time)
• KoldKast, free for download, and also available as a fee-based hosted solution, from Rick Smith
• MachBlog, a blogging package from Matt Woodward and Peter Farrell, and based on Mach-ii
• Mango, "a sweet ColdFusion blog engine" from Laura Arguello of asfusion
• See also Brian Rinaldi's Open Source CF list of blog tools
• I welcome additions/corrections/feedback.

There are also a few blogging solutions that, while written in CFML, are not available for download but instead are available as hosted solutions:

• Blog-City, fee-based hosted solution
• BlogFusion, free and fee-based hosted solutions, from Jake McKee
• CFBlog, free hosted solution for the CF community, powered by BlogFusion
• InstantSpot, free hosted solution, from Aaron Lynch and Dave Shuck
• KoldKast, free for download, and also available as a fee-based hosted solution, from Rick Smith
• I welcome additions/corrections/feedback.

• Amazoner, a tool to help a blogger easily recommend books that they like, using their Amazon associate ID
• LiveWriter, a desktop application from Microsoft that makes it easy to publish rich content to your blog
• Post2Blog, an alternative to LiveWriter
• I welcome additions/corrections/feedback.

Additions/Corrections

This is a perpetual work in progress. I definitely welcome additions or corrections to this list. If you have any to offer, you can leave them here as a comment on this blog entry and I'll move them to the list on the site.

BTW, before you offer an update here, please do check the category on the real list. I won't be coming back here to update these blog entries to sync them if I add new items to the real list.

About this series

This entry is part of an ongoing series, sharing each of the 100+ categories and the tools and resources I (and others) have identified. They're designed to answer the questions we hear, like , "does anyone know of tools or resources to help with ...?"

Someone may ask why I'm blogging each of these categories, when they're available online anyway. It's just that, through aggregation and feeds, blogs present a way to reach a wider (and new) audience who may not otherwise come across the list of tools and resources. This also widens the pool of eyes for possible updates to the list. I want it to be as accurate and up to date as possible. I may in the future offer an RSS feed of any updates made to the list.

Otherwise, I hope people will get great value out of the lists, here or on the tools and resources page.

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

It lets you package a set of files into an EXE which when run will show customized text prompts at the start and end, let the user pick the directory into which to extract, run a selected command at the start or end, and even optionally show a license they must agree to.

It turns out it's a feature that was implemented as part of the IE 6 Administration Kit (thus the IE part of the IExpress name), but I just tried it on Vista (with only IE 7 installed) and it worked just fine. Pretty nifty.

For more, see this blog entry at the awesome "Confessions of a Freeware Junkie" site. He also links there to a MS page that discusses the tool in more detail.

Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

The Categories

I've split the list into Resources and Tools. Sometimes it's not clear how best to categories some subjects, such as CFML Frameworks, CFML Engine Alternatives, Monitoring Tools/Services, Testing Tools/Services, Time Tracking/Invoicing Tools/Services, and Web Site Design Repositories, to name a few.

• CFML-Oriented Resources
  • CFML Blog Aggregators (and bloggers)
  • CFML Certification Prep Resources
  • CFML Conferences
  • CFML Documentation/Help Tools and Resources
  • CFML Frameworks/Methodologies
  • CFML Hosting Alternatives
  • CFML Job Resources (Hire/Be Hired)
  • CFML Lists and Forums (finding help)
  • CFML Podcasts
    • Active CFML Podcasts
    • Seemingly Inactive CFML Podcasts
  • CFML-powered Web Sites
  • CFML Resource Sites
  • CFML-specific Search Resources
  • CFML Tuning/Troubleshooting Resources
  • CFML Tutorial/Article Sites
• Tools (CFML and other)
  • Blogging Tools
  • Bug/Defect Tracking Tools
    • Written in CFML
    • Written in other than CFML
  • Captcha Tools/Alternatives
  • CFMAIL Replacement/Enhancement Tools
  • CFML Caching Tools
  • CFML Debugging Tools
  • CFML Documentation/Help Tools and Resources
  • CFML Engine Alternatives
  • Code Generators
    • CFML Code Generators
    • Flex Code Generators
  • Comparison Tools
    • File/Dir Comparison Tools
    • Database Comparison Tools
  • Content Management Systems
  • Database Engines
    • Name brand DBMS's
    • Alternative Databases
  • Database Tools
    • Database Coding Tools
    • Database Comparison Tools
    • Database Monitoring Tools
    • Database Query/Explore Tools
    • Database Testing Tools
  • E-commerce Enabling Solutions
  • Editors/IDEs
    • CFML Editors
    • Other Editors
  • Excel File Processing Tools
    • COM
    • CSV
    • HTML Table
    • Java
    • .NET
    • Office Automation
    • ODBC/JDBC
    • Report Builder
    • WebQueries
    • XML
  • File Upload Tools
  • Forums/Bulletin Board Tools
  • Graphing/Charting Tools
  • HTTP Debugging Proxy Tools
    • Free, General-purpose HTTP Debugging Proxies
    • Free, Firefox-only Proxies
    • Free, IE-only Proxies
  • Image Processing Tools
  • Log Analysis Tools
    • Generic Log Analysis Tools
    • Intrusion Detection
    • SQL Server Log Analysis
    • Web Server Log Analysis
  • Monitoring Tools/Services
    • Application Monitoring Tools
    • ColdFusion Monitoring Tools
    • Database Monitoring Tools
    • Event Log Monitoring
    • Site Monitoring Tools
    • System Monitoring Tools
  • Project Management Tools
  • Regular Expression Generation/Testing Tools
  • Remote Presentation/Assistance/Web Conferencing Tools
  • RSS to Email Tools
  • Server-side Spell Checkers
  • Source Code Control Tools
  • Testing Tools/Services
    • CFML Code Testing Tools
    • CFML Unit Testing Tools
    • Database Testing Tools
    • Load and Application Testing Tools
    • Page Testing Tools
    • Regex Testing Tools
    • Site Security Testing Tools
    • Web Services Testing Tools
  • Screen Capture Tools
    • Still Image Capture Tools
    • A/V Capture Tools
  • Time Tracking/Invoicing Tools
  • Web Services Browsing/Testing Tools
  • Web Site Design Repositories
  • Wiki Tools
  • Wireframing/Prototyping Tools
  • WYSIWYG/Rich Text Editors

Again, I'll be offering here a blog entry on each of the lists as part of this series.

I definitely want to hear of any possible editions or changes. Otherwise, I hope people will get great value out of the lists.

PS Of course, don't miss Brian Rinaldi's excellent list of open source CFML products and projects. I don't limit mine to just things written in CFML (nor indeed just open source), and of course I show more than just tools but also resources. For those interested, I discuss the differences, and indeed how I link to his list often from within mine, in a section of my list. They complement, rather than compete with, each other.

Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

http://www.carehart.org/resourcelists/tools_to_consider/

Actually, it's a list I started back in 2002 and hosted until recently at my old systemanage.com site. While the info there ranges from a couple to several years old (though still nearly all useful), this list was one thing I continued to update.

I just decided this weekend to pull it out to my Carehart.org site. Bookmark it and point others to it when you need to find such tools.

Not competing with Brian Rinaldi's list

I know some will say, "don't you know about Brian Rinaldi's list?", and of course I do and I reference it there. The lists really are different, as I don't limit myself to only open-source tools. In fact, I don't limit it only to tools written in CF. Rather, I list them and tools (and services) written in other languages, but that may be useful to CFML developers. (And while there's some cross-over between my list and his, I'm not interested in just sucking out things he has that I don't. Instead, I point to his matching categories in each of mine, so you can check that out for still more alternatives.)

My categories

• Blog Aggregators
• Blogging Tools
• CFMAIL Replacement/Enhancement
• Code Generators
• CFML Engines
• Content Management Systems
• Database Engines
• Database Query Tools
• E-commerce Enabling Solutions
• Editors/IDEs
• File Upload tools
• Forums/Bulletin Boards
• HTTP Debugging Proxy
• Image Processing
• Load Testing Tools
• Regular Expression Generation/Testing Tools
• Graphing/Charting Tools
• Server-side Spell Checkers
• Source Code Control
• WYSIWYG/Rich Text Editors

Additions Welcomed

I don't claim that it's the ultimate list of all tools in each category. I may even have some glaring ommissions. I welcome additions there, as I repeat several times on the page. I will also be glad to add new categories if suitable.

One of many resource lists I've created

In moving it here, I've placed it in a new Resource Lists page, where I also now point to other such resource lists and compendium-style blog entries that I've long kept (and others still to come). More about them in another entry to come.

Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

AdventNet ManageEngine and other tools

• Network Monitoring
• Application Monitoring
• Password Management
• Help Desk Management
• Storage Management Software
• Network Configuration Management
• EventLog Analyzer
• Wifi Manager
• and much more

Some of these are useful on just a single computer, like the EventLog Analyzer, Wifi Manager, and Bandwidth Monitoring. Also, their application monitoring tools can be a great solution for those not yet doing any monitoring of their CF and other servers (yes, of course, there are many others out there that do that).

Their password management tool is to help multiple folks share passwords to central systems, a common need for groups of folks managing CF and other servers, and naturally their help desk and service center tools, among others, can also benefit a group of CF developers/admins.

SQL tools, for multiple database engines

• Compare and Synchronize SQL Server
• SQLOne Database Search Engine
• Table and Data Migration
• Oracle Migration
• SQL Server Migration
• and more

They have tools for SQL Server, Oracle, DB2, and Sybase, and some of their tools, like the multidatabase search engine and migration tools also support MySQL, Informix, and others.

Testing Tools

Finding the Free Versions

Best of all, and the point of this entry, is that they offer free versions of nearly all these (and other) tools. And just as with the Quest tools I mentioned in the previous entry, these are not trials (though they offer them) but are really freeware editions. Yes, they may be limited in some way, but usually not in ways that will affect nearly all who would try to use them for evaluation or small-scale use.

You can find a list of all the freeware editions of their products here: http://www.adventnet.com/free-softwares-download.html . (And even though the ManageEngine and SwisQL tools have branded URLs, they all lead to the same adventnet.com site, and many of them are offered as freeware on this page.)

When you take a link for any of the products (using any of the links above), look for a link on each product page at the top right labeled "free edition/trial edition", where the link to the free edition will explain its limitations.

Certainly for CF developers who work alone or on small teams, you may find that all the free versions serve your needs just fine. Yes, there may well be open source solutions to each of the problems above, and I'm not discouraging their use.

It's just nice to see yet another company who makes enterprise-class software offering small-scale freeware versions for the kind of audience that seems typical of CF developers.

Certainly, as your needs grow, or for those in larger shops, the commercial versions of these tools then scale up to serve those larger needs. That's what they hope, of course. :-)

If anyone has used any of these tools, please share your experiences. So far I've used the Eventlog Analyzer and Wifi Manager and they were easy to install and use and were quite helpful. I look forward to exploring more of their tools.

"Free Tool Friday"?

Oh, and as for why I labeled this entry "Free Tool Friday", I hope to make this a regular kind of entry. In fact, I'd like to start talking about some of the individual tools that I mention above and in the previous entry, as well as others I have used or may find. It's always tough to set up a periodic contribution like that, meeting expectations, but let's see how I do. :-) If you want to tell me about other tools of this sort that you think others would appreciate, feel free.

Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

The range of free tools is amazing, from tools for working with databases (like Toad or Knowledge Expert for SQL Server, MySQL, or Oracle), to tools for generating load tests for databases (Benchmark Factory), to tools for managing/monitoring Windows or J2EE servers, Active Directory, and lots more.

As you review the list below, note that some of the pages show links to "evaluation" editions but I've only listed pages where I found it to say the tool was free (somewhere on the page, even if it shows an "evaluation download").

It seems some have no time limit at all (true freeware). With some, the license is time-limited and you must return for a new key (see Spotlight® on WebSphere, for instance). With others, you must uninstall and reinstall (see Object Restore for AD, for instance). I suppose it's better than a trial, in that with most trials you couldn't uninstall/reinstall. Others list a duration with no indication of whether you must uninstall (and I found one note on a forum that said you could just register for a new license key for at least one of them).

Some tools are also indicated as windows only (such as Spotlight on MySQL), but I've not paid attention here to which run on what.

The thing is, curiously, they have a page of freeware (http://www.quest.com/free-tools/) , but it doesn't list all that I've found elsewhere on the site. In fact, there's an "a-z" product page (http://www.quest.com/solutions/allproducts--atoz.asp) which indicates which are freeware, but it too does not list them all.

• Spotlight on Windows
• Benchmark Factory® for Databases (for 12 months, some limits compares to commercial)
• Comparison Suite for SQL Server (60 days, renewable?)
• Toad for SQL Server (note that this site offers the current Quest 3.0 edition as freeware, though not listed as such on Quest)
• Toad for Oracle(again, this site offers the current Quest 9.1 edition as freeware, though not listed as such on Quest)
• Toad™ Data Modeler
• Toad® for MySQL (for windows)
• Spotlight on MySQL
• Knowledge Xpert for MySQL
• Spotlight® on WebSphere
• Spotlight® for BEA WebLogic Server
• Storage Assessment Tool
• Discovery Wizard for SharePoint
• Self-Service Web Portal
• Reporter Express (on Windows infrastructure)
• Reporter (also on Windows infrastructure)
• Compliance Portal
• Object Restore for Active Directory (6 month)
• Update Utility for Outlook 2003 (for Exchange)
• Offline Folder Wizard (for Exchange)

There were also some other Quest tools that were free in the past but are no longer, but those old versions can still be found elsewhere (sites like download.com) and though perhaps a couple of years old or more may still be useful:

• JProbe and download

I'll share more about a couple of these later.

Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Common performance problems that the dashboard reports may help to resolve include:

• CPU bottlenecks (and what queries are consuming the most CPU)
• IO bottlenecks (and what queries are performing the most IO).
• Index recommendations generated by the query optimizer (missing indexes)
• Blocking
• Latch contention

The report is an extension of the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. Note that Reporting Services does not need to be installed.

The reports retrieve info from dynamic management views. They don't poll performance counters or require tracing be enabled. They also do not store a history of performance over time. So it's a lightweight (yet powerful) monitoring option.

You can get the extension itself at:

Performance Dashboard Reports

There's also a complete article about how to install it from Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I , at Database Journal (and from which I obtained the image above).