Microsoft SQL Server 2008
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.
Microsoft SQL Server 2008 R2
Windows Server 2008 R2, now with Service Pack 1 (SP1) provides
new virtualization technology that
enables you to deliver more advanced capabilities to your business
for increased IT efficiency and agility. Whether you want to
consolidate servers, build a private cloud or offer Virtual Desktop
Infrastructure, the addition of these powerful virtualization
features enables you to take your datacenter and desktop
virtualization strategy to a new level.
SQL Server 2008 R2 Benefits
- Virtualization
- Web Application Platform
- Scalability and Reliability
- Management
- Better Together with Windows 7
SQL Server 2008 Key Features
Protect valuable information - Transparent Data
Encryption; Extensible Key Management & Auditing
Ensure business continuity - Enhanced database
mirroring; Automatic recovery of data; Log stream compression
Enable predictable response - Resource Governor;
Predictable query performance; Data compression; Hot add CPU;
Manage by policies; Steamlined installation; Performance data
collection, Language integrated query (LINQ); ADO.NET object
services
Store any information - New Date/Time types;
Hierarchy ID; Integrated full text search; Sparse columns; Large
user-defined types; Spatial data types
Integrate any data - Backup compression;
Partitioned table parallellism; Star join query optimisations;
Grouping sets; Change data caapture; Merger 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 buidler enhancements; Built-in forms
authentication; Report server application enbedding; Microsoft
Office integration; Predictive analysis
More Information
SQL Server Technologies
SQL Server Enterprise
Edition
SQL Server Standard Edition
SQL Server Reporting Services
(SSRS)
