Because I didn’t found this information in one place I’m writing this quick “guide” on how to install PostgreSQL 8.4.x on Debian 5.x “lenny”. Debian lenny stable packages are bundled with Postgres 8.3.x but thanks to Debian Backports the newer Postgres version is available for lenny. Simply do it Add the backports-sources (/etc/apt/sources.list) and update [...]
When enabling search in database its very important to have the appropriate indexes defined to make the queries as fast as possible. If your query looks like this (and the appropriate index is defined) the index can be used by the database (the query planner) even with the LIKE-operator. So fast wildcard-searches are possible … [...]
Today I decided to upgrade my windows internal database on my “VMWare-SharePoint-Development-System”. An upgrade was not possible so I removed the internal database (Microsoft##SSEE) and tried to install the new SQL Server (installation platform is w2k3-server, x86). My development system is a WSS 3.0 SP1 + Visual Studio 2008 environment. Error Clicking through the installation [...]