I'll be speaking about ColdFusion security and risk management at cf.Objective() in Minneapolis in April.

The speakers have been announced and the line up is fantastic. Good to see fellow Australian Mark Mandel speaking and many of the best known people in industry such as (in no particular order) Sean Corfield, Peter Bell, Tom Burleson, Charlie Arehart, Jeff Tapper, Raymond Camden, Rob Rusher and many more. Makes travelling the 14,000 or so kms (from Sydney) to get there well worth it.

The draft 2010 schedule is up now.

ColdFusion has a large number of date functions but not one to see if a past or future date occurs when daylight savings is in effect. However it is possible to find this out using a little Java code.

[More]

My current projects are coming to a close and I'm available from the last week of February onwards for 4 days a week. Anyone out there that could use my skills?

I have 10+ years CF experience, 5+ years Flash experience and 2+ years of Flex experience (inc commercial Flex 3 apps).

I'm a Adobe premium partner, an Adobe certified instructor and an Adobe certified developer in Flex, Flash and ColdFusion.

For more info see my linked in page: http://www.linkedin.com/in/justinmclean

You need to be careful with references to objects or structs. I was looking at some old code the other day and I noticed I hadn't var'ed some local variables - very naughty of me. So I fixed the code but it no longer worked.

[More]

In ColdFusion Securing Databases (part 1) we looked at restricting what sql statements can be run with a datasource and partitioning applications to use multiple datasources and multiple users to improve security. In this article we'll look at setting the permissions on the database tables.

[More]

The most common problem I've run into with applications slow performance is the lack of indexes on the databases. Sometimes this is just because the application ran fine with a small amount of data but now is working off a larger amount, or the application is being used in unexpected ways (running less 'common' queries run more often), or the production environment doesn't have the same indexes as the development environment or worse case the indexes were never created in the first place.

Without indexes queries can take seconds with indexes they take milliseconds!

[More]