System requirements
Minimum RAM |
512 MB |
Minimum processor |
1 GHz |
Technical details
Platform |
PC |
Mac compatibility |
N |
Software version |
Standard 2008 |
SQL Server 2008 Standard, All Languages, OLV-C, Each AP, 1PC
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