Shulou(Shulou.com)05/31 Report--

This article shows you what the characteristics of SQL server2005 are, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

30 important Features of SQL server2005

The 10 most important features of database management

Feature description database mirroring extends the performance of record file transmission through a new database mirroring method. You will be able to use database mirroring to enhance the availability of your SQL server system by establishing automatic failover to a standby server. Online recovery uses the SQL2005 version of the server, and database administrators will be able to perform restore operations while the SQL server is running. Online recovery improves the availability of the SQL server because only the data being recovered is unavailable, while the rest of the database is still online and available. Online retrieval operation the online retrieval option allows simultaneous correction of base table or cluster index data and any related retrieval during the execution of the exponential data definition language (DDL). For example, when a cluster index is being rebuilt, you can continue to update the base data and query the data. Quick recovery of new, faster recovery options can improve the availability of SQL server databases. Managers will be able to reconnect to the database being restored after the transaction log scrolls forward. Security improvements SQL Server 2005 includes some security improvements, such as database encryption, setting security defaults, enhanced password policies, careful license control, and an enhanced security model. The new SQL Server Management StudioSQL Server 2005 introduces SQL Server Management Studio, a new set of unified management tools. The toolset will include new features to develop, configure, find, and fix bugs in the SQL Server database, as well as some improvements to previous features. A dedicated administrator connection to SQL Server 2005 will introduce a dedicated administrator connection, even if a server is locked or cannot be used for other reasons, the administrator can access the running server through this connection. This feature will allow administrators to find and resolve problems found by manipulating diagnostics, or Transact-SQL instructions. Snapshot isolation We will provide a new snapshot isolation (SI) standard at the database level. Through snapshot isolation, users will be able to view the database with a traditional view and access the last row of data executed. This feature will provide greater upgradeability for the server. Data segmentation will strengthen the local surface retrieval segmentation, which enables large tables and indexes to be managed efficiently. Enhanced replication for distributed databases, SQL Server 2005 provides comprehensive scheme modification (DDL) replication, next-generation monitoring of performance, built-in replication from Oracle to SQL Server, merge replication of multiple hypertext transfer protocols (http), and significant improvements in the scalability and operation of merge replication. In addition, the new peer-to-peer transactional replication performance improves its support for data scaling out through the use of replication.

The 10 most important features related to development

The .NET Framework host uses SQL Server 2005, and developers will be able to create database objects by using similar languages, such as Microsoft's Visual C # .NET and Microsoft's Visual Basic. Developers will also be able to create two new objects-- user-defined classes and collections. When XML technology uses local network and Internet, Extensible markup language (XML) is an important standard when walking data between different application software. SQL Server 2005 will support storing and querying Extensible markup language files on its own. ADO.NET 2.0 version from the new support for SQL classes to multiple active result sets (MARS), ADO.NET in SQL Server 2005 will promote the access and manipulation of datasets to achieve greater scalability and flexibility. Enhanced security the new security mode in SQL Server 2005 separates users from objects, provides fine-grain access access, and allows greater control over data access. In addition, all system tables will be implemented as views, giving greater control over database system objects. The enhanced performance of Transact-SQL SQL Server 2005 provides new language features for the development of scalable database applications. These enhancements include error handling, recursive query capabilities, relational operators PIVOT, APPLY, ROW_NUMBER, and other data column ranking capabilities, and so on. SQL Service Mediation SQL Service Mediation will provide a distributed and asynchronous application framework for large-scale, business-wide applications. Notification Service Notification Service enables businesses to build rich notification applications to provide personalized and timely information to any device, such as stock market alerts, news subscriptions, package delivery alerts, airline fares, etc. In SQL Server 2005, notification services are more closely integrated with other technologies, including analysis services and SQL Server Management Studio. Using SQL Server 2005 for Web services, developers will be able to develop Web services at the database layer, treat SQL Server as a Hypertext transfer Protocol (HTTP) listener, and provide a new type of data access function for network service center applications. The report service uses SQL Server 2005, and the report service can provide report control and can be distributed through Visual Studio 2005. The enhanced full-text search capability of SQL SERVER 2005 will support rich full-text applications. The cataloging function of the server will be enhanced to provide more flexibility for cataloged objects. Query performance and upgradeability will be greatly improved, while new management tools will provide a deeper understanding of the operation of full-text features.

The 10 most important features related to business intelligence

The analysis service of feature description analysis service SQL SERVER 2005 has entered the field of real-time analysis. From scalable performance enhancements to deep integration with Microsoft Office, SQL SERVER 2005 will help you extend business intelligence to every level of your business. Data transfer Service (DTS) DTS data transfer Service is a set of drawing tools and programmable objects that you can use to extract, transfer, and load (ETL) data from very different sources and transfer it to single or multiple destinations at the same time. SQL SERVER 2005 will introduce a complete, data transfer service, redesign solution that provides users with a comprehensive platform for excerpt, transfer, and loading. Data mining We will introduce four new data mining algorithms, improved tools and sprites, which will make data mining easier for enterprises of any size. Reporting Services in SQL SERVER 2005, the reporting service will provide self-service for the online analytical processing (OLAP) environment, create end-user special reports, enhance the level of query development, and provide enhanced performance in terms of allowing upgrades to enrich and facilitate the maintenance of the enterprise reporting environment. Cluster support improves the availability of analysis services by supporting fault-tolerant technology to transfer clusters, enhanced support for multiple instances, and support for backup and recovery of analysis service objects and data. Key operating indicators (KPIs) provides new functions for enterprises to define graphical and customizable business metrics to help companies develop and track key business benchmarks. Scalability and performance parallel split processing, creation of remote Relational online Analytical processing (ROLAP) or Hybrid online Analytical processing (HOLAP) Segmentation, distributed Segmentation Unit, continuous Computing, and prefabricated caching features greatly improve the scalability and performance of analytics services in SQL Server 2005. Click a cell when you create a cell in a data warehouse, the cell wizard includes an action that you can click on the unit to detect and suggest. Prefabricated cache combines MOLAP level query operation with real-time data analysis, eliminating the need to maintain online analytical processing storage. Obviously, prefabricated caches synchronize and maintain an updated backup of data that is organized for high-speed queries and separates end users from overloaded related databases. Integrated with Microsoft Office System in the report service, the report provided by the report server can run in the environment of Microsoft SharePoint portal server and Microsoft Office System application software, Office System application software includes Microsoft Word and Microsoft Excel. You can use the SharePoint feature to subscribe to reports, create new versions of reports, and distribute reports. You can also open the report in Word or Excel software and view the hypertext connection markup language (HTML) version of the report. What are the characteristics of SQL server2005 mentioned above? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.