Adobe Solution Partner

July 29, 2010

(Bollox to) ColdFusion is Slow

Filed under: ColdFusion, Databases, JVM & Java, Performance, SeeFusion — Patrick Quinn @ 12:50 pm
We’ve been hearing the “ColdFusion is slow” nonsense for as long as the platform as been around. (Quick history tidbit: We still have support emails from back when Jeremy Allaire was sending them himself!) In our opinion, whenever someone repeats this tripe, that person is instantly branded a software novice, and, probably, one with an [...]

November 13, 2009

Connecting to SQL Server 2008 (Express) from OS X

Filed under: ColdFusion, Databases, Macintosh — Perry Woodin @ 1:26 pm
This is for anyone having trouble connecting to SQL Server on Parallels from ColdFusion on Mac OS X. Each time I’ve installed a new version of SQL server — be it 2005 or 2008 — it took me a bit a random clicking to get a ColdFusion datasource connected to SQL Server. Here are some tips. Make sure [...]

October 19, 2009

1-Day ColdFusion TNT Audit

One of the advantages of our decades of combined experience is speed—we identify, prioritize and fix the causes of performance and stability problems as quickly and effectively as humanly possible. If you’ve got ColdFusion performance and/or stability problems, and you haven’t yet hired us for consulting, then I’d like to invite you to try our [...]

September 10, 2009

MS SQL Maintenance Plans

Filed under: Databases — Perry Woodin @ 3:51 pm
Maintenance Plans in MS SQL 2005 are a powerful and easy way to manage and backup your databases. In this article, I’m going to walk through 4 basic tasks that we run weekly on a client’s database. You’ll learn how to reorganize indexes, create a full backup (*.bak), shrink your database (shrinks both data and [...]

July 22, 2008

ColdFusion SQL Injection

Filed under: ColdFusion, Databases — Tags: , , , , — Daryl Banttari @ 7:25 am
Seems there’s a lot of ColdFusion sites out there getting hit by an automated SQL Injection attack, which adds a “<script>” tag to varchar fields using a bit of SQL Server t-sql. Many years ago, I wrote a script that would find and automatically <cfqueryparam> queries (which has been at Daryl’s ColdFusion Primer. I’ve dug [...]

January 28, 2008

Incorrect syntax near ‘0′ – Don’t Shoot the Messenger!

Filed under: Databases, SeeFusion — Tags: , — Daryl Banttari @ 9:29 am
ColdFusion 8.0 added the ability to specify a “validation query” that will be run every time a connection is reused in a connection pool. This is useful in cases where database servers or firewalls sometimes drop connections without warning, as it causes a new connection to be made to the database server for the [...]

January 25, 2008

ColdFusion, Sybase, and 0-byte BLOBs

Filed under: ColdFusion, Databases — Tags: , , — Daryl Banttari @ 12:36 pm
If you’re using ColdFusion to access BLOBs stored in a Sybase server, you may have a problem.  Apparently, Sybase severely limits the timeframe wherein you’re allowed to retrieve the actual binary data, which is supposed to be available until the end of the current transaction.  ColdFusion doesn’t pull the backing binary data immediately, and when [...]

October 9, 2007

MONyog – MySQL Monitoring Tool

Filed under: Databases, Performance — Tags: — Patrick Quinn @ 8:33 am
At Webapper, we’re big fans of monitoring tools. You absolutely MUST be able to see what’s going on inside your software in real time. We use MySQL on some of our production servers, and we’ve been using SQLyog as an administration GUI for many years. It’s a great way to run MySQL databases–it’s one of [...]

April 12, 2007

Running SQL Server 2000 and 2005 side-by-side

Filed under: Databases — Tags: — Nat Papovich @ 5:36 pm
There’s a copious quantity of information online about running MSSQL2k and MSSQL2k5 at the same time, but I just did it, and wanted to document my process. First off, you must have SP4 installed on SQL Server 2000. (I’m running the MSDE edition.) Additionally, you have to have that version installed before installing 2005. (I’m using [...]

March 1, 2007

A Database Independent “Next ID”

Filed under: ColdFusion, Databases — Tags: , , — Daryl Banttari @ 10:09 am
A blog entry at: reminded me of how people don’t fully understand the multithreaded nature of ColdFusion with respect to databases when looking for the next ID value for a table. People quite often do something like this in a page: ::CODECOLORER_BLOCK_4:: However, this will give you duplicate IDs when two pages run concurrently. For example, request A [...]
Older Posts »

Server Down?

Maximize Web application uptime by drawing upon Webapper's years of experience tuning and stabilizing many of the world's largest ColdFusion Web applications. Contact us today!