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 [...]
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 [...]
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 [...]
A blog entry at:
http://www.coldfusionmuse.com/index.cfm/2005/6/10/sqlInterbase
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 [...]
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 [...]
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 [...]
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. [...]
