SQL Server 2005 Basics

Ramkumar LakshminarayananRajaram ComputersMahadanapuram, India.ramkumar@rajaramsystems.com

Knowledge of these basics will help you to make decisions about whether the product is right for you, and will help you with the installation process.

Versions of SQL Server 2005 Available

SQL Server 2005 Express Edition SQL Server 2005 Workgroup Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition SQL Server 2005 Enterprise Edition SQL Server 2005 Mobile Edition

SQL Server 2005 Express Edition Easy installation Lightweight management and query editing tool Support for Windows authentication "Secure by Default" settings Royalty-free distribution Rich database functionality, including triggers, stored

procedures, functions, extended indexes, and Transact-SQL support

XML Support Deep integration with Visual Studio 2005

SQL Server 2005 Workgroup Edition

Support for only three gigabytes of RAM

Support for only two CPUs Absence of the Database Tuning

Advisor

SQL Server 2005 Developer Edition

SQL Server 2005 Developer Edition is designed specifically for developers who are building SQL Server 2005 applications.

SQL Server 2005 Standard Edition RAM limited solely by operating system RAM No limit for database size Full 64-bit support Database mirroring Failover clustering Inclusion of the Database Tuning Advisor Inclusion of the full-featured Management Studio Inclusion of the Profiler Inclusion of the SQL Agent Job Scheduling Service

SQL Server 2005 Enterprise Edition

SQL Server 2005 Enterprise Edition includes all the tools that you need to manage an enterprise database management system.

It supports an unlimited number of CPUs and provides all the features unavailable in the other versions of SQL Server 2005.

SQL Server 2005 Mobile Edition

SQL Server 2005 Mobile Edition enables you to easily port corporate applications over to mobile devices.

SQL Server Installation

1. When you launch the setup program, an end-user license agreement appears. You must accept the agreement before proceeding. After clicking to accept the agreement, click Next. The Installing Prerequisites step of the installation process runs

2. After verifying that all the required components were installed successfully, click Next. The Microsoft SQL Server 2005 Setup welcome screen appears

3. Click Next. SQL Server 2005 Setup performs a System Configuration Check.

4. Click Next to proceed to the next step of the wizard. The Registration Information step of the installation process appears

5. Fill in the required information and click Next. The Feature Selection step of the wizard appears. The wizard helps you select what features are installed on your computer and how the setup process will install them.

6. If desired, click Disk Cost to view the space available on each drive. The Disk Cost step of the wizard appears

7. Click Close to close the Disk Cost dialog and then Next to proceed with the wizard. The Authentication Mode step of the wizard appears. Here you must determine whether your server will accept only Windows logins, or whether it will also support SQL Server logins.

8. After making your selection, click Next to proceed to the next step. The Error and Usage Report Settings dialog appears. Here you determine what happens when an error occurs (where SQL Server will send error reports), and whether you want Microsoft to receive information automatically about your feature usage.

9. Click the appropriate check boxes and click Next. The Ready to Install step of the wizard appears. The dialog shows you what components the SQL Server 2005 Express Edition Setup will install

10. Click Install to complete the process. After a moment the Setup Progress dialog appears

11. Click Next when setup is finished. The Completing Microsoft SQL Server 2005 Setup step of the wizard appears

Installing the database engine is generally not enough. You will have no way to manage the server and its objects. This is where SQL Server Management Studio Express fits in. Microsoft provides a separate installation program for SQL Server Management Studio Express. To run it, follow these steps:

1. After the installation wizard launches, a welcome screen appears

2. Click Next. The License Agreement step of the wizard appears.

3. Click to accept the license agreement.4. Click Next. The Registration Information

dialog appears 5. Fill in the registration information and click

Next. The Feature Selection step of the wizard appears

6. Select the desired features and click Next.

7. The Ready to Install the Program step of the wizard appears. Click Install to complete the process.

8. When the installation process is complete, the Completing the Microsoft SQL Server Management Studio Express Setup step of the wizard appears. Click Finish.

Getting Started with the SQL Server Management Studio Express

SQL Server Management Studio Express is the tool that you use to manage your SQL Server and its objects. Using this tool, you can create and work with databases, tables, stored procedures, indexes, and much more!

When you launch SQL Server Management Studio Express, the Connect to Server dialog appears. Here you provide login information.

Provide the server name and the type of authentication and then click Connect. If you are successful, you are placed in SQL Server Management Studio Express

Summary It is always important to learn the basics of

a product before forging on to more advanced techniques.

This hour began by describing the versions of SQL Server 2005 available so that you are better equipped to make the decision as to which version of the product is right for you.

You then learned how to install SQL Server 2005 Express Edition. Finally, you got a brief overview of SQL Server Management Studio Express.

Quiz1.Name the version of SQL Server 2005 designed for

small businesses or departments in larger enterprises.2.What version of SQL Server 2005 supports four CPUs?3.SQL Server 2005 Developer Edition enables you to

create databases of any size (true/false).4.Name the management tool available for SQL Server

2005 Mobile Edition.5.You are prompted for authentication model during the

installation of the SQL Server 2005 Express database engine (true/false).

6.Name the management tool you use to manage SQL Server 2005 Express databases.

7.Name the tree view that enables you to view the objects managed by your SQL Server.

Answers

1.SQL Server 2005 Workgroup Edition.2.SQL Server 2005 Standard Edition.3.True. It is exactly like Enterprise

edition except for licensing.4.SQL Workbench.5.True.6.SQL Server 2005 Express Manager.7.Object Explorer.