Phil Cruz

BlueDragon goes Open Source

2008-03-11T07:34:00.000-07:00

Yesterday, Vince from New Atlanta announced on his blog that they are releasing BlueDragon/J2EE as open source. You can read more details from the faq but the gist of it is that it's a fully functional CFML engine that you can use for commercial situations for free (with limitations as far as distribution). This is great news for the CF community. Maybe this will breathe new life into

It's just like being there

2007-11-05T08:45:00.000-08:00

If you are at all computer savvy, you are probably often asked by those not so savvy to help out with their computer problems. It can be quite frustrating trying to troubleshoot someone's system over the phone. Trying to have them navigate the start menu is hard enough. If you need them to open a command window, fuggetabowtit! It's a lot easier if you can just remotely access their computer to

Deploy multiple db scripts to multiple servers

2006-06-23T23:00:00.000-07:00

After doing some code cleanup on some stored procedures, I needed a efficient way to deploy the scripts to multiple servers/databases. I had 20 different scripts and though that is not a huge amount I still wasn't looking forward to opening each file in Query Analyzer and executing for each server. Google saves the day again and led me to a DOS command that fit the bill perfectly. (Note that

Great (free) backup service

2006-06-05T07:50:00.000-07:00

PC Magazine just featured this new backup service. They give you 2GB of backup for free. The interface is clean and simple and there are no ads or popups. If you're looking for a backup solution you should definately check out Mozy backup.

Free data models! Get yer free data models here!

2006-06-04T19:39:00.000-07:00

This resource was mentioned the other day on the CFCDev list. It may come in handy some day so I'm posting here for future reference. Check out the Free Library of Data Models.

More Intelligent Backup and Restore for SQL Server 2005

2006-04-19T10:58:00.000-07:00

Backing up and restoring databases is easy enough using Enterprise Manager or Management Studio, but sometimes you need to script these kinds of jobs. A while back I came across a More Intelligent Backup and Restore and it made life a lot easier. Unfortunately, the scripts aren't compatible on SQL Server 2005 due to some changes to schemas and a couple of system stored procedures. It wasn't

Save Stored Procedures to Text Files

2006-03-10T10:36:00.000-08:00

The other day I was looking for a way to save all the stored procedures in a database to text files. This would allow me to check in the SPs to source control as well as compare differences of the SPs from different database enviroments. I found some VBScript code that does the job at SQL Server Central.

Run BlueDragon.NET6.2.1 on .NET1.1 and .NET2.0 side-by-side

2006-02-07T08:22:00.000-08:00

If you are running an application on BlueDragon.NET 6.2.1 you might want to run that application on both the 1.1 version and the 2.0 version of the .NET framework. The IIS administrator already has a nifty interface that allows you to switch between the 2 versions. Right-click on a website, choose Properties, then click the ASP.NET tab. If you originally installed BD.NET under 1.1, it won't

Stored Procedure Running Slower Than Query (aka What does a parameter smell like?)

2006-01-29T19:41:00.000-08:00

A colleague at work came to me with an interesting problem that he was at loss to figure out. Turns out a stored procedure he was working on was running like 10x slower than if he ran it as a regular query. I verified the ad hoc query and the SP were indeed identical and I could reproduce the performance issue. It did seem quite strange for there to be such a difference in execution times. A

Got my free iPod mini!

2005-04-28T21:13:00.000-07:00

A couple of months ago I saw this post about a free iPod mini through Citibank. Well, I'm happy to report that yesterday I received it as promised. I'm glad to confirm that some of these free programs are legit. Unfortunately, the free Mac mini program hasn't shown any updates for months. I'm not holding my breath but I'm still optimistic...

sp_generate_inserts

2005-03-20T20:13:00.000-08:00

Recently, I was doing some development where I created some new tables in the MSSQL database. I completed the task and needed a way to promote the tables (with data) to the QA database and eventually to production. Although it's certainly posssible to do this with DTS I wanted a simple text-based sql script to do the task as we have limited ability to create DTS jobs on production and it's

CFEverywhere Part 2

2005-03-15T22:26:00.000-08:00

Part 2 of the CFEverywhere article series is now online. This article describes how you can package a Derby database with your CFEverywhere application. You can check it out at http://www.sys-con.com/story/?storyid=48655&de=1

We don't need no digest mode! ( or BlogLines email subscriptions)

2005-02-24T20:59:00.000-08:00

The CFCDev mailing list recently switched to using a new mailing list software. Unfortunately, this new software doesn't support digest mode and it was a disappointment to those that well, want to subscribe in digest mode. If you use BlogLines you should be aware that it supports "email subscriptions". Email subscriptions are good for mailing lists that don't provide an RSS feed or in this

