SQL Server Performance improvement
How to know badly performing code and ways to improve it.
Identify blocking or deadlocking activities
Identify hardware bottlenecks
Identify database and/or application design issues.
SQL Server Configuration
Confirm that your SQL Server is installed and configured correctly
Confirm that your hardware resources are adequate and configured correctly
SQL Server Security
Assess your vulnerability to sql injection and other attacks
Suggest security best practices in relation to your needs
SQL Server Disaster Recovery Plan
Design bulletproof backup plan
Suggest high availability options to keep your database on-line when a failure occurs.
Scalability of Your SQL Server Installation
Evaluate the ability of your current system to scale to projected levels.
