New Features of SQL Server 2008

Leave a comment (0) Go to comments

SQL Server 2008 Top New Features

There is an updated version of this post…. Click Here

1)       Enterprise Data Platform

2)       Policy-Based Management

3)       Performance Data Collection (Data Collector)

4)       Data Compression

5)       Resource Governor

6)       Transparent Data Encryption

7)       (Encryption Without Keys)

8)       External Key Management / Extensible Key Management

9)       Data Auditing

10)   SQL Server 2008 Auditing

11)   SQL Server Audit Action Groups and Actions

12)   Hot-Add CPUs and Hot-Add Memory

13)   Managing memory for large databases

14)   Cluster installation issues and troubleshooting new setup logs

15)   Server Group Management

16)   SQL Server Policy-Based Management

17)   Upgrade Advisor

18)   Partition Aligned Indexed Views

19)   Backup Compression

20)   Extended Events

21)   New MERGE Operator

22)   New Data Types in SQL Server 2008( Date,Time,DatetimeOffset,DateTime2)

23)   Grouping Sets

24)   CLR Improvements

25)   Clustered Index Merge Show plan Operator

26)   SQL Server 2008 – Merge Capability

27)   Using MERGE in Integration Services Packages


28)   MERGE (Transact-SQL)

29)   Inserting, Updating, and Deleting Data by Using MERGE

30)   Optimizing MERGE Statement Performance

31)   Change Data Capture

a)       Change Data Capture Tables (Transact-SQL)

b)       Change Data Capture Stored Procedures (Transact-SQL)

c)        Change Data Capture functions (Transact-SQL)

d)       Change Data Capture SQL Server 2008

32)   Conflict Detection in Peer-to-Peer Replication

33)   Service Broker

34)   Sparse Columns

35)    Filtered Indexes

36)   Integrated Full-Text Search

37)   FILESTREAM Data

38)   Large User-Defined Types (UDTs)

39)   Large User-Defined Aggregates (UDAs)

40)   Improved XML Support

41)   Fixed Query Plan Guides (Plan Freezing)

a)       Understanding Plan Guides

b)       Designing and implementing plan guides

c)        How to: Create a Plan Guide (SQL Server Management Studio)

d)       New Plan Guide

e)       Plan Guide Properties

f)        Freeze query plans on previous versions of SQL Server during upgrade to SQL Server 2008 to help ensure a predictable state of operation

g)       Ensure that query plans are retained when servers are upgraded

h)       Star Join Query Optimization

42)   SQL Server Reporting Services

a)       Getting Started

b)       Evaluate Reporting Services

c)        Simplified administration and access to reports

d)       Deploying Reports without IIS

43)   Partitioned Table Parallelism

44)   Getting optimal performance with Integration Services Lookups

a)       Helpful information and examples on how to use SQL Server Integration Services.

b)       Upgrading Lookup Transformations

c)        Integration Services Development Enhancements

d)       Improved performance for lookup transformations

e)       More efficient use of memory resources

45)   Powerful New Business Intelligence Capabilities Join SQL Server 2008

46)   Data Profiling – SSIS

a)       Column Pattern Profile Request Options (Data Profiling Task)

b)       Profiling Data with the Data Profiling Task and Viewer

c)        How to: Use the Data Profiling Task (SQL Server Video)

d)       Data Profiling Task

e)       Proactive approach to eliminating data quality issues

47)   Backwards compatible, supports data stored in SQL Server 2000, SQL Server 2005, and SQL Server 2008 databases.

EOF - New Features of SQL Server 2008, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.