Adobe Solution Partner

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 [...]

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 [...]

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_1:: However, this will give you duplicate IDs when two pages run concurrently. For example, request A [...]

February 26, 2007

How do I search across all columns in all tables in SQL?

Filed under: Databases — Tags: — Nat Papovich @ 8:00 pm
The development practice at Webapper does a fair bit of “version 2″ system development. Our customer has an existing application, built maybe in ColdFusion, maybe in PHP or another scripting language. Maybe in Access forms, maybe as a desktop application. We’ll use it as a prototype for creating a new webified application. One part of these [...]

November 21, 2006

Doing multi-server development with MSSQL? You need Red Gate tools.

Filed under: Databases — Tags: , — Nat Papovich @ 10:33 am
About a year ago, I came across the Red-Gate suite of products for MSSQL. Between then and now, I’ve used SQL Compare and Data Compare about once a week, sometimes more often. These tools are one of those things that, once you have them, you ask yourself, “How did I survive without it?” For example, let’s [...]

October 19, 2006

Upgrading MSDE RTM to SP4

Filed under: Databases — Tags: — Nat Papovich @ 11:54 pm
I’m reformatting my laptop tonight and went to upgrade the Microsoft SQL Server Desktop Edition (MSDE) from the 1.0 RTM to SP4. Damn the dreaded “The instance name specified is invalid” error! I’ve installed this setup countless times and always had to futz, mess, finagle, tweak my setup command to get the darn thing to run. [...]

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!