SQL Server 2008 RTM Published

imageSQL Server 2008 has been released to manufacturing. SQL Server 2008 is now available to MSDN and TechNet subscribers and will be available for evaluation download on Aug. 7, 2008. SQL Server 2008 Express and SQL Server Compact editions are available for free download. As previously announced, pricing for SQL Server will not increase with SQL Server 2008.

According to the Microsoft press release, Microsoft Releases SQL Server 2008, "This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications."

More information is available at https://www.microsoft.com/presspass/presskits/sqlserver.

Performance

SQL Server is an industry leader in both scalability and performance.

  • It is the first and only database management system to be proven capable of delivering scalable results on TPC-E, the Transaction Processing Performance Council’s (TPC) newest and most challenging online transaction processing (OLTP) benchmark, with 13 published benchmarks to date. Full results are available at https://www.tpc.org. Results referenced are current as of July 29, 2008.
  • Seven benchmarks are published on Windows Server 2008 and SQL Server 2008 by multiple hardware vendors, demonstrating strong price-performance and performance results, including IBM Corp.’s new No. 1 performance result using SQL Server 2008 on a 64-core System x3950 M2 server. [IBM System x3950 M2, 1250 tpsE, 1311 $/tpsE, available Aug. 30, 2008.]
  • Unisys Corp. and Microsoft set a new extract, transform and load (ETL) performance record by loading 1 terabyte of data in less than 30 minutes using SQL Server 2008 Integration Services. In addition, SQL Server 2008 has proven its scalability in large-scale data warehousing, as demonstrated by its recent 10-terabyte TPC-H benchmark. [HP Integrity Superdome, 63651 QphH@10TB, 38.54 $/QphH@10TB, available Aug. 30, 2008.]

Editions

SQL Server 2008 is available in the following editions:

  • SQL Server 2008 Enterprise. SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications. With this edition, it is possible to consolidate servers and perform large-scale online transactional processing.
  • SQL Server 2008 Standard. SQL Server 2008 Standard is a complete data management and business intelligence platform that provides best-in-class ease of use and manageability for running departmental applications.
  • SQL Server 2008 Workgroup. SQL Server 2008 Workgroup is a reliable data management and reporting platform that delivers secure, remote synchronization and management capabilities for running branch applications. This edition includes core database features and is easy to upgrade to the Standard or Enterprise edition.
  • SQL Server 2008 Web. SQL Server 2008 Web is designed for highly available, Internet-facing Web-serving environments running on Windows Server. SQL Server 2008 Web provides the tools necessary to support low-cost, large-scale, highly available Web applications or hosting solutions for customers.
  • SQL Server 2008 Developer. SQL Server 2008 Developer allows developers to build and test any type of application with SQL Server. This edition features all of the functionality of SQL Server Enterprise but is licensed only for development, test and demo use. Applications and databases developed on this edition can easily be upgraded to SQL Server 2008 Enterprise.
  • SQL Server 2008 Express. SQL Server 2008 Express is a free edition of SQL Server that features core database functionality including all of the new SQL Server 2008 data types, in a small footprint. This edition is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.
  • SQL Server Compact 3.5. SQL Server Compact is a free embedded database designed for developers and is ideal for building stand-alone and occasionally connected applications for mobile devices, desktop Powerful New Business Intelligence Capabilities Join SQL Server 2008s and Web clients. SQL Server Compact runs on all Microsoft Windows platforms, including the Windows XP and Windows Vista operating systems, and on Pocket PC and smartphone devices.

Features for ISVs

For more information, see SQL Server 2008. For key features of SQL Server 2008 of interest to ISVs, see Powerful New Business Intelligence Capabilities Join SQL Server 2008 and SQL Server 2008 To Ship in August, No Price Increase.

You can now download trial versions of SQL Server 2008. Download a free, fully functional 180-day trial version of SQL Server 2008 and SQL Server 2008 Feature Pack today. To help make the most of your evaluation, you will receive five e-mails during your evaluation period that, depending on which download option you select, contain resources specifically designed for IT professionals and developers. Before downloading and installing SQL Server 2008, click here to View system requirements.

Resources for IT Pros - SQL Server 2008

Resources for Developers - SQL Server 2008