The Hubble Deep Field: The Most Important Image Ever Taken

In 2003, the Hubble Space Telescope took the image of a millenium. This is truly an amazing video. 
Here is more explanation.

Free Virtualizers (VMWare Alternatives)

InnoTek VirtualBox is a family of powerful x86 virtualization products. It is the only professional solution that is freely available as Open Source Software under the terms of the GNU Public License (GPL).

moka5's LivePC Engine LivePCs contain a complete PC software environment — operating system and applications — that users can create for themselves and share with others. LivePCs are played using the moka5 LivePC Engine™ and are created using tools inside the LivePC Engine. This is a portable virtual machine, which you can run from your USB-Stick!

Notepad Alternatives

Here are some Notepad alternatives, which you can also use without installation, i.e. compatible as portable application...

Note-X-Pad (Source-Code is also available)

Notepad++ (also as portable)

PSPad (PsPad does not require installation, wide range of languages)

Scite (A free source code editor for Win32)

Notepad2 (Yet another Notepad replacement)

NoteTab Light (A slimmer version of the award-winning NoteTab Pro)

Oracle SQL Developer is ready for free download

Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can access not only Oracle-DB, but also other SQL-vendors such as MySQL, MS SQL Server and MS Access.

Download here!

Creating a Delimited List from Table Rows in SQL Server 2005

DECLARE @rechtsfolgeList varchar(100)

SELECT @rechtsfolgeList = COALESCE(@rechtsfolgeList + ', ', '') +
CAST(R.Recht_Code AS varchar(5))
FROM dbo.Rechtsfolgen R INNER JOIN
dbo.Verfahren_Rechtsfolge VR ON R.Code = VR.Ref_Rechtsfolge
WHERE VR.Ref_DKopf = 'BM-06-0346'

SELECT @rechtsfolgeList
 

Case-Sensitive SQL Searches

These are two possible coding examples for MS SQL-Server, to make a case-sensitive search.

You can either use CAST function, which is available fo SQL-Server down to MS SQL v7

SELECT * FROM TABLE_NAME WHERE CAST(mitarbeiterid AS varbinary(40)) = CAST('bbe' AS varbinary(40))

Or use the COLLATE function (available after MS SQL 2000) with an appropriate string pattern;

SELECT * FROM TABLE_NAME WHERE mitarbeiterid COLLATE Latin1_General_BIN LIKE '%[a-z]%'