SQL server is a relational database server, developed by software companies. The basic function is to store and retrieve information as requested by other software applications, across a network. The recently released first Community Technical Preview or CTP of the latest SQL server version. This version of the SQL database alludes numerous exciting new features.
The new HADR or High Availability and Disaster Recovery features associate development in capabilities of databases compared to SQL 2008. AlwaysOn option allows you to create the availability of database groups. Secondary hosts can also be used with the use of redundant databases. When independent applications depending on multiple databases are failed over, use of AlwaysOn technology prevails.
Ad hoc query page enhancements to Transact-SQL include the offset, fetch keywords by clause, helping you to specify the number of rows to be retrieved and page through those results. But in general, a report is statistically based on innumerable transactions and hence users are not advised to ad hoc query. Instead information can be chose within a given range by the users. For any data which is accessed multiple times, a linked server is defined.
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.
The information stored in external properties can be searched by enhanced Full Text Search option in SQL 2012. For example, with all the formalities filled in a PDF document, the data is directly accessed and searched by full text search without exposing the data. This is an important feature keeping all the information safe and secure.
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.
The new HADR or High Availability and Disaster Recovery features associate development in capabilities of databases compared to SQL 2008. AlwaysOn option allows you to create the availability of database groups. Secondary hosts can also be used with the use of redundant databases. When independent applications depending on multiple databases are failed over, use of AlwaysOn technology prevails.
Ad hoc query page enhancements to Transact-SQL include the offset, fetch keywords by clause, helping you to specify the number of rows to be retrieved and page through those results. But in general, a report is statistically based on innumerable transactions and hence users are not advised to ad hoc query. Instead information can be chose within a given range by the users. For any data which is accessed multiple times, a linked server is defined.
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.
The information stored in external properties can be searched by enhanced Full Text Search option in SQL 2012. For example, with all the formalities filled in a PDF document, the data is directly accessed and searched by full text search without exposing the data. This is an important feature keeping all the information safe and secure.
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 find a summary of the reasons why you should use a SQL Server Integration Services management framework and information about the Microsoft SQL Server program, now.
Không có nhận xét nào:
Đăng nhận xét