Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
Portable and precise, this pocket-sized guide delivers ready answers for administering SQL Server 2008. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to solve problems and get the job done-whethe...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627615906719 |
Tabla de Contenidos:
- Microsoft® SQL Server® 2008 Administrator's Pocket Consultant; Introduction; How Is This Book Organized?; Conventions Used in This Book; Support; I. Microsoft SQL Server 2008 Administration Fundamentals; Microsoft SQL Server 2008 Editions; SQL Server and Windows; SQL Server Logins and Authentication; Service Accounts for SQL Server; Using the Graphical Administration Tools; Using the Command-Line Tools; SQLCMD; Other Command-Line Tools; Using the SQL Server PowerShell; Running and Using the SQL Server PowerShell; Working with SQL Server Cmdlets; 2. Deploying Microsoft SQL Server 2008
- Using SQL Server 2008 for Relational Data WarehousingUsing SQL Server 2008 for Multidimensional Databases and Data Mining; Using SQL Server 2008 for Managed Reporting; Planning for Your SQL Server 2008 Deployment; Configuring the I/O Subsystem; Ensuring Availability and Scalability; Ensuring Connectivity and Data Access; Managing SQL Server Configuration and Security; Running and Modifying SQL Server Setup; Installing a SQL Server Instance; Adding Components and Instances; Repairing a SQL Server 2008 Installation; Upgrading Your Edition of SQL Server 2008; Uninstalling SQL Server
- 3. Managing the Surface Security, Access, and Network ConfigurationConfiguring SQL Server Services; Managing Service State and Start Mode; Setting the Startup Service Account; Configuring File Streaming; Configuring Service Dump Directories, Error Reporting, and Customer Feedback Reporting; Managing the Network and SQL Native Client Configuration; Specifying the Shared Memory Network Configuration; Specifying the Named Pipes Network Configuration; Specifying the TCP/IP Network Configuration; Using Static TCP/IP Network Configurations; Using Dynamic TCP/IP Network Configurations
- Configuring Security for Native Client ConfigurationsConfiguring the Native Client Protocol Order; Configuring the Shared Memory Native Client Configuration; Configuring the Named Pipes Native Client Configuration; Configuring the TCP/IP Native Client Configuration; 4. Configuring and Tuning Microsoft SQL Server 2008; Working with System Stored Procedures; Techniques for Managing SQL Server Configuration Options; Working with SET Options; Working with Server Options; Working with Database Options; Managing Database Compatibility; Configuring SQL Server with Stored Procedures
- Executing Queries and Changing SettingsChecking and Setting Configuration Parameters; Changing Settings with ALTER DATABASE; II. Microsoft SQL Server 2008 Administration; Connecting to a Specific Server Instance; Connecting to a Specific Database; Managing SQL Server Groups; Creating a Server Group; Deleting a Server Group; Editing and Moving Server Groups; Adding SQL Servers to a Group; Managing Servers; Registering a New Server in the Registered Servers View; Registering Previously Registered SQL Server 2000 Servers; Updating Registration for Local Servers
- Copying Server Groups and Registration Details from One Computer to Another
