The SQL Server 2008's feature has been introduced again by Microsoft on August 8 in the year 2008. Do you belong to that group of people who had installed it? At the mist, you may be visiting Microsoft SQL server 2005 or you might be yet to get it. Let us see what are the Microsoft SQL Server 2008’s features. Well, some of the following features were not put in the SQL Server 2005 as Microsoft had no time to put it in, and the others are new features
Enhanced Office Integration: The SQL Server 2008 is enhanced with the integration of the Microsoft Office 2007 and it enables the users to make and create database-enabled reports straight from Microsoft office word 2007 or Excel 2007. Using the Microsoft Office share point server 2007, these reports can be shared or published.
Language-Integrated Query: The Language Integrated Query is the latest data-access technology of Microsoft. It allows the applications of the basic and C# to use the queries that are set-oriented and are developed in the native language, instead of requiring the need for the queries to be written in the T-SQL. The Language Integrated Query uses SqlClient to connect to the server of the SQL, and at the time of the development, it allows the user to create queries that are typed strongly.
Transparent Failover: The mirroring of the database in the SQL Server 2005 permits the users and the clients to redirect automatically to a server that is mirrored on the occasion of a failure in the principal database. This requires client configuration to specify the server of the mirror. The SQL Server 2008 will permit the client to fail automatically over to the server that is mirrored without the need for manual client configuration.
Log Stream Compression: The new support of the SQL Server 2008 is for the long compression and enhances the performance of the mirroring database automatically. By compressing the stream log which is sent between the participants of the database mirroring. In this process, the bandwidth use of the network is minimized.
Data Compression: The SQL 2008 permits its users to store compressed data and stores it in the database. The requirements of the storage that is reduced can be improved along with the workload of the performance that has I/O requirements. The Microsoft SQL Server 2008 also supports backups that are compressed.
File Stream Data: It is slated originally as a part of the Microsoft SQL Server 2005, and the new file object allows large binary objects that are also known as the LOBs, which can be stored in the file system. The links between the database object and the file systems are then maintained by this system and ensure that they have consistency in the transaction which is similar to the native database objects and they provide performance native storage of the file system.
Ability to Hot-Add CPUs: The ability to Hot-Add CPUs has been introduced by the Microsoft SQL Server 2005 and it enhances scalability. This ability can act as a foundation of the feature for the center of the dynamic data.
Spars Columns: These columns are very similar to that of the forms of the database columns, the difference is that they are optimized and specialized for void and null values. The desk layout should be considered first by the user. Then there is a table that holds an entire lot of the costs. Microsoft's principle would sue columns by thinking if there are 20-40 percent values in the columns that are void and null.
Spatial data types: In the Microsoft SQL Server, two new types of data are included, one is the geometry and the other is geography. The information holds information that is concerned about the contours and the locations of the objects and it allows the software to be constructed and are aware and alert.
Transparent Encryption: The information becomes very sensitive and the capacity of the information to be kept secret becomes very significant. The Microsoft SQL Server 2008 can encrypt the data and from the process of reviewing information when the document is received, the attributes prevent the users.
