Neat SVN Monitoring Tool - CommitMonitor

Just found this neat tool for monitoring my svn repo commits, thought I'd pass it along. In the past I have used Trac's rss feed but for quick monitoring without the need to install and setup Trac, CommitMonitor does a superb job.

For more info and to download it checkout their site at http://tools.tortoisesvn.net/CommitMonitor

Reverse DNS Lookup in ColdFusion

I've began building an internet services utility component for doing things like DNS lookup in ColdFusion. It's basically a wrapper to simplify all the JAVA integration calls.

Although I can technically do the following to do a dns lookup from an ip address natively in ColdFusion:

<cfscript>

inetAddress = createObject("java","java.net.InetAddress")
theHost = inetAddress.getByName("209.200.101.202").getHostName();

</cfscript>

The preceding code can take up to 5 seconds if there's no dns record for the given ip address. In most applications that wait is not exactly acceptable! The InetUtils.cfc uses a java jar file from dnsjava.org that speeds up the lookup even when there's no dns record.

Here's a sample code on how to use it, it also returns all dns records found for the ip address as an array, where the previous code only returns one record:

<cfscript>

inetUtils = createObject("component","InetUtils").init();
dnsRecords = arrayNew(1);

dnsRecords = inetUtils.reverseDNS("209.200.101.202");

for(x = 1; x LTE arrayLen(dnsRecords); x = x + 1){
writeOutput(dnsRecords[x]);
}

</cfscript>

I'll be adding new methods like dns lookup and any other methods that fit this library later on. If you have any ideas or requests, I'd be happy to hear it.

Red-Gate Software: SQL Prompt Tool

Last week I discovered this really neat application from Red-Gate Software, makers of some really nice MSSQL tools such as "SQL Compare" and "SQL Data Compare". They have released a free third party add-on that adds Intellisense® style auto-completion to Microsoft SQL Server editors.

This tool runs on the background and works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32

Features include :

  • Table/View name completion
  • Column name completion
  • Stored procedure name completion
  • USE completion
  • JOIN/JOIN ON completion
  • Auto-uppercasing of keywords
  • Auto-popup after keywords

You can get more info and download it from Red-Gate Software's Site

BlogCFC was created by Raymond Camden. This blog is running version 5.003. Powered by ColdFusion Server v8,0,1,195765.