nerdiness devours me

We’ve partnered with Google to offer our entire 137-year archive for free browsing. Each issue appears just as it did at its original time of publication, complete with period advertisements. It’s an amazing resource that beautifully encapsulates our ongoing fascination with the future, and science and technology’s incredible potential to improve our lives. We hope you enjoy it as much as we do.

The earthquake that killed more than 700 people in Chile on Feb. 27 probably shifted the Earth’s axis and shortened the day, a National Aeronautics and Space Administration scientist said.

(via)

Some of the newest robots to join the US Navy aren’t spy planes or attack drones, they’re house cleaners.

According to Netcraft, 7% of all websites on the internet are now using nginx. This is all the more amazing when you consider that nginx was developed by just one person.

A great MSDN article about how you can squeeze the best performance out of your package dataflows.

Update: I just found some more performance tuning articles while doing some research on other SSIS related stuff.

Optimizing SSIS Package Performance Part 1 and Part 2 describe whats going on under the hood of the two main engines of SSIS: the runtime and the data-flow engine.

Shame on me, I completely missed the new addition to T-SQL in SQL Server 2008, the MERGE command. It let’s you perform inserts, updates and deletes against a table in a single statement. This should come in handy if you’re building data warehouses or have a general need to keep tables in sync.

SSIS: Using a checksum to determine if a row has changed

I just read an interesting article that helps me simplify my incremental load packages by using a checksum of the processed row to determine if the underlying data has changed. While scanning through the comments of the article, I realised that using the simple checksum component recommended in the article could eventually lead to missing a data change. Luckily there is a advanced hashing component available, supporting MD5 and SHA1 hashes.