|
|
SQL
Server 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.
Standard
Edition is the data management and analysis platform
for small and medium-sized organisations. It includes
the essential functionality needed for e-commerce, data
warehousing, and line-of-business solutions. Standard
Edition's integrated business intelligence and high-availability
features provide organisations with the essential capabilities
needed to support their operations.
|
Features
Include:
Scalability
and Performance
- Number
of CPUs - 4
- No
Limit Database Size
High Availability
- Database
Mirroring - Advanced high availability solution that includes
fast failover and automatic client redirection (Single REDO
thread and the safety setting is always on)
- Failover
Clustering (Supports only two nodes )
- Backup
Log-shipping - Data backup and recovery solution
- Online
System Changes - Includes Hot Add Memory, dedicated administrative
connection, and other online operations
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
- Merge
Replication
- Transactional
Replication
- 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
- 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.
- 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.
Minimum
System Requirements:
Educational
Pricing:
|
SQL
Server 2005
|
ex.
VAT
|
| Media |
£21.06
|
| MOLP
A |
£206.00
|
| MOLP
B |
£195.00
|
| School
Select* |
£114.40
|
| SQL
Server 2005 ( 1 Processor) |
ex.
VAT
|
| MOLP
A |
£1,331.00
|
| MOLP
B |
£1,264.00
|
| School
Select* |
£740.80
|
| 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.
|
|
|
