SQL Server 2008 Standard

SQL Server 2008 Standard is a full featured data platform for running departmental online transaction processing (OLTP) and business intelligence (BI) applications. SQL Server 2008 Standard provides best-in-class ease of use and manageability for running departmental applications.

Standard is ideally suited for the following usage scenarios:
– Departmental deployments
– Small to medium scale OLTP deployments
– OLTP deployments that are not expected to rapidly grow in the future
– Reporting and analysis deployments

The table below provides a high level comparison of the key capabilities between SQL Server 2008 Enterprise and Standard

Minimum Hard Drive Space Requirements for Each Module

Minimum Software Requirements

• Internet Explorer 6 or a more recent version is needed for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help.
• Microsoft Windows Installer 4.5 or a later version.
• If you are installing Microsoft SQL Server 2008 Standard Edition on a server with Microsoft Windows Server 2003 (64-bit) IA64, .NET Framework 2.0 SP2 is required.
• SQL Server Setup will install these required software components:
• .NET Framework 3.5 SP1
• SQL Server Native Client
• SQL Server Setup support files

Multiserver management capabilitie

Backup compression reduces data backups by as much as 60 percent, thereby freeing up staff time for other tasks. The software provides high-scale complex event processing with SQL Server StreamInsight, and it provides multiserver management capabilities.

Manage database applications

Administrators can centrally monitor and manage database applications, instances or servers. The software expands powerful business intelligence tools to all users with SQL Server PowerPivot for Excel.

SQL Server 2008 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications, helping enable effective database management with minimal IT resources.