BestSQLDBA offers a comprehensive set of SQL DBA services to our clients. It is our aim to provide our clients with most of the same resources that they would be able to get from hiring a database professional to come work in their office directly. Your SQL Server(s) will be managed and maintained according to the same high quality standards set out as best practices by Microsoft that are used in large corporate enterprise SQL Server deployments in order to safeguard a company’s critical data.

Individual SQL Projects:

In addition to our monthly maintenance agreements, we also offer SQL consultant services for ad-hoc projects that will be billed on an hourly basis. Subject areas that we cover are as follows:

  • Installation and configuration of SQL Server (2000, 2005, and 2008 editions)
  • Backups and maintenance set up
  • Performance Monitoring and Tuning at the server level
  • SQL Query Tuning and Optimization
  • SQL Server High Availability set up (Clusters, Database Mirroring, Log Shipping)
  • SQL Server Edition Upgrades
  • Database Replication
  • SQL Server Integration Services (SSIS) Development
  • SQL Server Reporting Services (SSRS) Development
  • Stored Procedure Development (Transact SQL)
  • General SQL Server Troubleshooting

This list is a general listing of areas where we can provide assistance, but it is not comprehensive. Please contact us today for a free consultation. We are flexible and always strive to meet our customer’s SQL Server needs in all areas.

Monthly Maintenance Agreements:

Our monthly maintenance agreements offer our clients comprehensive coverage in each of the following areas:

Installation and configuration of SQL Server (if necessary):

We will conduct a thorough review of your business needs and devise the best configuration plan for your business. An action plan will be developed and scheduled for implementation at a time that is most convenient for your business. Our goal here will be to find the best SQL Server set up that will compliment the way that your business works, and to then implement it while causing the least amount of interruption to the daily workings of your office.

Security Patch Management:

We will continually monitor for new security patches from Microsoft and evaluate the need to apply them to your environment. If and when security patches are required for your server(s) we will then schedule off hours deployment of the new patches so as to cause the least amount of disturbance.

Custom built backup and recovery plans:

Comprehensive backup and recovery plans will be designed and implemented to keep your crucial data safe. Built specifically to suit your server(s), our backup and recovery procedures are designed to make certain that in the event of a catastrophic failure all of your crucial SQL Server data is always recoverable in a timely fashion.

Custom built maintenance procedures:

Daily, weekly, and monthly maintenance processes will be tailored for your server(s) to keep them operating at peak efficiency. Not every server is the same, this is particularly true when talking about SQL Server. Our database administrator will conduct a thorough analysis of how your server is used by your organization and what particular loads it is responsible for handling. The essential preventative maintenance that SQL Server requires will then be custom coded and scheduled in a manner that best compliments the workload that your SQL Server(s) need to accomplish.

Daily health checks (Both automated and Live):

The status of your server(s) will be monitored by our database administrator on an ongoing daily basis. Custom reports detailing the health of your server(s) will be designed and distributed through email to both yourself and our SQL DBA. Additionally automated e-mail alerts will be set up to alert both yourself and our SQL DBA to emergency conditions as they are developing, so that fast action may be taken in order to avoid getting into a situation where the server stops responding.

Subject area expertise:

Our SQL DBA is an available resource that you can call upon when faced with having to evaluate SQL Server related products or projects for your business. You can draw upon this expert level resource to help you make the best SQL Server related decisions for your business.

Reduced SQL project rate:

As one of our monthly customers you will receive a greatly reduced hourly rate of $25.00 per hour for individual projects that fall outside of the monthly plan coverage. This is a savings of $50.00 per hour off of the normal hourly rate for individual projects.