MICROSOFT 228-05236

SQL SVR STANDARD EDTN 2005 CROM ENGLISH DISK KIT MVL CD/DVD EN

Your organization today faces numerous data challenges. You need your people to make faster and more data-driven decisions, your developers to be more productive and flexible, and your managers to reduce their overall information technology (IT) budgets even as they scale your infrastructure to meet ever-increasing demands.

SQL Server 2005 is designed to help enterprises address these challenges. This next-generation data management and analysis solution delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.

Extending the strengths of SQL Server 2000, SQL Server 2005 provides an integrated data management and analysis solution that can help your staff do the following:
- Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable.
- Maximize IT productivity by reducing the complexity of developing and supporting database applications.
- Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.
- Control costs without sacrificing performance, availability, scalability, or security.

SQL Server 2005 advances your data infrastructure in three key areas: it makes your enterprise data more manageable, your developers more productive, and your business intelligence (BI) more comprehensive. It also breaks new ground in affordable pricing and licensing, upgrade paths to SQL Server 2005, and the Microsoft Windows Server System.

SQL Server Data Platform

SQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications. SQL Server 2005 delivers powerful, familiar tools to IT professionals as well as to information workers, reducing the complexity of creating, deploying, managing, and using enterprise data and analytical applications on platforms ranging from mobile devices to enterprise data systems. Through a comprehensive feature set, interoperability with existing systems, and automation of routine tasks, SQL Server 2005 provides a complete data solution for enterprises of all sizes. Figure 1 shows the layout of the SQL Server 2005 data platform.

The SQL Server data platform includes the following tools:

- Relational Database. A more secure, reliable, scalable, highly available relational database engine with improved performance and support for structured and unstructured (XML) data.
- Replication Services. Data replication for distributed or mobile data processing applications, high systems availability, scalable concurrency with secondary data stores for enterprise reporting solutions, and integration with heterogeneous systems, including existing Oracle databases.
- Notification Services.Advanced notification capabilities for the development and deployment of scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices.
- Integration Services.Data extraction, transformation, and loading (ETL) capabilities for data warehousing and enterprise-wide data integration.
- Analysis Services.Online analytical processing (OLAP) capabilities for the rapid and sophisticated analysis of large and complex datasets using multidimensional storage.
- Reporting Services.A comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Web-based reports.
- Management Tools. SQL Server includes integrated management tools for advanced database management and tuning as well as tight integration with tools such as Microsoft Operations Manager (MOM) and Microsoft Systems Management Server (SMS). Standard data access protocols drastically reduce the time it takes to integrate data in SQL Server with existing systems. In addition, native Web service support is built into SQL Server to ensure interoperability with other applications and platforms.
- Development Tools. SQL Server offers integrated development tools for the database engine, data extraction, transformation, and loading, data mining, OLAP, and reporting that are tightly integrated with Microsoft Visual Studio to provide end-to-end application development capabilities. Every major subsystem in SQL Server ships with its own object model and set of application program interfaces (APIs) to extend the data system in any direction that is unique to your business.

The SQL Server 2005 data platform provides organizations of all sizes with the following benefits:

- Capitalize on Data Assets. In addition to delivering a secure, reliable database for line-of-business and analytical applications, SQL Server 2005 enables your people to get more value from their data by including embedded functionality such as reporting, analysis, and data mining. You can take advantage of this power and flexibility to deliver data to every corner of your organization at a fraction of the cost of some other systems.
- Increase Productivity. Through comprehensive BI capabilities and integration with familiar tools such as Microsoft Office System, SQL Server 2005 delivers timely business information to those who need it and tailors it to their specific needs. The goal is to extend BI to your entire staff and ultimately to help everyone, at all levels of the organization, make better business decisions based on one of their most valuable assets—their data.
- Reduce IT Complexity. SQL Server 2005 simplifies the development, deployment, and management of line-of-business and analytical applications by providing a flexible development environment for developers and integrated, automated management tools for database administrators.
- Lower Total Cost of Ownership (TCO). The integrated approach and focus on ease of use and deployment in SQL Server 2005 provides the industry's lowest upfront, implementation, and maintenance costs for rapid return on your database investment.

SQL Server 2005 provides the technology and capabilities that your people can count on. With significant advancements in the key areas of enterprise data management, developer productivity, and BI, the benefits of upgrading or migrating to SQL Server 2005 are substantial.

SQL Server 2005 has the potential to take your business to the next level—we encourage you to try it for yourself.

SQL Server 2005 Standard Edition Features:

Scalability and Performance
- 4 CPUs maximum
- 64-bit Support
- Unlimited Database Size

High Availability
- Database Mirroring
- Failover Clustering
- Backup Log-shipping
- Online System Changes

Manageability
- Auto Tuning
- Profiler
- SQL Server Management Studio Express
- Management Studio
- Database Tuning Advisor
- Serviceability Enhancements
- Full-text Search
- SQL Agent Job Scheduling Service

Security
- Advanced Auditing, Authentication, and Authorization
- Data Encryption and Key Management
- Integration with Microsoft Baseline Security Analyzer
- Integration with Microsoft Update

Programmability
- Stored Procedures, Triggers, and Views
- T-SQL Enhancements
- Common Language Runtime and .NET Integration
- User-defined Types
- Native XML
- XQuery
- Notification Services
- Service Broker

Integration and Interoperability
- Import/Export
- Integration Services with Basic Transforms
- Merge Replication
- Transactional Replication
- Web Services (HTTP Endpoints)

Business Intelligence
- Report Server
- Report Builder
- Reporting Data Sources
- Data Warehousing
- Star Query Optimization
- SQL Analytical Functions
- BI Development Studio
- Enterprise Management Tools
- Native Support for Web Services (Service Oriented Architectures)
- Analysis Services
- Unified Dimensional Model (UDM)
- Business Analytics
- Data Mining