Microsoft SQL Server full-disclosure plan tags:Microsoft SQL Server
Microsoft on Tuesday (11 / 9) at the PASS Summit, SQL Server to expose the full range of planning, including display of the real SQL Server 2008 R2 Parallel Data Warehouse installation, the introduction of the key advantages of the device with a program (Microsoft Critical Advantage Program), and released the next generation, code-named Denali preview of SQL Server technology to provide the regulatory functions of SQL Server in the cloud, while a relaxation of SQL Server Experts Microsoft Certified Master (MCM) of the regulations.
SQL Server 2008 R2 Parallel Data Warehouse is Microsoft's first data warehousing capabilities with high-end devices, can provide a large number of parallel processing architecture, hundreds of TB and enterprise level performance, and claimed to be on the market the most complete data warehouse platform, with data From the extraction, conversion, loading the destination into the ETL functionality and embedded business intelligence (BI), master data management (MDM) and real-time data warehousing capabilities.
The largest SQL Server 2008 R2 Parallel Data Warehouse unit can handle more than 500TB of user information, can support up to 40 compute nodes, the information flow and query performance is the standard SMP, respectively 10 times and the data warehouse 100 times.
Microsoft said there were 16 customers in SQL Server 2008 R2 Parallel Data Warehouse technology preview, and compare existing data warehouse installations, the query performance of the product on about 40 to 200 fold improvement.