|
|
 |
| |
SQL Server
Versions -
StudioTEQ provides a wide range of services and support for SQL Server versions 6.5, 7, 2000, 2005 and 2008, including upgrade migration from one version to another.
|
|
| |
|
|
| |
Architecture -
The architecture services cover Physical, Infrastructure, Logical, Data and Security.
|
|
| |
Design -
The design services cover Physical, Logical, Routing, Data and Security structures.
|
|
| |
Administration -
Full DBA services, including backup and recovery strategies, Disaster Recovery (DR) and Business Continuity Planning (BCP) services are offered for all versions of SQL Server.
|
|
| |
|
|
| |
Development -
A wide range of development services are offered across the range of SQL Server versions.
Transact-SQL Queries, Stored Procedures, Triggers, Views, Functions, Cursors etc.
DTS / SSIS Data Transformation Services for SQL Server versions prior to 2005 and Integration Services for versions 2005 and later. They provide Extract, Transform, and Load (ETL) processing for data warehousing and simple import and export capabilities amongst other features.
SSRS Reporting Services delivers enterprise, Web-enabled reporting functionality that can draw content from a variety of data sources and publish reports in various formats for SQL server versions 2000 and above.
SSAS Analysis Services delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications and can be part of data warehousing etc. They can also utilise multi-dimensional structures aggregated from multiple data sources.
Alerting can be similar to Notification Services below and delivers timely messages to administration and support staff, should a problem occur.
Notification Services is an event driven system for generating and sending timely, personalized messages to subscribers, and can deliver the messages to a variety of devices.
|
|
| |
|
|
| |
Management -
In addition to the DBA services listed above, StudioTEQ offers schema, server and system management facilities.
|
|
| |
Optimisation -
Full Optimisation and Performance Tuning services are offered for all parts of the system.
|
|
| |
Integration -
Full integration services, including COTS (Commercial Off The Shelf) applications, Replication to and from other systems, bespoke applications etc.
|
|
| |
Migration -
Full migration services, including transfer from other systems and SQL Server version upgrades.
|
|
| |
Security -
Full security services, including analysis of existing security and recommendation of an effective strategy.
|
|
| |
Replication -
Full replication services, including to and from most data sources, clustering and always-on capabilities.
|
|
| |
Reporting -
StudioTEQ can provide detailed analysis and reports on the health of a system or its suitability for upgrading etc., as well as Reporting Services and other reporting applications.
|
|
| |
XML -
"The" method for data interchange between systems and people, including the on-the-fly generation of report style and or specialised content emails.
>> Contact us for more information
|
|
|
