software
MS SQL Server 2008 R2 error log growing rapidly
· ☕ 1 min read
MS SQL server 2008 R2 was spamming the error log with the following two messages (got around 50GB of them in 4 days). An exception occurred while enqueueing a message in the target queue. Error 15517, State 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

MS SQL drop column with default constraint
· ☕ 1 min read
The following MS SQL script will generate MS SQL statements to drop a list of columns with default constraint for a certain table. Need to change table_name and list of columns, as applicable. Statements will be generated only if required.

List all valid email addresses in Exchange 2007
· ☕ 1 min read
You may need these to configure your 3rd party antispam software/appliance. There were lots of articles on the internet with complicated solutions, which did not work for me. Here a Powershell one-liner for Exchange management shell.

Acronis True Image 2010 for 30$
· ☕ 2 min read
Everybody is trying to survive on the market these days. Acronis is no exclusion. Having made a partnership agreement with Seagate, they actually give away the limited version of Acronis True Image along with Seagate drives. This means FOR FREE!

G6 + Everest 5.02 = BSOD ?
· ☕ 1 min read
As you probably remember by previous articles, we have some HP G6 servers to play with. And I was quite surprised to see them fall periodically after Everest is launched. Strangely enough, when launched on a randomly picked server, around 33% Everest causes a BSOD.

Firefox 3.5 hangs under Windows 7 RC
· ☕ 2 min read
I'm a keen fan of Mozilla Firefox web browser and was very excited when a new version came out. Having installed that on my Vista work PC and found a real speed boost, I rushed to upgrade it at home... only to find it hangs at startup on Windows 7.