Enterprise Data Management

High availability, business intelligence capability, and a performance gain of 40 percent are why Microsoft runs its largest and most critical application on SQL Server 2005.

In this webcast, we explore the key differences between the four main SQL Server 2005 Editions—Enterprise, Standard, Workgroup, and Express—and help you determine which edition is right for you.

Microsoft continued to gain ground with 25 percent growth in the relational database management systems market. The RDBMS market as a whole grew fairly well and, with the strongest growth among the leaders, Microsoft has steadily narrowed the gap.

DPM 2007 protects SQL Server databases every 15 minutes, but can restore not only to each of those 15-minute marks, but also enable administrators to recovery to any transaction point, or even to the very latest committed transaction following an outage.

Availability. Investments in high-availability technologies, additional backup and restore capabilities, and replication enhancements enable enterprises to build and deploy highly reliable applications. Innovative high-availability features such as database mirroring, failover clustering, and enhanced online operations minimize downtime and help to ensure that critical enterprise systems remain accessible.

Scalability. Scalability advancements such as table partitioning, snapshot isolation, and 64-bit support enable you to build and deploy the most demanding applications using SQL Server 2005. The partitioning of large tables and indexes significantly enhances query performance against very large databases.

Security. Enhancements such as "secure by default" settings, database encryption, and an enhanced security model help provide a high level of security for your enterprise data.

Manageability. A new management tool suite, expanded self-tuning capabilities, and a powerful new programming model provide database administrators with flexible control for day-to-day database operations. Enhancements to SQL Server Profiler and other tools also help database administrators tune their servers for optimal performance. These enhancements help enable database administrators to focus on high-value tasks such as database architecture and spend less time on routine database operations.

Interoperability. Technology advancements delivered with SQL Server 2005 enable you to maximize your investment in new and existing systems by integrating and connecting disparate applications and databases within your extended enterprise. Through deep support for industry standards, Web services, and the Microsoft .NET Framework, SQL Server 2005 support interoperability with multiple platforms, applications, and devices. SQL Server is tightly integrated with other Microsoft products as well, from Microsoft Windows Server, to Microsoft Visual Studio, to Microsoft Office, enabling your organization to save time and money by using technology that works well together.

Barclays Capital is one of the stellar success stories in investment banking of recent years. Read how Barclays Capital achieved guaranteed reliability and performance for their new fixed-income solution using SQL Server 2005.

Hilton Hotels needed to develop a forecasting system to improve its business analysis process by establishing more accurate pricing and financial planning. Read how Hilton Hotels utilized SQL Server 2005 as the Enterprise Data Management foundation for their solution.

As the largest health service provider in Israel, Clalit Health Services is constantly looking for ways to enhance health care delivery to its 3.7 million insured members. Read how SQL Server 2005 data mining helps Clalit preserve health and even save lives.