This course explores using multiple SQL Server instances and managing connection protocols and service accounts with Configuration Manager. It also covers some key configuration options and how to set them using sp_configure and Management Studio as well as how to set up and use Database Mail and manage Full-Text Indexes.
Objectives:
Differentiate default and named instances
Manage connection protocols and service accounts with SQL Server Configuration Manager
Configure options with sp_configure and SQL Server Management Studio
Setup and use Database Mail
Manage Full-Text Indexing
Topics:
Configuring SQL Server 2008
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
