SQL Server Database, VMware Virtual Servers, Performance, Tuning, Management, Backups, Recovery, On Demand Servers, Database Security, Server Audit

Technical Architecture Solutions
newsletter subscription Customer login
home
TAS Database Consulting
services resources customers education news aboutus contactus
shopping cart order
TAS Services - Specialist Consulting - Database Services

 

Our database services provide for secure, optimal management and increased database productivity. We have a proven track record with database management systems in multiple environments for both Oracle and SQL Server.

Please download our pdf brochure PDF brochure for more information and fill out our information request form or contact us to help with your current and or future needs.

back to topOur Database Services include :

  • DBA / mentoring / training
  • Performance tuning and analysis
  • Backfill / on-demand resources
  • Remote database administration and support service
  • Database system audits
  • Initial setup services
  • Capacity planning
  • Disaster recovery
  • Information architecture
  • Data analysis and design
  • Design reviews
  • New database implementations or upgrades
  • SQL development
  • Administration scripts
  • Replication design and implementation
  • Standby database implementation
  • High availability design, implementation and testing
  • Database conversions to SQL Server

back to topOur Value Proposition to you

We understand that your database is one of the most critical components in your business and information system infrastructure.

Our experienced team of professionals will setup, audit and maintain your database to best practice standards. We can also tailor our mentoring services to meet your specific needs for example supplying casual DBA resources; training and mentoring you internal IT administration staff; full implementation.

back to topOur proven experience guarantees you on going success and peace of mind.

There are 3 primary components of the TAS database server management service: the database setup; database audit; recurring and on demand database services. Any or all of these components can be undertaken by TAS professional services based upon your unique system and business needs.

back to topDatabase Setup

The setup will be tailored to your specific system and business needs. The normal setup will include such tasks as:

back to topDatabase Audit (SQL Server & Sybase)

This service gathers the necessary information to optimise your system's operation and determine the procedures to maintain it at that peak level. A detailed inventory of the SQL Server or Sybase system and all databases is taken.

The audit provides a baseline report of how your SQL or Sybase system looks now, and will recommend any modifications that might be beneficial to your system's architecture, performance, security or any setup work that goes beyond what is normally provided. The audit also allows TAS to inform you of any bugs or security patches that are applicable to your operating system and databases as they are released.

Finally, the audit provides the means for TAS to recommend specific services (consistent with TAS Best Practices) to optimise the management and performance of your database server.

A list of the audit checksaudit checks that are performed and a sample sample audit report skeletonaudit report skeleton are included in the attached files.

back to topSybase to SQL Server Conversions

Where can TAS help you?

  • Aging Sybase deployments keeping you up at night?
  • Do you have services running on non supported versions of Sybase?
  • Are your support costs growing out of control?
  • Are you avoiding the effort to upgrade aging Sybase deployments?
  • Are you finding it hard to find and keep Sybase DBA resources?
Would you like to:
  • Reduce the TCO of your database infrastructure?
  • Tap back into a extensive pool of DBA resources?
  • Revitalise your database infrastructure?
Let TAS help you migrate to SQL Server 2005.

TAS has developed a conversion methodology and conversion assistant tool that automatically converts on average over 60% of your database whilst also isolating potential code problems for review. TAS works closely with Microsoft on database cross platforming validating our conversion tool and methodology with Microsoft.

back to topRecurring and On Demand Database Services

The recurring and on demand database services can be tailored to suit your needs.

Services include:

  • SQL Server & Sybase Audits
  • SQL Server & Sybase security reviews
  • SQL Server Mentoring
  • SQL Server & Sybase Health Check monitoring (let us be your DBA or assist your existing DBA).

TAS works with your internal database administration team or acts as a on call database administration team for your company.

The premier service is our Health Check service which involves TAS loading health check and statistics packages on your servers. TAS will then schedule health check runs against your databases at agreed intervals ranging from as little as once a month through to 7 days a week or multiple times a day. The checks performed each time can be found in audit checks. TAS will then review the health check and notify you of any current or predicted problems for your attention. Should you not be able to address the problem, TAS can address it on your behalf. TAS will then send you a summary report of findings once a week. The statistical database will provide you with summary usage information of your database indicating what and where your database is being utilised.

Please download our pdf brochure PDF brochure for more information and fill out our information request form or contact us to help with your current and or future needs.

TAS Services 
SOLUTIONS DESIGN
    Creation and Maintenance
    Due Diligence
    Cost Compilation
    Technical Risk Analysis
DEPLOYMENT MANAGEMENT
    Cost & Duration Analysis
    Project Plan Creation
    Project Plan Due Diligence
    Project Management
SPECIALIST CONSULTING
    Turn key Disaster Recovery
    Infrastructure
    Database
    Data Centre
    Best Practices
MANAGED SERVICES
    Systems Administration
    Database Administration
    Capacity Planning
    On Demand Resources
    Operational Best Practices
    VMware Mentoring
VIRTUALISATION CONSULTING
    TAS consolidation TCO / VI     scope analysis
    PlateSpin
    VMware Kick Start
    VMware Virtualisation
    VMware Health Check
    VMware Mentoring
    VMware FAQ
FINANCIAL SERVICES
TAS Database Services
TAS Database Services
 
   
exa