SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you toured the various GUI administration tools provided with SQL Server 2008. You began by looking at the SQL Server Configuration Manager (SSCM) and using it to manage services, service accounts, and protocols. Next, you used the SQL Server Management Studio (SSMS), the primary administration tool for SQL Server. You learned to configure the SSMS interface and use the scripting options so that you can document and automate administrative tasks.

The SQL Server Business Intelligence Development Studio (BIDS) was explored next. You learned about solutions and projects and how to create, manage, and delete them. Next, the SQL Server Profiler was introduced. You learned to create a trace of SQL Server activity using this ...