Microsoft SQL Server 2008 R2 Unleashed- P7:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 14 CHAPTER 1 SQL Server 2008 Overview Enable and disable features of SQL Server Manage and organize scripts into projects and save versions in source control systems such as Visual SourceSafe NOTE Much of SQL Server Managements Studio s interaction with SQL Server is done through standard T-SQL statements. For example when you create a new database through the SSMS interface behind the scenes SSMS generates a CREATE DATABASE SQL statement to be executed in the target server. Essentially whatever you can do through the SSMS GUI you can do with T-SQL statements. As a matter of fact nearly every dialog in SSMS provides the capability to generate the corresponding T-SQL script for the action s it performs. This capability can be very useful as a timesaver for tasks that you need to perform repeatedly avoiding the need to step through the options presented in the GUI. If you re curious about how SSMS is accomplishing something that doesn t provide the capability to generate a script you can run SQL Profiler to capture the commands that SSMS is sending to the server. You can use this technique to discover some interesting internal information and insight into the SQL Server system catalogs. SQL Server Configuration Manager SQL Server Configuration Manager is a tool provided with SQL Server 2008 for managing the services associated with SQL Server and for configuring the network protocols used by SQL Server. Primarily SQL Server Configuration Manager is used to start pause resume and stop SQL Server services and to view or change service properties. SQL Server Agent SQL Server Agent is a scheduling tool integrated into SSMS that allows convenient definition and execution of scheduled scripts and maintenance jobs. SQL Server Agent also handles automated alerts for example if the database runs out of space. SQL Server Agent is a Windows service that runs on the same machine as the SQL Server Database Engine. The SQL Server Agent service can be started and stopped through .
