Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

SQL Server 2008 by Mind Map: SQL Server 2008
0.0 stars - reviews range from 0 to 5

SQL Server 2008

http://www.microsoft.com/sqlserver/2008/en/us/manageability.aspx  

Features

Backup Compression

Data Auditing

Data Collector

collects the historical data across the servers in a data warehouse for analytical purpose.

Data Compression

Develeopment Features

Grouping Sets

Merge Operator

LINQ

Change Data Capture

Table Valued Parameters

New node

New node

New node

Extended Events

External Key Mangement

Add CPUs and Hot-Add Memory

Partion Alligned Indexed Views

PolicyManagement

Manage policies across all the server at a more granular level.

Resource Governor

enables you to manage SQL Server workload & resources by specifying limits on resource consumption by incoming requests.

Server Group Management

Streamlined Installation

Transparent Data Encryption

High Availability

Performance

Scalability

scale up

scale out

Manageability

Performance Data Collection

Use Performance Data Collection to troubleshoot, tune and monitor SQL Server 2008 instances across the enterprise    

Policy Based Management

built-in framework facets and policies

to manage surface area configuration and apply best practices

A-Single Mangement Console

to manage SSIS,SSRS,SSAS,SSNS custom reports to view the state of the server

Powershell Support

Security

Integration and Interoperability