Database Administrator Consultant

 All the benefits of having a full-time DBA, without the disadvantages. Your SQL Server can be fully managed by a DAC, who is hired to work only part-time, but is available full-time as needed. SQL Server comes with many tools to easily manage your server, but most sites want and actually need more than those basics.

DAC's have developed, through best practices, a set of master databases that can be used to fully manage your data needs. They are easily installed, are server specific, use generic table driven routines, using a few simple parameters. They are fully customizable to meet your needs. These are add-on functionality procedures, and do not effect any existing procedures or routines already in place. Each database may be set up individually.

Using the DAC database toolset, backups, maintenance routines, DBA Reports, logshipping, login/user maintenance, can all be easily set up to fully manage your SQL Server. Most sites' SQL Servers are fully setup and implemented in less than a day.

DAC's are always on-call, available for emergencies, and have the experience to handle them.

DAC's have world experience with, and understand, best practices.

Using the DAC's DBA Reports, which shows at a glance, in HTML format, emailed, or available on the server, everything required to understand the current status of the server.

Using this tool, the DAC can manage competently and fully, cutting outstanding server issues down to none, in a systematic and logical way.

DAC's also use a set of Query Analyzer templates that use the common settings for key procedures, like Server Activity, which helps determine server slowness, blocking processes, CPU usage and more. Besides Server Activity, additional templates report on Unsuccessful jobs, SQL Errorlog errors, SQL job history and errors, DTS logfiles history and errors, SQL job step durations and more. Site specific templates may also be created to run procedures, standard or individually developed for your specific needs, providing DAC's a quick and simple way to provide you answers to your company's needs.

DAC's can set up your server to use SQL Mail or CDOSYS routines, using your SMTP server for alerts or reports, emailed from the server.