Descriptions of New features SQL Server 2008


Unlike SQL Server 2005 version of SQL Server 2008 comes with a host of changes and new opportunities. The whole purpose was to facilitate the work of the administrator in the management of databases of this as best possible with SQL 2008, all this was achieved in the following we will present all these new.

COMPRESSED BACKUPS
Save Time & Disk space on the cry it’s a new opportunity, where earlier in SQL2005 has been possible only with the backup performance of that size and time spent without saving any, that in SQL2008 it provides compression of copies backup databases to save time and storage space, which means reducing the size of backup.
This opportunity is located in right click on the databaseàBackup databaseàOptionsàCompressionàSet backup compressionàCompress backup

CDC CHANGE DATA CAPTURE
Used to capture insertions, updates and deletes in a SQL server table in database and place the changes in another table!

FILESTREAM
Organization or management of files or data types with sizes as large as photos, geographical data, best achieved with the implementation of even it out Filestream database, the data is stored in the local NTFS file system and swimming in database file. But though that helps, and is a very important function has limits the use of other tools if its activation for example: Database Mirroring, Database Snapshot and Native Encryption.

SPARSE COLUMN
This feature helps in saving the empty space that is optimized Allow for the storage of null Columns. Located in: TableàColumn PropertiesàIs Sparseà Yes/No

TDE TRANSPARENT DATA ENCRYPTION

Encrypt the contents of your database and protection to the entire database, first you need to create master key and certificate.

HIGH AVAILABILITY
One of the great support of this version is SQL Server 2008 High Availability which are: Mirroring, Hot Add Memory, Hot Add CPU, New failover clustering.

PERFORMANCE
The two tools that are implemented are Performance Data Management and Resource Governor it helps to manage workload by limiting the resources available to a process.

DMF DATABASE MANAGEMENT FRAMEWORK
Very similar to the Windows operating system Windows Policy which contains various policy options once implemented across your infrastructure to SQL Servers through components policies, conditions and facets. Located in: ManagementàPolicy Management

In SQL Server 2008 has new kinds of data types such as:
Date,
Time,
DateTimeOffset,
DateTime2,
Hierarchyid,
Geometry,
Geography.

© 2011 Atdhe Buja
All rights reserved.

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in Personal Blogs, SQL Server 2008 and tagged , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s