|
|
SQL
Server Enterprise 2005
SQL
Server is a comprehensive, integrated, end-to-end data
solution that empowers your staff 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 and 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.
QL
Server 2005 Enterprise Edition is a comprehensive data
platform that meets the high demands of enterprise online
transaction processing and data warehousing applications.
|
Features:
Scalability
and Performance
- No
Limit number of CPUs
- No
Limit Database Size
- Partitioning
- Support for large-scale databases
- Parallel
processing of indexing operations
- Indexed
view creation is supported in all editions. Indexed view
matching by the query processor is supported only in Enterprise
Edition.
High
Availability
- Database
Mirroring - Advanced high availability solution that includes
fast failover and automatic client redirection
- Failover
Clustering
- Backup
Log-shipping - Data backup and recovery solution
- Online
System Changes - Includes Hot Add Memory, dedicated administrative
connection, and other online operations
- Online
Indexing
- Online
Restore
- Fast
Recovery - Database available when undo operations begin
Manageability
- Auto
Tuning - Automatically tunes database for optimal performance.
- Profiler
- SQL
Server Management Studio Express
- Management
Studio - Full management platform for SQL Server; includes
Business Intelligence (BI) Development Studio.
- Database
Tuning Advisor - Automatically suggests enhancements to
your database architecture to improve performance.
- Serviceability
Enhancements - Dynamic management views and reporting enhancements.
- Full-text
Search
- SQL
Agent Job Scheduling Service
Security
- Advanced
Auditing, Authentication, and Authorization
- Data
Encryption and Key Management - Built-in data encryption
for advanced data security.
- Integration
with Microsoft Baseline Security Analyzer - Scans your system
to check for common security vulnerabilities.
- Integration
with Microsoft Update
Programmability
- Stored
Procedures, Triggers, and Views
- T-SQL
Enhancements - Includes exception handing, recursive queries,
and support for new data types.
- Common
Language Runtime and .NET Integration
- User-defined
Types - Extend the server with your own custom data types.
- Native
XML - Includes XML indexing and full-text XML search.
- XQuery
- Notification
Services
- Service
Broker
Integration
and Interoperability
- Import/Export
- Integration
Services with Basic Transforms - Provides graphical extract,
transform, and load (ETL) capabilities
- Integration
Services Advanced Transforms - Includes data mining, text
mining, and data cleansing.
- Merge
Replication
- Transactional
Replication
- Oracle
Replication - Transactional replication with an Oracle database
as a publisher
- Web
Services (HTTP Endpoints) - Support for native Web services,
Web Services Description Language (WSDL), and Web authentication
Business
Intelligence
- Report
Server
- Report
Builder - End-user reporting tool
- Reporting
Data Sources
- Scale
Out Report Servers
- Data
Driven Subscriptions
- Infinite
Clickthrough
- Data
Warehousing
- Star
Query Optimization
- SQL
Analytical Functions
- BI
Development Studio
- Enterprise
Management Tools - Integration with SQL Management Studio,
SQL Server Profiler, SQL Server Agent, Backup/Restore.
- Native
Support for Web Services (Service Oriented Architectures)
- Allows access to data from any device.
- Analysis
Services - Powerful analytics and data mining capabilities.
- Unified
Dimensional Model (UDM) - Enterprise business data model
enables fast, interactive, ad hoc analysis of large data
sets. Builds smarter reports that leverage centralized business
logic and key performance indicators (KPIs), as well as
the performance of UDM.
- Business
Analytics - Multidimensional Expression (MDX) scripts and
MDX debugger, .NET stored procedures, Time Intelligence,
KPI Framework.
- Advanced
Business Analytics - Account intelligence, metadata translation,
perspective and semi-additive measures.
- Proactive
Caching - Provides automated caching for greater scalability
and performance.
- Advanced
Data Management - Partitioned cubes, parallel processing,
server synchronization.
- Full
Writeback Support - Dimension and cell writeback
- Data
Mining - Nine algorithms including decision and regression
trees, clustering, logistic and linear regression, neural
networks, naive bayes, association, sequence clustering,
and time series. Build smarter reports that leverage centralized
business logic and KPIs, as well as the performance of UDM.
- Advanced
Performance Tuning - Additional options for tuning data
mining models for the highest accuracy, performance, and
scalability.
- SQL
Server Integration Services Data Flow Integration - Perform
data mining prediction and training operations directly
in your operational data pipelines.
- Text
Mining - Convert unstructured text data to structured data
for analysis via reporting, online analytical processing
(OLAP), or data mining.
Minimum
System Requirements:
Educational
Pricing:
| SQL
Server 2005 Enterprise |
ex.
VAT
|
| Media |
£21.06
|
| MOLP
A |
£1,968.00
|
| MOLP
B |
£1,870.00
|
| School
Select* |
£1,095.20
|
| SQL
Server 2005 Enterprise (1 Processor) |
ex.
VAT
|
| MOLP
A |
£5,544.00
|
| MOLP
B |
£5,267.00
|
| School
Select* |
£3,085.60
|
| SQL
Client 2005 CAL |
ex.
VAT
|
| MOLP
A |
£38.00
|
| MOLP
B |
£36.00
|
| School
Select* |
£16.00
|
*
School SELECT pricing is only available to schools (under
the LGA agreement)
| SQL
Server 2005 Developer** |
ex.
VAT
|
| MOLP
A |
£9.00
|
| MOLP
B |
£8.00
|
| School
Select* |
£4.80
|
SQL
Server 2005 Developer Edition allows developers to build and
test any type of application with SQL Server on 32-bit, ia64,
and x64 platforms. Developer Edition includes all of the functionality
of Enterprise
Edition, but is licensed only for development, test, and
demo use.
|
|
|
