To determine the current state of your server(s), databases, and supporting hardware, to identify the stress points in your current production environment, and to offer alternatives for remediation toward best practices.
Shallow Analysis - to quickly identify serious, immediate problems that are interfering with day-to-day server operations with the goal of getting them under control as quickly as possible.
Deep Analysis - to evaluate every aspect of your server's resources and performance with the goal of obtaining the best possible performance from your investment.
To extinguish urgent, major problems on your server(s) and bring them to a condition of normalcy and predictability as quickly as possible.
Servers, disk/RAID/SAN subsystems, databases, tables, indexes, stored procedures, SQL queries and reports, to ensure optimum server and application performance.
Microsoft offers several options for high availability (HA). I have experience implementing and administrating clustered HA database servers and SANs processing over 1 million transactions per hour.
Best practices cover a broad range of subjects. Best practices need to be tailored to the production server’s environment and the needs of your business. Best practices include subjects such as: server access, database access, and data security; database recoverability in the event of database corruption and/or failures; elimination of contention, blockages, and deadlocks; performance, response times, query and report execution times; reduction of stress on server resources and components; optimum maintenance of database physical and logical structures; optimum SQL query and report implementations; early problem interceptions; and many other topics.
Automation of best practices ensures that your production environment is automatically maintained for optimum reliability and performance.
Automation is a best practice but automation cannot be blindly trusted. There must be verification that automation is working as expected. A DBA must regularly ensure that automation is doing its assigned jobs regularly and with predictable outcomes. That, too, is a best practice. Database server, database, and supporting hardware audits should be performed by a DBA on a regular basis. The recommended, optimum frequency of audits will be determined by factors related to your business requirements.
BI consists of identifying, locating, correlating, quantifying, and reporting on data pertinent to a company’s business. BI must be tailored to a company's business requirements. If data useful to a company's management exists in a database, that data can be located, extracted, organized, and formatted in a useful manner.
From project inception to deployment using the SQL language and SQL Server tools to implement application requirements.