1-    SQL server 2008 Architecture

-          Transaction Log and Database Files

-          SQL Native Client

-          System Databases

-          Schemas

-          Synonyms

-          Dynamic Management Views

-          SQL Server 2008 Data Types

Editions of SQL Server

-           Compact (32-bit only)

-          SQL Express (32-bit only)

-          Workgroup Edition (32-bit and 64-bit)

-          Web Edition (32-bit and 64-bit)

-          Standard Edition (32-bit and 64-bit)

-          Enterprise, Evaluation, and Developer Editions (32-bit and 64-bit)

-          Operating System

-          Maximum Capacity of SQL Server

-          Database Features By Edition

 

2-    SQL Server 2008 Installation

Planning the System

-          Hardware Options

-          Software and  Install Options

Installing  SQL Server

-          Side-By-Side, Upgrade and New Installs

-          Scripted Installation

-          Remote Installation

-          Local Installation

-          Where Are the Sample Databases?

Installing Analysis Services

Burning in the System

Post-Install Configuration

-          SQL Server Configuration Manager

-          SQL Server Management Studio

-          Tempdb

-          Back it Up

Uninstalling SQL Sever

-          Uninstalling Reporting Services

-          Uninstalling Analysis Services

-          Uninstalling  the SQL Server Database Engine

Common Installation Issues

-          Installing Client Tools from a Network Share

-          Minimum Configuration Warning

Troubleshooting a Failed Install

3-    Managing and Troubleshooting the Database Engine

Configuration Tools

-          SQL Server Configuration Manager

-          Dedicated Administrator Connection

-          Configuration Servers and Server Groups

-          Startup Parameters

-          Startup Stored Procedures

-          Rebuilding the System Databases

Management Studio

-          Reports

-          Configuring SQL Server

-          Filtering Objects

-          Error Logs

-          Activity Monitor

-          Monitoring Processes in T-SQL

Trace Flags

Getting Help from Support

-          SQLDumper.exe

-          SQLDiag.exe

 

4-    Automating SQL Server

Maintenance Plans

-          Maintenance Plan Wizard

-          Maintenance Plan Designer

SQL Server Agent

-          Automation Components

-          SQL Server Agent Security

-          Configuring SQL Server Agent

-          Database Mail

-          Multiserver Administration

 

5-    Securing the Database Engine

Security Principles

-          The Principle of Least Privilege

-          The CIA Triad

-          Defense in Depth

Creating a Secure Configuration

-          New Security Features in SQL Server 2008

-          Operating System Security

-          Operating System Security and SQL Server

 Surface Area Configuration

Endpoints

-          Typical Endpoint Configuration

-          Other Endpoints

-          Windows Authentication Changes in SQL Server 2008

Identity and Access Control

-          Server Principals/Logins

-          Credentials

-          Users

Schemas

-          Schema Example

-          Changing Schemas

-          User/Schema Separation

-          Changing the Schema Owner

-          INFORMATION_SCHEMA and sys Schemas

Securables and Object Permissions

-          Ownership Chaining

-          Cross-Database Ownership Chaining

-          Permission Context

-          EXECUTE AS Command

-          Troubleshooting Permissions Issues

Encryption

-          Setting Up an Encryption Methodology

-          Encrypting the Data

-          Creating a Helper Function Example

-          Column-Level Permissions

-          Transparent Data Encryption (TDE)

-          Extensible Key Management (EKM)

SQL Server Audit

-          Creating an Audit

-          Creating and Enabling a Server Audit Specification

-          Creating and Enabling a Database Audit Specification