|
Installation and Configuration
Database Services recognizes that the proper installation and
configuration
Microsoft's SQL Server database software is no trivial task.
Microsoft's SQL
Server
software consist of numerous components and configuration options. Some of
these configuration choices are not reversible and may have significant
implications on the way your database performs.
Database Services staff posses the skills and reference experiences
required to complete an efficient, successful and well-organized
installation. In recognizing and understanding the critical installation
decisions, we can help you plan the installation, determine the
appropriate system resources required for optimal performance, follow
Microsoft's SQL
Server-recommended best practices, and efficiently configure the software.
Application Integration / Data Migration
Database Services offers both application integration and data
migration services. The integration services are generally advisory in
nature with an emphasis on educating your development staff on the best
approaches for utilizing new structured data and/or new database features.
Database Services data migration services offer clients the comfort
of using our highly skilled staff to perform some of the most sensitive of
tasks. Database Services, Inc works with the client's staff to migrate
existing applications or data to other major database vendors such as from
MS SQL Server or IBM DB2 to an Oracle platform, or vice versa. These tasks
include ensuring proper data type conversions and database settings as
well as, among other things, implementing the appropriate database and
tablespace configurations.
Performance Audits & Tuning
Database Services performance enhancement services focus on
maximizing the efficiency of your existing hardware and software
resources. Our skilled consultants perform a detailed review of your
database systems and the applications that run against them. We evaluate
your storage infrastructure, database structures, application utilization
patterns, memory sizing and consumption, and carefully examine your use of
database indicies and the appropriateness of your index types.
Once we've carried out a full analysis, we work with your system
administrators, DBA's, and developers to come to a cost effective and
expedient performance enhancing solution. Additionally we offer customized
training session for your DBA and/or development staff, focusing on proper
index tuning, SQL evaluation, and SQL tuning techniques.
Disaster Readiness Audits
After
working with a number Fortune 100 in "down database" situations Database
Services, Inc staff have come to appreciate the severe financial and
personal impacts such a scenario can directly create. With a background of
performing numerous such database recoveries, we have developed a critical
eye for weaknesses and/or missing links in the typical back-up and
recovery approaches. We apply this perspective and over 6 years of intense
fire-fighting experience towards analyzing your configurations,
assumptions, and plans.
Once our analysis is complete, we deliver a written statement of findings
and thoughtful recommendation for addressing each client's unique needs.
Back-up & Recovery
The
Back-up and Recovery Service entails one or more Database Services
consultants working either onsite or remotely to implement an enterprise
quality and Oracle recommended procedure for ensuring that, in the event
of a catastrophe, your data can be quickly, safely, and fully recovered.
Database Services first reviews exactly how the database is being
used by existing applications and how it might be used by future
applications. Analysis of existing IT resources and backup strategies is
undertaken next. Once all relevant information has been collected,
Database Services, Inc will design and implement a custom-tailored,
multi-tiered Oracle Backup and Recovery strategy. Finally, before calling
the job complete, Database Services, Inc performs rigorous failure and
recovery testing, ensuring that all implemented recovery processes in fact
hold up under actual failure scenarios.
It is suggested that the customer contract with Database Services on
a semi-annual basis so that the backup solution can be reviewed and tested
for continued efficacy.
|
