Upgrading to SQL Server 2005
“We immediately found SQL Server 2005 to perform at least 20 percent faster than SQL Server 2000.”
— Dr. James Holt, VP of Server Development, Townsend Analytics
Make the move to SQL Server 2005 to open up new possibilities and opportunities for SQL Server administrators, developers, and information technology (IT) decision makers in both enterprise and midsize organizations. With up to 35 percent faster transaction processing, advanced business intelligence solutions, and enhanced developer productivity, SQL Server 2005 optimizes your IT infrastructure for growth and helps align IT with business objectives.
On This Page
|
Top ResourcesBusiness and IT decision makers adopt SQL Server 2005 because it optimizes IT environments, delivering a more secure and reliable data management and analysis platform. Learn more by using the following resources.  | Simplify the Upgrade Process with the Upgrade Advisor
Download the Upgrade Advisor tool to analyze your SQL Server 7.0 and SQL Server 2000 database servers in preparation for SQL Server 2005. Get reports that identify features and necessary configuration changes that will affect your database upgrade process. |
| | | | Upgrade Resources | Watch the 4 New Webcasts with Upgrade Support For Your Infrastracture
Increase your upgrade skills and technical knowledge with four new SQL Server 2005 webcasts that deliver valuable information and tools to aid you in upgrading your current SQL Server environment. Register now to watch these webcasts and help you take advantage of all-new features and enhancements in SQL Server 2005.
|
 | Streamline Your DTS Conversions in SSIS
SQL Server Integration Services (SSIS) brings power and performance to SQL Server 2005 well beyond the capabilities of DTS. To streamline these conversions during your upgrade, DTS xChange by Pragmatic Works Software offers a fast and easy way to manage higher quality DTS to SSIS conversions.
|
 | Upgrade from MSDE to SQL Express
Deliver higher performance for your applications, upgrade from MSDE to SQL Server 2005 Express Edition. SQL Server has a larger maximum database size, no workload governor, built-in SQL Server 2005 Reporting Services, SQL Server 2005 Management Studio Express. |
|
|
Case Studies |
 |
AIM Healthcare
"Adding things like a reporting solution or OLAP services, the costs just kept building up on the Oracle side while they remained the same on the SQL Server side."
- Adam Solesby, Director of Strategic Development, AIM Healthcare Services |
 |
Department Of Employment and Workplace Relations
"We originally were looking at SQL Server 2005 for the increased throughput and increased memory footprint, but now that we are starting to work with it, we keep finding more and more ways it can help us."
- Brynten Taylor, Director, Technical Services, Dept. of Employment and Workplace |
 |
National Bureau of Asian Research
"We continue to be impressed with how easily we can evaluate the features of SQL Server 2005, implement them in a production environment, and integrate our services on more than a superficial level."
- Erick Thompson, Senior Programmer, The National Bureau of Asian Research |
 |
Barclays Capital
"The built-in reliability and latency guarantees of TAPS, based on SQL Server 2005, means Barclays Capital traders have up-to-date information on which to base their decisions."
- Robert Byrne, Director, TAPS Development Team, Barclays Capital |
 |
ServiceU Corporation
“When we turned to SQL Server Database Mirroring we saw the opportunity to save the $100,000 that a hardware solution would have cost, while avoiding the potential integration problems posed by third-party software solutions”.
- David P. Smith, Chief Technical Officer, ServiceU
Read more case studies from other enterprise companies that rely on SQL Server 2005 to power their data management and analysis solution.
|
| | | | Featured Case Study
"With SQL Server 2005 we are able to maintain a quality of service that is unsurpassed in our industry."
— Fabio Catassi, CTO, MSC
The Mediterranean Shipping Company has found that the move from SQL Server 2000 to SQL Server 2005 has increased its agility in responding to customer needs, simplified its database administration, provided faster query responses, and, in combination with Microsoft Visual Studio 2005, given it an even better development platform.
|
|
Building Your Business Case
Fortune 1000 corporations are taking advantage of the enhanced features in SQL Server 2005 to optimize their IT environment and accelerate business growth by doing the following:
| • | Minimizing business disruptions by increasing availability and scalability while significantly lowering IT costs | | • | Gaining deeper business insight through richer end-user analytics and reporting tools that result in a faster return on investment | | • | Accelerating the development time of line-of-business applications by up to 40 percent with Visual Studio 2005 and Microsoft .NET integration, including 50 to 70 percent code reduction for most scenarios | | • | Reducing data management complexity and ease of manageability |
|
Benchmarks| • | Dell and Microsoft Beat the $1 per tmpC Threshold for TPC-C
The Transaction Processing Performance Council has published benchmark results highlighting SQL Server 2005 that have broken the $1 price-per-transaction ($/tpmC) barrier—an epic milestone. See the results of how Microsoft and Dell broke this barrier with SQL Server 2005 Standard Edition on an Intel dual-core Xeon CPU. |
|
Take a Closer Look| • | SQL Server 2005 Features at a Glance
Get an overview of several key enhancements in SQL Server 2005, focusing on enterprise data management, developer productivity, and business intelligence. |
| • | SQL Server 2005 Features Comparison by Edition
If you’re upgrading to SQL Server 2005, you need to make sure that you upgrade to the appropriate edition. Read about the SQL Server 2005 editions and their differences to find the right one for your database needs. |
|
Additional Resources| • | Upgrade Your Skills to SQL Server 2005
Planning new database development projects in the year ahead? Tune into these TechNet webcasts to learn about new features and issues that you should watch out for during your upgrade process. |
| • | Streamline Your DTS Conversions in SSIS
SQL Server Integration Services (SSIS) brings power and performance to SQL Server 2005 well beyond the capabilities of DTS. To streamline these conversions during your upgrade, DTS xChange by Pragmatic Works Software offers a fast and easy way to manage higher quality DTS to SSIS conversions.
|
| • | SQL Server White Papers
To improve your understanding and to research issues about SQL Server, explore these white papers and other resources. |
| • | Support for SQL Server 2005 on Windows Vista and Windows Server "Longhorn"
This document describes the support for Microsoft SQL Server 2005 on Microsoft Windows Vista and Microsoft Windows Server "Longhorn," including known issues installing and running SQL Server 2005 on the February 2006 Community Technology Preview (CTP) release of Windows Vista and Windows Server "Longhorn." |
|
| | | | | | | | |
