Chapter 2. Configuring SQL Server 2008

IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:

CONFIGURE THE SERVER PLATFORM (Pages 42 – 50)

  • Configuring System Memory (Page 42)

  • Planning System Redundancy (Page 46)

CONFIGURE SQL SERVER 2008 (Pages 50 – 73)

  • Configuring the Server with the SSMS (Page 50)

  • Configuring the Server with TSQL (Page 64)

  • Configuring the Services (Page 66)

One of the strengths of SQL Server 2008 is that it can be adapted for numerous implementation scenarios. In a way, that is also one of the greatest frustrations for a database administrator (DBA). In the old days when there were few, if any, alternate configurations that SQL Server could reasonably support, it was much easier to configure the server platform and the SQL Server ...

Get SQL Server® 2008 Administration: Instant Reference 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.