In this chapter, you learned some of the key concepts for managing and troubleshooting your SQL Server. You learned how to configure your server using SQL Server Configuration Manager, SQL Server Surface Area Configuration, and lastly Management Studio. We also covered how to monitor the connections in your server using Activity Monitor and some of the key stored procedures and DMVs. Last, we focused on how to use some troubleshooting tools like SQLDumper.exe and SQLDiag.exe to send valuable support information to your next tier in support or to create a baseline. With the key concepts out of the way, we can now drill into more specific areas to manage, such as security. In Chapter 5, you learn much more about automating your SQL Server processes.