Your Data, Any Place, Any Time Microsoft SQL Server 2008 Provides ...
Your Data, Any Place, Any Time
Microsoft® SQL Server® 2008 provides a trusted,
productive, and intelligent data platform that
enables you to run your most demanding mission
critical applications, reduce time and cost of
development and management of applications,
and deliver actionable insight to your entire
organization. SQL Server provides the highest
levels of security, reliability, and scalability.
http//www.microsoft.com/sqlserver/2008/en/us/default.aspx
as “Who accessed ou
TOP NEW FEATURES
r customer
minimizes the network bandwidth
data?”
used by database mirroring.
A trusted data platform.
ENSURE BUSINESS CONTINUITY
PREDICTABLE RESPONSE
PROTECT VALUABLE
Enhanced Database Mirroring
Resource Governor
INFORMATION
SQL Server 2008 builds on SQL
Provide a consistent and predictable
Server 2005 by providing a more
response to end users with the
Transparent Data Encryption
reliable platform that has enhanced
introduction of Resource Governor.
Enable encryption of an entire
database mirroring including
The Resource Governor allows
database, data files or log files,
automatic page repair, improved
organizations to define resource
without the need for application
performance, and enhanced
limits and priorities for different
changes. Benefits of this include
supportability.
workloads which enable concurrent
search encrypted data using both
workloads to provide consistent
range and fuzzy searches, prevent
Automatic Recovery of Data
performance to their end users.
access to secure data from
Pages
unauthorized users, and data
SQL Server 2008 enables the
Predictable Query Performance
encryption without any changes to
principal and mirror machines to
Enable greater query performance
existing applications.
transparently recover from common
stability and predictability by
types of data page errors by
providing functionality to lock down
Extensible Key Management
requesting a fresh copy of the
query plans enabling organizations
SQL Server 2005 provides a
suspect page from the mirroring
to promote stable query plans
comprehensive solution for
partner transparently to end users
across hardware server
encryption and key management.
and applications.
replacements, server upgrades, and
SQL Server 2008 supports third-
production deployments.
party key management and HSM
Log Stream Compression
products.
Database Mirroring requires data
Data Compression
transmissions between the
Enable data to be stored more
Auditing
participants of the mirroring
effectively and reduce the storage
Create and manage auditing via
implementations. With SQL Server
requirements for your data. Data
DDL while simplifying compliance by
2008, compression of the outgoing
Compression also provides
providing more comprehensive data
log stream between the participants
significant performance
auditing. This enables organizations
delivers optimal performance and
improvements for large I/O bound
to answer common questions such
workloads like data warehousing.
SQL Server 2008 – Your Data, Any Place Any Time
Hot Add CPU
Server 2008 includes more
The new data types enable
Dynamically scale a database on
extensive performance data
applications to have separate data
demand by allowing CPU resources
collection, a new centralized data
and time types while providing large
to be added to SQL Server 2008 on
repository for storing performance
data ranges or user defined
supported hardware platforms
data and new tools for reporting and
precision for time values.
without forcing any downtime on
monitoring.
HIERARCHY ID
applications. Note that, as in the
SIMPLIFY APPLICATION
previous release, SQL Server also
Enable database applications to
DEVELOPMENT
supports the ability to add memory
model tree structures in a more
resources online.
Language Integrated Query
efficient way than currently
(LINQ)
possible. New system type,
A productive data platform.
HierarchyId, can store values that
Enable developers to issue queries
represent nodes in a hierarchy
To take advantages of new
against data using a managed
tree. This new type will be
opportunities in today's fast-moving
programming language such as C#
implemented as a CLR User-
business world, companies need the
or VB.NET, instead of SQL
Defined Type (UDT), and will
ability to create and deploy data-
statements. Enable seamless,
expose several efficient and useful
driven solutions quickly. SQL Server
strongly-typed, set-oriented queries
built-in methods for creating and
2008 reduces time and cost of
written in.NET languages to run
operating on hierarchy nodes with a
management and development of
against ADO.Net (LINQ to SQL),
flexible programming model.
applications.
ADO.Net DataSets (LINQ to
DataSets), the ADO.NET Entity
FILESTREAM Data
MANAGE BY POLICIES
Framework (LINQ to Entities) and to
the Entity Data Service Mapping
Allow binary data to be stored
Policy-Based Management
provider. Use the new LINQ to SQL
directly in an NTFS file system while
Policy-Based Management is a
provider that enables developers to
preserving it as an integral part of
framework for managing one or
use LINQ directly on SQL Server
the database and maintaining
more instances of SQL Server 2008.
2008 tables and columns.
transactional consistency. Enable
Use this framework to ensure
the scale-out of large binary data
compliance with system
ADO.Net Object Services
traditionally managed by the
configuration policies, monitor and
database to be stored outside the
The Object services layer of
prevent changes to the system that
database on more cost-effective
ADO.NET enables the
violate your company policies, and
storage without compromise.
materialization, change tracking,
reduce total cost of ownership by
and persistence of data as CLR
simplifying administration tasks.
Integrated Full Text Search
objects. Developers using the
ADO.NET framework can program
The Integrated Full Text search
Streamlined Installation
against a database using CLR
makes the transition between Text
SQL Server 2008 introduces
objects that are managed by
Search and relational data seamless
significant improvements to the
ADO.NET. SQL Server 2008
while enabling users to use the Text
service lifecycle for SQL Server
introduces more efficient, optimized
Indexes to perform high-speed text
through the re-engineering of the
support that improves performance
searches on large text columns.
installation, setup and configuration
and simplifies development.
architecture. These improvements
Sparse Columns
separate the installation of the
STORE ANY INFORMATION
NULL data consumes no physical
physical bits on the hardware from
space which provides a highly
Date and Time
the configuration of the SQL Server
efficient way of managing empty
software enabling organizations and
SQL Server 2008 introduces new
data in a database. For example,
software partners to provide
date and time data types
Sparse Columns allows object
recommended installation
DATE – a date only type
models that typically have numerous
configurations.
null values to be stored in a SQL
TIME – a time only type
Server 2008 database without
Performance Data Collection
DATETIMEOFFSET – a time-
experiencing large space costs.
Performance tuning and
zone aware datetime type
troubleshooting are time-consuming
DATETIME2 – a datetime type
tasks for the administrator. To
with larger fractional seconds and
provide actionable performance
year range than the existing
insights to administrators, SQL
DATETIME type
SQL Server 2008 – Your Data, Any Place Any Time
Large User Defined Types
same query. Grouping Sets
Data Profiling
SQL Server 2008 eliminates the
produces a single result set that is
The new data profiling tool in
8KB limit for User Defined Types
equivalent to a UNION ALL of
SSIS enables users to analyze
(UDTs) allowing users to
differently grouped rows making
source data for a variety of
dramatically expand the size of their
aggregation querying and reporting
properties such as data type,
UDTs.
easier and faster.
lengths, histograms of data
values, and the strength of
Spatial Data Types
Change Data Capture
integrity relationships. This helps
improve the quality of data going
Build spatial capabilities into your
With Change Data Capture,
into a data warehouse.
applications by using the support for
changes are captured and placed in
spatial data.
change tables. It captures complete
Backup Compression
content of changes and maintains
Keeping disk-based backups
Implement Round Earth solutions
cross table consistency and even
online is expensive and time
with the geography data type.
works across schema changes. This
consuming. With SQL Server
Use latitude and longitude
enables organizations to integrate
2008 backup compression, less
coordinates to define areas on the
the latest information into the data
Earth’s surface.
storage is required to keep
warehouse.
backups online and backups run
Implement Flat Earth solutions
MERGE SQL Statement
significantly faster since less disk
with the geometry data type.
With the introduction of the
I/O is required.
Store polygons, points, and lines
MERGE SQL Statement,
that are associated with projected
developers can more effectively
DELIVER RELEVANT
planar surfaces and naturally
handle common data warehousing
INFORMATION
planar data, such as interior
scenarios like checking whether a
Analysis Scale and Performance
spaces
row exists and then executing an
SQL Server 2008 drives broader
insert or update.
An intelligent data platform.
analysis with enhanced analytical
SQL Server Integration Services
capabilities and with more complex
SQL Server 2008 provides a
(SSIS) Pipeline Improvements
computations and aggregations.
comprehensive platform delivering
Data Integration packages can
New cube design tools help users
business intelligence where your
now scale more effectively making
streamline the development of the
users want it.
use of available resources and
analysis infrastructure enabling
managing the largest enterprise
them to build solutions for optimized
INTEGRATE ANY DATA
scale workloads. The new design
performance.
Partitioned Table Parallelism
improves the scalability of runtime
into multiple processors.
Block Computations Block
Partitions enable organizations to
manage large growing tables more
SQL Server Integration Services
Computations provide a significant
effectively by transparently breaking
(SSIS) Persistent Lookups
improvement in processing
them into manageable blocks of
The need to perform lookups is
performance enabling users to
data. SQL Server 2008 builds on the
one of the most common ETL
increase the depth of their
advances of partitioning in SQL
operations. This is especially
hierarchies and complexity of the
Server 2005 by improving the
prevalent in data warehousing
computations.
performance on large partitioned
where fact records need to use
tables.
lookups to transform business
Writeback
keys to their corresponding
New MOLAP enabled writeback
Star Join Query Optimizations
surrogates. SSIS increases the
capabilities in SQL Server 2008
SQL Server 2008 provides improved
performance of lookups to support
Analysis Services removes the need
query performance for common data
the largest tables.
to query ROLAP partitions. This
warehouse scenarios. Star Join
provides users with enhanced
SSIS High-Performance
Query optimizations reduce query
writeback scenarios from within
Connectors
response time by recognizing data
analytical applications without
warehouse join patterns.
SSIS has new connectors for SAP
sacrificing the traditional OLAP
Netweaver BI, Oracle and Teradata,
performance.
Grouping Sets
specially designed for high-
Grouping Sets is an extension to the
performance loading of data into an
GROUP BY clause that lets users
enterprise data warehouse.
define multiple groupings in the
SQL Server 2008 – Your Data, Any Place Any Time
DRIVE ACTIONABLE
Report Builder Enhancements
has been greatly enhanced to
INSIGHTS
Easily build reports with any
accommodate the support of
features like nested data
Enterprise Reporting Engine
structure through a redesigned
Report Builder end-user tool
regions, sub-reports as well as
Reports can easily be delivered
that has the familiar look and
merged cell improvements. This
throughout the organization both
feel of Microsoft Office 2007,
lets users maintain layout fidelity
internally and externally with
including a “ribbon” interface
and improves the overall
simplified deployment and
and the ability to integrate
consumption of reports from
configuration, and increased
powerful visualizations into
Microsoft Office applications.
scalability including the ability to
reports.
scale out a reporting workload
Predictive Analysis
across multiple servers. This
Built-in Forms Authentication
SQL Server Analysis Services
enables users to easily create
continues to deliver advanced
and share reports of any size
Built-in forms authentication
data mining technologies. Better
and complexity.
enables users to easily switch
between Windows and Forms.
Time Series support extends
forecasting capabilities.
Internet Report Deployment
Report Server Application
Enhanced Mining Structures
Customers and suppliers can
Embedding
deliver more flexibility to perform
effortless be reached by
focused analysis through
deploying reports over the
Report Server application
filtering as well as to deliver
internet.
embedding enables the URLs in
complete information in reports
reports and subscriptions to
beyond the scope of the mining
Manage Reporting
point back to frontend
model. New cross-validation
Infrastructure
applications.
enables confirmation of both
Increase supportability and the
Microsoft Office Integration
accuracy and stability for results
ability to control server behavior
that you can trust. Furthermore,
with memory management,
SQL Server 2008 provides new
the new features delivered with
infrastructure consolidation, and
Word rendering that enables
SQL Server 2008 Data Mining
easier configuration through a
users to consume reports
Add-ins for Office 2007
centralized store and API for all
directly from within Microsoft
empower every user in the
configuration settings.
Office Word. In addition, the
organization with even more
existing Excel renderer
actionable insight at the
desktop.
This data sheet is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any
real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. (Use this only if fictitious content appears.)
0308 Part No. 098-00000 (color)
Part No. 098-00000 (black and white)
