Top New Features In SQL Server

By Anne Liew

SQL server, formulated by software organizations, is a database management system which is relational and is designed for web applications and desktop purposes. Various features like transaction control and error handling are included in the server. The developer released a recent version of the software. It is stuffed with many exciting new functions.

The new availability features of the software resulted in great improvements over the database capacities of SQL server 2008. Availability of groups of databases can be created by AlwaysOn option. It also helps you to create active secondary hosts, making use of redundant servers for part of the read workload. AlwaysOn technology is especially important when you wish to fail over independent applications that rely upon more than one database.

The ad hoc query thread improvements to Transact-SQL add the offset and fetch keywords to the order by clause, permitting you to set the order of rows you will to retrieve from a long result set. Generally, in ad hoc interface, a user is backed from sending an ad hoc query to produce a report which is based on countless transactions. Data can be selected from a specified domain.

Column based query booster is a wing in the software which appears to be an improvement designed to speed up query performance. The main copy of information is stored in row-arranged order and the redundant copy is stored in column-arranged order. Each column value is stored in their corresponding set of values. Hence there is no saving of spaces and many queries can be answered in less time speeding up the performance.

FileTable is a connecting link between the OS and databases allowing business users to access the data directly, stored in system files. With this, the whole table can be defined as a FileTable and pointed to a folder on a system. Files in the folder are present in FileTable which can be backed up, restored with rest of the application information.

This includes the project crescent, web based visualization results in it. The new silverlight based technology allows business users exceptional access to interact with business information. Crescent takes the business intelligence technology like the PowerPivot brought ms-excel and extends it to the browser with some great improvisations. It also includes data storyboarding that can be sent to PowerPoint.

Full Text Lookup in the software has been heightened by letting you to lookup and index information stored in extensive properties or metadata. Think a PDF document that has its properties like type, name, folder path and size are filled. In the software, this information could be indexed and searched along with information in the document itself. The information does have to be shared to other servers, but it is possible in the software.

Data Quality Services included is associated with SQL services and Integration Services. It tells about the data which is suitable and can be added and accessed for business. Lineage and Impact Analysis has been established, showing the extraction of data. Source and destination assistants are also available to set up source and destination. Data Quality Services on SQL server can even be used to predict changes and troubleshoot packages.

About the Author:

You can check a list of the reasons why you should use a SQL Server Integration Services management framework and information about the Microsoft SQL Server program, now.