CFEverywhere preso for Mid-Michigan CFUG via Breeze

2005-02-07T15:15:00.000-08:00

I've been asked by the Mid-Michigan CFUG to talk about CFEverywhere on Tues Feb 8 at 7:30pm EST. Since I'm not anywhere near Michigan I'll be doing this via Breeze. This will be my first Breeze preso so it should be interesting. If you want to join in via Breeze there are a limited number of slots available. Contact Troy Murray (troy.murray at gmail dot com) to sign up for access. Here's the

Free CFC.Doc and Tracking Tools

2005-02-01T08:23:00.000-08:00

I recently posted how I'm trying to get a free Mac Mini. As an incentive for people to participate, I'm offering a free license of either CFC.Doc or Tracking Tools(Standard) to anybody that helps me get the Mini. Once I see your referral is confirmed I'll send you the software. Two people can pool together and get Tracking Tools(Professional) or three or more to get the Enterprise version.

No such thing as a free lunch?

2005-01-31T15:15:00.000-08:00

As we all know, there's no such thing as a free lunch, but fortunately there are free Mac minis! Along the lines of the free iPod offers you may have seen, Gratis.com is running a free Mac mini campaign. In case you're skeptical these programs aren't on the up and up, check out this article on Wired that confirms these are legitimate programs. I'm more of a Windows guy but when I read of the

Portable CFML Development Environment

2005-01-20T11:48:00.000-08:00

Now I wouldn't exactly call myself a "cheap stingy bastard" but I like a good deal when I see one. So, when I saw a great deal on a 64MB mini USB drive I just couldn't resist. The first thing I did when I got the device was to install Portable Eclipse (with the CFEclipse plugin, of course). Well, what good is a CF IDE if you don't have a CFML server to develop against? So I created a

CFEverywhere Part 1

2005-01-18T22:47:00.000-08:00

Dick Applebaum and I have been writing a series of articles about CFEverywhere, how to package CFML applications to run on the web, CD and/or on the Desktop. The articles will appear in ColdFusion Developer's Journal and part 1 has just come off the press. I hope you find the articles interesting and informative and that more developers will explore CFEverywhere as a deployment option. In

CFC.Doc does PDF

2005-01-18T13:45:00.000-08:00

I just posted a new build of CFC.Doc. This latest version adds PDF as a target output format. It also adds a "browse" function that displays a tree control to allow you to easily choose your directory of CFCs. You can see an example of the output by checking out the PDF of the Mach-II API documentation listed in the examples.

First CFUG talk

2005-01-03T13:03:00.000-08:00

This Wednesday (1/5/2005)I'll be presententing at the San Diego CFUG. I'll be speaking about CFEverywhere, explaining how to package CFML applications to run from CD and/or the Desktop. If you're not able to attend in person, no worries. I plan to make the slides available online.

Traffic quicksearch

2004-12-23T10:08:00.000-08:00

If you haven't discovered how to use Smart Keywords or quick searches with Firefox you are missing out on a pretty cool feature. What's also cool is that Yahoo Maps now offers real-time traffic maps. This is very handy if you live in So. Cal (or No. Cal or anywhere for that matter!). To create a quick search for traffic in Firefox: 1. Go to Bookmarks>Manage Bookmarks... 2. Click on the

CFC.Doc build #59 - file header comments

2004-12-22T08:50:00.000-08:00

By request, I haved added support for file header comments in CFC.Doc. Comments can be of two types: javadoc or custom. If you use the javadoc convention of comments using @author and @version, this information will be parsed and displayed. If you use the custom option, the comments will not be parsed for data but will simply be displayed in full. Check the examples section for,well, examples.

Announcing CFCDoc v 1.0

2004-12-10T10:35:00.000-08:00

I'd like to announce a new tool I've been working on, CFCDoc. CFCDoc is a tool for generating html documentation files of CFCs. For example, point it at your Mach-II directory and you can generate docs that you can use in CFStudio or Eclipse. There's a downloadable demo so please take it for a spin and let me know what you think.

BlueDragon 6.1 - It's Getting Better All the Time

2004-11-29T13:56:00.000-08:00

It's been a few months since New Atlanta released BlueDragon 6.1. I wrote a product review about it for ColdFusion Developer's Journal. The article is available online at http://www.sys-con.com/story/?storyid=47201&de=1.

File download bug with Netscape 7

2002-12-16T16:49:00.000-08:00

I just ran across a bug with NS7 where it appends the file extension of the template to the end of the filename to be downloaded. So if you have a download.cfm template like and the filename is "installer.exe" it will appear in the save as