Chapter 6. Configuring Microsoft SQL Server with SQL Server Management Studio

In this chapter:

Managing the Configuration with SQL Server Management Studio

Determining System and Server Information

Configuring Authentication and Auditing

Tuning Memory Usage

Configuring Processors and Parallel Processing

Configuring Threading, Priority, and Fibers

Configuring User and Remote Connections

Managing Server Settings

Managing Database Settings

Adding and Removing Active Directory Information

Troubleshooting Configuration Problems

SQL Server 2008 replaces Enterprise Manager with SQL Server Management Studio to complement the expanding role of SQL Server administrators and developers. SQL Server Management Studio provides the easiest way to configure SQL Server. In ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial