What do we need to learn if want to be a SQL Server's generalist ?

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.

转载于:https://www.cnblogs.com/TerryX168/p/5634334.html