Deployment
-SQL Server
There is a lot more to deploying SQL Server than simply installing the software and that's where our experience comes into play. We will work with you to:
-- Select the best hardware configuration based on your expected workload
-- Identify the optimal physical layout for your datafiles
-- Install and configure SQL Server on your hardware
-- Set up and schedule basic administrative tasks to get you started
-Third Party SQL Tools
There are many SQL Server tools in the market designed to make administration and on-going maintenance of your SQL Server as painless as possible. While many of these tools are simple to install and use, there are several large monitoring and trending tools that require a great deal of planning and configuration. We have experience installing and configuring the majority of these tools as well as creating and configuring preset actions to take when a given event occurs. For more information on these tools, take a look at our SQL Server Tools page.
Administration
-On-Site SQL Administration
We offer short-term on-site administration for clients who need administrative tasks set up scheduled and documented on a one-time basis. This includes the planning and configuration of security, backups, index maintenance and any maintenance oriented job the client would like to have set up. Once setup is complete, the client can take over the routine daily administration or move on to our remote dba services.
-Remote SQL Administration
This is one of our most popular options and is an extremely affordable way to get the complete services of a skilled SQL Server DBA without the overhead and expense of actually having to permanently staff someone.
SQL Performance Tuning
-Server and Database Monitoring
Before you can increase database performance, you've got to identify where the bottlenecks are. We monitor your server as well as your database to identify all areas of contention from your server setup and datafile layout to your table indexing and design.
