Introduction to SQL Server 2005 version features

Server

As Microsoft's next-generation data management and business intelligence platform, SQL Server 2005 will be Microsoft's 5-year milestone in enterprise-class database products. Compared to previous data solutions, SQL Server 2005 gives you unprecedented value, superior functionality, and exciting new experiences. www. Want to commit suicide itbulo.comku1kzh7

SQL Server 2005 contains a wealth of new features: enhancing the management capabilities of users in enterprise organizations by providing a more secure, reliable, and efficient data management platform, dramatically increasing IT management efficiency and reducing operational risk and cost Through the provision of advanced business intelligence platform to meet the many customers real-time statistical analysis of the business, monitoring and forecasting of a variety of complex management needs, promote enterprise management information construction and business development; At the same time, SQL Server 2005 will provide a highly scalable and flexible development platform to continuously expand your application space, Realize Internet Data Business interconnection, bring you new business application opportunities. www. Want to commit suicide itbulo.comku1kzh7

With significantly reduced application downtime, increased system scalability and performance, and tighter security controls, SQL Server 2005 took a significant step on the road to support the most demanding enterprise-class system requirements in reality. SQL Server is an important part of the Microsoft server family, and with enhanced manageability and integration achieved through the engineering strategy shared by the Microsoft Server series, customers can effectively reduce TCO and benefit from faster development deployment time. www. Want to commit suicide itbulo.comku1kzh7

• Secure, reliable, and efficient enterprise data management platform
  SQL Server 2005 will greatly improve security, reliability, performance, scalability, and manageability, not only to ensure the real-time and stable operation of enterprise-level data Services, Also can greatly improve the management efficiency, reduce operational complexity and operation of dimension costs. For example, SQL Server 2005 will provide a new security authentication, data encryption technology to enhance your data system security, database mirroring, snapshots, point-in-time recovery, real-time online management, and many other functions greatly improve the reliability of enterprise-level systems, scalability, and data integration, a variety of automated management, The debugging and optimization tools bring a whole new experience to your IT management effort. On the hardware side, SQL Server 2005 supports 64-bit operations and massive data storage.
• Advanced, integrated Business intelligence platform
  SQL Server 2005 enables you to quickly build deployment of various business intelligence solutions, providing you with in-depth business analysis and statistics, and monitoring and forecasting platform to further promote enterprise information management and business development. SQL Server 2005 will provide a very complete suite of business intelligence, including related data warehousing, data analysis, ETL, reporting, data mining a series of design, development, management tools. To meet the growing demands of customers for real-time bi and enterprise-scale applications, SQL Server 2005 has made a qualitative leap in the real time and scalability of building a business intelligence platform. New data analysis tools and rich data mining algorithms will help customers to effectively in-depth business monitoring analysis, decision support; enterprise-class ETL tools support consolidation of heterogeneous data and complex data services Report design and management tools for end users with Office front-end integration can provide very flexible data presentation and free customization capabilities.
• Highly extensible and flexible development platform
  SQL Server 2005 will provide more powerful development tools and new development features that will further expand your application space and bring new opportunities for business applications while greatly improving development efficiency. For example, the support of an XML database and a Web service will enable your application to interconnect Internet data. NET integration greatly expands the development space, with heterogeneous data integration, Service broker, seamless integration of your data and other applications, and a variety of new data types and T-SQL extensions that offer a lot of flexibility. C #, vb.net, XQuery, XMLA, Ado.net 2.0, SMO, AMO will be powerful tools for developing data-related applications on the SQL Server data platform.

To better meet the needs of every customer, Microsoft has redesigned the SQL Server 2005 product family into four new versions: Enterprise, Standard, workgroup , and Express . The following table lists the detailed features for each version.
www. Want to commit suicide itbulo.comku1kzh7

Note: in the following table, the annotation column provides an explanation of the specific attribute, and the number next to the hook mark indicates the footnote at the bottom of the page. www. Want to commit suicide itbulo.comku1kzh7

Characteristics	Express version	Workgroup Edition	Standard Edition	Enterprise Edition	Comments
Scalability and performance
Number of CPUs	1	2	4	Unlimited	Includes support for multi-core CPUs
Ram	1 GB	3 GB	Unlimited	Unlimited
64-bit Support	Windows on Windows (WOW)	WOW
Database size	4 GB	Unlimited	Unlimited	Unlimited
Partition					Support for large-scale databases
Partitioned indexing operations					Index operations can be processed in parallel
High Availability
Database Mirroring			1		Advanced, highly available solutions, including fast failover and automatic client redirection
Failover cluster			2
Backup LOG Delivery					Data backup and Recovery solutions
Online system changes					Includes hot-add memory, administrator-specific connections, and other online operations
In the thread-primer operation
Online data pages and file recovery
Quick Redo					When the undo operation starts, the database is available
Manageability
Auto Tune					Ability to automatically tune the database to optimize performance
Quick Manager					Simplified management tools
Manage Tools Set					Full management platform for SQL Server; Includes business intelligence (BI) Development toolset
Database Tuning Wizard					can automatically recommend optimizing your database structure to improve performance
Enhanced serviceability					Dynamic management view and report enhancements
Full-Text Search
Security
Advanced audit, qualification and authorization
Data encryption and Key management					Built-in data encryption for better data security
Universal Standard Certification					The certification program will be perfected after the final release of the product
Best Practices Analyzer					Scan system ensures that best practices are recommended
Integrated Microsoft Baseline Security Analyzer					Scan the system to check for general security vulnerabilities
Integrated Microsoft Update
Programmability
Stored procedures, triggers, views
Enhanced T-SQL					Includes error handling, recursive queries, and support for new data types
CLR and. NET Integration
User-defined Types					Extend the server to support your own custom type
Native XML					Include XML indexes and Full-text XML searches
Xquery
Notification Service					Allows more advanced subscription and publishing applications to be built
Service Broker	3	3
Integration and interoperability
Import/Export
Integrated Basic Transformation Services					Provides graphical extraction, transformation, and loading (ETL) capabilities
Integrated Advanced Transformation Services					Includes data mining, text mining, and data cleansing
Merge replication	3	4
Transactional replication	3	5
Oracle replication					transactional replication that supports Oracle databases as publishers
Web Services (HTTP endpoints)					Support for native Web services, WSDL, and web authentication
Business Intelligence (BI)
Data Warehouse
BI development tool Set					Integrated development environment to build and debug data integration, OLAP data Mining, and report solutions
Analysis Services (OLAP engine)					Includes advanced OLAP, such as KPIs
Partitioned Cubes
Pre-Active Caching					Provides automatic caching capabilities to improve scalability and performance
Advanced Metrics and Dimensions
Custom-made Rollups
Parallel Data Modeling
Data Mining-Standard algorithm					Including decision trees and aggregation
Data Mining-Advanced algorithms					5 new algorithms: Neural network, Bayesian, sequential algorithm, association and sequence aggregation
Report Control and Wizards					Visual Studio 2005 with Windows and web-based report controls
Report Engine
Data-driven subscriptions					Support for large-scale custom report delivery
Scale-out Web Farms
Unlimited data drillthrough
Report Builder					New end-User random query and report client

^{1 supports only two CPUs per server
2 supports only two nodes
3 subscribers only
4 can be posted to up to 25 subscribers
5 can be posted to as many as 5 subscribers www. Want to commit suicide itbulo.comku1kzh7}