Microsoft SQL Server 2008
Your Data, Any Place, Any Time
 SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.
SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service-oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.
SQL Server 2008 New Features
TRUSTED
SQL Server provides the highest levels of security, reliability, and scalability for your business-critical applications.
 Protect valuable information
» Transparent Data Encryption
» Extensible Key Management
» Auditing
Ensure business continuity
» Enhanced Database Mirroring
» Automatic Recovery of Data Pages
» Log Stream Compression
Enable predictable response
» Resource Governor
» Predictable Query Performance
» Data Compression
» Hot Add CPU
PRODUCTIVE
To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.
Manage by policies
» Policy-Based Management
» Streamlined Installation
» Performance Data Collection
Simplify application development
» Language Integrated Query (LINQ)
» ADO.NET Object Services
Store any information
» DATE/TIME
» HIERARCHY ID
» FILESTREAM Data
» Integrated Full Text Search
» Sparse Columns
» Large User-Defined Types
» Spatial Data Types
INTELLIGENT
SQL Server 2008 provides a comprehensive platform, delivering intelligence where your users want it.
Integrate any data
» Backup Compression
» Partitioned Table Parallelism
» Star Join Query Optimizations
» Grouping Sets
» Change Data Capture
» MERGE SQL Statement
» SQL Server Integration Services (SSIS) Pipeline Improvements
» SQL Server Integration Services (SSIS) Persistent Lookups
Deliver relevant information
» Analysis Scale and Performance
» Block Computations
» Writeback
Drive actionable insights
» Enterprise Reporting Engine
» Internet Report Deployment
» Manage Reporting Infrastructure
» Report Builder Enhancements
» Built-In Forms Authentication
» Report Server Application Embedding
» Microsoft Office Integration
» Predictive Analysis
|
