SQL Server 2008 R2 is RTM

A co-worker of mine told me the other day that SQL Server 2008 R2 had gone gold. A bit of research revealed that Ted Kummert, senior vice president of the Business Platform Division at Microsoft apparently announced the RTM status in a conference call. Customers will be able to get this latest version of SQL Server as of the 13th of May and MSDN adn TechNet will be able to download it the 3th of May. The free express edition can already be downloaded. Even though official prices haven’t been revealed yet, it is expected that they will rise by 15 to 25% in comparison to R1. Read more

> 1 TB in < 30 min

Last year, with the introduction of SQL Server 2008, Microsoft broke the existing ETL World Record, doing a load of data using SSIS. Over 1 TB of data was loaded from flat files in less than 30 minutes.

At the time the team promised a white paper on the subject, which is now available on MSDN. It’s quite an interesting read (even for people like me, who don’t normally work with DWHs of that size).

SSIS Custom component and its performance

Something I’ve also been wondering about and now know the answer to. It’s a shame I have no knowledge of C++.