United States   Change   |   All Microsoft Sites

Home

Standard

Usage Scenarios

  • Small to medium scale online transaction processing (OLTP) applications

  • Business intelligence requiring basic reporting and analytics

  • Departmental applications requiring best-in-class manageability and ease of use

   

Complete Data Platform for Departmental Applications

SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications

Top Features

  • SharePoint Integration

  • Policy-Based Management

  • Excel 2007 and Visio 2007 Add-in Support

  • Automatic Corruption Recovery from Mirror

  • Comprehensive Set of Data Mining Algorithms

  • Auto-generate Staging and Data Warehouse Schema

Ease of Use

Reduce operational and development overhead with an easy-to-use database platform for small- to medium-scale database solutions.

Ensure business continuity

  • Facilitate server upgrades with stable and more predictable query performance

  • Ensure business continuity with enhanced Database Mirroring including automatic page repair and improved performance

 

Store any information

  • Build Spatial capabilities into your applications with new geography and geometry data types

  • Store binary data in the file system while preserving it as an integral of the database with FILESTREAM

 

Manageability

Manage departmental applications effectively with intuitive management tools and automated administration.

Manage by policies

  • Ensure compliance with system configuration policies and simplify administration tasks with Policy-Based Management

  • Use Performance Data Collector to troubleshoot, tune, and monitor SQL Server 2008

 

Reporting and Analytics

Gain insights and enhance decision-making through built-in analysis and reporting technologies.

Deliver relevant information

  • Streamline the development of Analysis Services solutions with new cube design tools

  • Improve the quality of data with the new Integration Services data profiling tool

Drive actionable insights

  • Enable end-users to easily build reports with a redesigned Report Builder tool that has the familiar look and feel of Microsoft Office 2007

  • Broaden the reach of Reporting Services with new Word rendering and enhanced Excel rendering

  • Reach customers and suppliers with reports with streamlined Reporting Services Internet deployment

  • Empower every user in the organization to do predictive analysis with the SQL Server 2008 Data Mining Add-ins for Office 2007