United States   Change   |   All Microsoft Sites

Home

Web Edition

Usage Scenarios

  • Low-cost database hosting solution

  • Intranet and Internet applications

  • Supporting Web services

Licensing

Per Proc

Cost Effective, Scalable Data Platform for Websites and Web Application Solutions

Microsoft SQL Server 2008 Web Edition delivers an optimal balance of scalability, manageability, and cost for hosted Web sites and applications.

Top Features

  • Low Total Cost of Ownership (TCO)

  • Effective monitoring and management of web customers

  • Maximum server utilization for low-cost operations

  • Flexible platform options for developers

  • Consistently increasing scale-out needs

  • Efficient management of large groups of servers

 

High Availability and Scalability for Web Solutions

Availability

  • Log shipping helps automatically back up data on separate servers or keep multiple read servers online to better handle large amounts of web traffic

  • Utilize this low-cost edition with SQL Server 2008 Enterprise instances through one-way merge and transactional replication to keep multiple nodes in sync

Scalability

  • Helps support for multi-tenancy and customers with growing data needs through unlimited memory and database size

  • Maximize utilization of resources with support for up to 4 CPUs

 

Low Total Cost Of Ownership (TCO)

Automate tasks and policies

  • Help ensure standards and compliance across your environment with Policy-Based Management

  • Use SQL Agent to reduce the amount of time spent on administrative tasks by scheduling and executing events like server backups

Streamlined Administration

  • Use service broker to distribute applications across your servers for easier scale out

  • Automate server administration and application development more easily through Windows PowerShell

Built-in Business Intelligence

  • Use service broker to distribute applications across your servers for easier scale out

  • SQL Server 2008 Reporting Services with unique layout and new visualization to enhancements further enrich the reports and gain insights

Developer Productivity

Improved Productivity

  • Use .NET integration support to quickly write, extend, and publish programs for the web

  • Create desktop applications that can automatically synchronize with a central database

FTS (full text search) offers fast and flexible indexing for keyword-based query of text stored in SQL Server

  • Database publishing tools help seamlessly move files from the desktop to the web

Advanced Programmability

  • Meet a variety of customer needs with advanced data type support

  • With LINQ (Language Integrated Queries), use native syntax language with data-driven apps for queries

Platform Flexibility

  • Increase service offerings by supporting applications in PHP, ASP, and on Windows

  • Use ADO.NET Data Services support to expose data through web services using existing tools and processes

 

Licensing

SQL Server 2008 Web may be used only to support public and Internet accessible

  • Web pages

  • Web sites

  • Web applications

  • Web services

It may not be used to support line of business applications (e.g., Customer Relationship Management, Enterprise Resource Management and other similar applications)

 

Get the Whole Web Platform

The Web Platform Installer (Web PI) is a simple tool that installs Microsoft's entire Web Platform, including Internet Information Services (IIS), Visual Web Developer 2008 Express Edition, SQL Server 2008 Express and the .NET Framework. Using the Web Platform Installer's user interface, you can choose to install either specific products or the entire Microsoft Web Platform onto your computer.  The Web PI also helps keep your products up to date by always offering the latest additions to the Web Platform. Learn more and download at: http://www.microsoft.com/web/

Additional Resources

 

Take the next step

Download the Essential Backpack
TechNet IT Pros Start Here
MSDN Developers Start Here