SQL Server 2008 R2

Get ready for Microsoft's latest release of SQL Server. This is SQL Server 2008 R2. It was formerly code named Kilimanjarao.

There are four editions available: 1) parallel data warehouse, 2) datacenter, 3) enterprise, and 4) standard. There is also a free express version. So I guess that makes 5 versions. The express version now allows you to hold up to 10GB of data in your database. This is up from 4GB in the previous express version.

One new feature in SQL Server is called PowerPivot. This is a self running analytics component. It was previously code named Gemini. There is also a new StreamInsight event processor included with the shipment. This version of SQL Server supports 256 logical processors for SMP.