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.
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!
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.
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.
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.
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:
© 2011 Atdhe Buja
All rights reserved.