Preparing for SQL Server 2008 Installation for C# Developer as described on MCTS certification exam 70-432

This section contains all the review items completed in February 25th 2011, for you my colleagues!

Outline lectures Installing and Configuring SQL Server 2008 Exam 70-432 Objectives: Install SQL Server 2008 and related services Configure independent SQL Server Instances Configure correctly SQL Server services Configure Additional SQL Server components Implementation of Database Mail. Lessons covered in the chapter #1: Lesson 1: Determine Hardware and Software Requirements Lesson 2: Selecting SQL Server Editions Lesson 3: Installing and Configuring SQL Server instances Lesson 4: Configuring Database Mail

Before you begin (general suggestions): Hardware requirements fulfillment, SQL Server 2008 Installation Media (CD/DVD). To be sure How your SQL server instance is going to be used before installation (backwards means loosing too many time in reinstallation). Most common errors are: undersizing hardisk requirements, undersizing tempdb disk space. Taking into account concurrent users, final database size on disk drives, and configuring other services such as Service Broker, CLR, replication, clustering, data types, filestreams, and so on. The minimum requirements are specified for SQL installation purposes. Later on you will be able to get more information to make a good guess in software and hardware requirements: number and type of CPU, OS requirements, disks drives and so forth, for a given application. Hardware SQL Server Requisites 32 bits 64 bits  Processor  Processor Speed  Memory  Pentium III or higher  1.0 GHz or higher  512 MB Itanium, Opteron, Athelon, or Xeon/Pentium w/EM64T support 1.6 GHz or higher 512 MB Hard disk requirements should be reviewed at "Hardware and Software Requirements for installing SQL Server 2008"