Flash CS4 supports conditional compilation

Conditional compilation allows for blocks of code to be compiled or not based on constants declared in the IDE. In the simplest form, think of it as of a more advanced version of the old “Omit Trace Actions” Publishing option. It allows the developer to optimize the generated code depending on the target medium (e.g. Web vs AIR) or the development phase (i.e. when compiling an app for debugging, the developer may want to switch on more warning traces or display additional info on screen).

RAW Heavyweights: Lightroom, DxO and Capture One

With the new releases from Adobe, DXO Labs and Phase One, I’ve decided to put to the test some of the top RAW processors. These programs represent the high-end segment of the RAW converters, since they are all geared (or at least marketed) as tools for professional photographers. This doesn’t mean that Bibble, Silkypix or ACDSee Pro are not capable, it’s just that they have a different market.

Searching in all tables and columns of a database

I was forced recently to do some maintenance and bug fixing on an aging .NET-based CMS. Most of the problems were in the SQL Server database, with lots of corrupted entries. The most frustrating thing however was that at times I didn’t even know where to find the entries. Try finding some specific strings in a database with a hundred tables, each with many columns (poorly named, obviously) and tens of thousands of records — it’s like finding the proverbial needle in the haystack.

Search and Replace tool for MSSQL

Every now and then I come across some bad practices that needs repairing. This time the “no-no” was in a database tables. I had to change hard-coded links in quite a few tables. Replacing 10,000 absolute URLs spread across the database can be a huge headache, so I decided to work smart, not hard.

Converting rootless XmlReader to XmlDocument in .NET

MS SQL has the ability to retrieve data as XML by using the “FOR XML [RAW | AUTO [ELEMENTS] | EXPLICIT]” parameters, which is very useful especially when used in a web service that communicates with a Flash / Flex client as the results don’t have to be converted, but just output to the client.

A very fast introduction on Mysql triggers

I started to work on a pet project for tracking deleted/pending domains and after starting development I was facing a big problem: How to do the data validation directly from MySQL ?