photoshop

Organize Your Brushes!

When you’ll be moving to hard core photo editing the last thing you want to spend time on is searching for the brushes you need in the multitude of brushes you have loaded. You should get used to loading only the brushes you need, it will save you a lot of time and energy.

code
c#

Generate Objects from Xml Files

Recently I needed some quick method to use objects generated from an existing xml file without bothering to create an xml schema for it. After a few attempts and searching for explanations why a simple task like this wouldn´t work, finally put the steps together:

actionscript

AS3 Performance Optimization

Working on a CPU-intensive app in flash is a challenging experience. It can be wonderful or frustrating, depending on your mindset. Based on my experience with flashCHESS and other intensive applications, I’ll give some tips and ideas on how to get the most out of your flash project.

actionscript

Flash CS4 supports conditional compilation

Conditional compilation allows for blocks of code to be compiled or not based on constants declared in the IDE. It allows the developer to optimize the generated code depending on the target medium.

photography
photography

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.

people
mssql

Searching in all tables and columns of a database

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.

laptop
mssql

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.

code
c#

Converting rootless XmlReader to XmlDocument in .NET

There’s no straightforward way to convert a XmlReader that does not have a root element to a XmlDocument – most of the code samples I’ve seen simply read sequentially through the XmlReader, appending data to a string. Obviously this is inneficient from a performance standpoint.

database3
mssql

Forgot or lost SQL Server “sa” password

To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:

mysql

A very fast introduction on Mysql triggers

Beginning with version 5 of MySQL the development team has added “triggering” to their SQL server engine, to meet the growing demand of users.

database
sql

Get the Current Date for PL/SQL

To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this: