SQL Server, the king of middle weight databases, has to be fully accepted yet by the big boys as admitted by Bob Muglia who is the president of the Server & Tools division of Microsoft Corporation. Muglia has said in one keynote at the PASS conference of users held in Seattle on Monday that extremely large data warehouses and really large scale up apps are last of the high end problems that have remained for the SQL Server.

One year ago, Microsoft had announced its plans for adding heft to the SQL Server. Microsoft also added some detail on Monday as it announced the two new versions when the SQL Server 2008 R2 was shipped by the mid of coming year.

One is the Datacenter edition which is aimed at those companies that need to scale up their online transaction processing (OLTP). It is used in conjunction with the Windows Server 2008 R2, and this datacenter version supports up to 256 of the logical processors (which are equal to the physical CPUs multiplied by number of threads which they can support) and also the thing that Microsoft claims to be unlimited virtualization. This edition is also supporting the complex event processing (CEP).