In-memory analysis is clearly the big headline in the "R2" release of Microsoft SQL Server 2008, announced last week and expected in the first half of 2010. But the upgrade also promises master data management functionality, stream processing capabilities and improved datacenter administration. Current licensees will be able to sample it all in a Community Technical Preview (CTP) to be released this month. The three big themes behind the upgrades are pervasive insight, IT efficiency and dynamic development. But to dive into the details, here's a synopsis of what to expect in the next version of Microsoft SQL Server.