The Latest Reason I Hate SQL Server

When is a copy of a database not a copy of a database? When it was made using SQL Server's "copy database" feature, that's when.

Having run into this before I should have known better, but I needed to make a copy of a production database for testing purposes. Normally I'd take a backup and restore it to a different database, but I noticed SQL 2005 has a "copy database" function I hadn't seen before. So I figured I'd give it a try.

Totally and utterly pointless. It looks like it copies the database until you start looking at all the fields using auto-increment IDs in your old database that magically aren't still auto-increment IDs in the "copy" of the database.

Thanks for another worthless feature Microsoft. I only use SQL Server under duress anyway, but why can't they get even such basic things like "copy database" right? Inexcusable.

Microsoft Word Sales Face U.S. Ban — InformationWeek

An appeals court on Tuesday ordered Microsoft to stop selling Microsoft Word 2007 and other Office 2007 products by Jan. 11 because the software infringes on a patent held by a Canadian company. The judge also hit Microsoft with a $290 million fine.

Buy MS Office while you can! Or save your money and reclaim your freedom by using OpenOffice.org instead. 🙂