Introduction
SQL Server 2005 codenamed “Yukon” is Microsoft’s next-generation data management and analysis software that provides high scalability, availability, and security to enterprise data and analytical applications.
Upgrading the strengths of SQL Server 2000, Yukon delivers an integrated information management solution that will help organizations to:
1.Build and deploy enterprise applications that are more scalable, reliable, and secure.
2.Increases the productivity of IT by reducing the complexity of creating, deploying, and managing database applications.
3.Empower developers through a rich, flexible, modern development environment for creating more secure database applications.
4.Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.
5.Deliver robust, integrated business intelligence solutions that help drive informed business decisions and increase productivity across your entire organization.
6.Control costs without sacrificing performance, availability, or scalability.
What is in it?
Availability Backup and restore facilities, replication, database mirroring, failover clustering, and online operations got a boost and remain accessible to build and deploy around high end applications.
Scalability Table partitioning, snapshot isolation, and 64-bit support have become more demanding.
Security "secure by default" settings, database encryption, and an enhanced security model will help provide a high level of security for your enterprise data.
Manageability Enhancement to management tool, self-tuning capabilities, and a powerful new programming model provide database administrators with flexible control for day-to-day database operations while spending less time.
Interoperability Integrating and connecting disparate applications and databases within your extended enterprise through deep support for industry standards, Web services, and the Microsoft .NET Framework, SQL Server 2005, and Microsoft Windows Server™
How is it going to be productive?
Improved tools Integrated development tool for Transact-SQL, XML, Multidimensional Expression (MDX), and XML for Analysis (XML/A), and Visual Studio development environment will provide more efficient development and debugging of line-of-business and business intelligence applications.
Expanded language support Common language runtime (CLR) hosted in the database engine allows developers to choose from a variety of languages to develop database applications, including Transact-SQL, Microsoft Visual Basic® .NET, and Microsoft Visual C#® .NET. Additionally, CLR hosting will provide the use of user-defined types and functions.
XML and Web services XQuery and a native XML data type features will help enable organizations to seamlessly connect internal and external systems. SQL Server 2005 will support both relational and XML data natively, so enterprises can store, manage, and analyze data in the format that best suits their needs.
How do we check its Business Intelligence
Integrated platform Server 2005 delivers an end-to-end business intelligence platform with integrated analytics including online analytical processing (OLAP); data mining; extract, transformation, and load (ETL) tools; data warehousing; and reporting functionality.
Improved decision making Enhancements to features, such as OLAP and data mining, and the introduction of a new reporting server will provide enterprises with the ability to transform information into better business decisions at all organizational levels, from the information worker to the CEO.
Enterprise-wide analytical capabilities An improved ETL tool will enable organizations to more easily integrate and analyze data from multiple heterogeneous information sources
Summary
Several key enhancements have been made in the following areas:
Transact-SQL Enhancements
SQL Service Broker
Analysis Services
Data Transformation Services (DTS)
Reporting Services
Data Mining
Reference URL: http://www.microsoft.com/sql/2005/default.asp
|
No responses found. Be the first to respond and make money from revenue sharing program.
|