Lesson 1 - Getting Started on SQL Server 2008

SQL Server 2008 comes in many different editions. The edition you choose will depend on your requirements. If you are looking for a free database management system, you will need to choose one of the Express editions or the Compact edition. You could also try the Evaluation edition, which allows you to trial SQL Server 2008 for 180 days.

Enterprise Edition

• Data management and business intelligence platform providing enterprise class scalability, high availability, and security for running business-critical applications
• Standard Edition
  Data management and business intelligence platform providing ease of use and manageability for running departmental applications
• Workgroup Edition
  Data management and reporting platform providing secure, remote synchronization, and management capabilities for running branch applications
• Developer Edition
  May be installed and used by one user to design, develop, test, and demonstrate your programs on as many systems as needed
• Web Edition
  A low-TCO, scalable, and manageable database option for web hosters and end customers looking to deploy publicly facing web applications and services
• Express Edition
  A free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs
• Compact Edition
  A free, SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and web clients
• Evaluation Edition
  This edition may be installed for demonstration and evaluation purposes until an expiration period of 180 days.

SQL Server 2008 Requirements

Hardware Component	Requirement
Processor	Pentium III 2-Ghz processor (32-bit or 64-bit)
Memory	2GB
Hard disk	280 MB - Minimal Install 1700 MB - Full Install Installation process requires 2 GB of free space on system drive

 

Software Component	Requirement
Operating system	Windows XP (SP2) Windows Server 2003 SP2 Windows Vista,windows 7,windows 8 Windows Server 2008,2012
.Net Framework	.Net Framework 3.5
Windows Installer	Windows Installer 4.5 or later
Microsoft Data Access Components (MDAC)	MDAC 2.8 SP1 or later
Microsoft Internet Explorer	Internet Explorer 6 SP1

Launching SQL Server 2008 Management Studio


Hope you got it understood well :-)

Thanks & Regards

Srikanth Goud- Virtualization Administrator