We will provide lessons and other topics on how to use Microsoft SQL Server 2008.
In order to follow the lessons on this site, you must have access to a computer in which Microsoft SQL Server 2008 is installed. To start, you must have a computer that runs an appropriate operating system. If you are just learning, which is assumed for all lessons on this site, you can use a Microsoft Windows XP Professional, Microsoft Windows Vista, or Microsoft Windows Server 2003.
To use Microsoft SQL Server, you must install it on a computer. You can install it on Microsoft Windows XP Professional, Microsoft Windows Vista, Microsoft Windows Server 2003, or Microsoft Windows Server 2008. This means that you should take care of the operating system first.
Before installing Microsoft SQL Server 2008, make sure you have installed all service packs on your operating system. If you plan to use Microsoft Visual Studio 2008 to create Microsoft SQL Server 2008 databases, you should install Microsoft SQL Server 2008 first, then install Microsoft Visual Studio 2008.
One of the main concerns of a database is security, and this is central to Microsoft SQL Server. Security is exercised at different levels: in the room where the computer(s) is(are) located (the computer(s) that hold the server application (Microsoft SQL Server) and the computer(s) that will use(s) the databases (clients)) and the people who will use all these resources.
When it comes to the room that houses the computer on which you will install Microsoft SQL Server, you should make sure the room can be locked at any time and only a few selected people have access to it. For maximum security, you should also put the computer in a locked closet.
To actually install Microsoft SQL Server 2008, you must use a user account that has the ability to install it. If you are using Microsoft Windows XP or Vista, you should use the Administrator account or create a new account that has administrative rights. The account you will use must also use/have a password. In Microsoft Windows XP Professional or Vista, to use the Administrator account, assign a password. Alternatively, after logging in as Administrator, create an account that has administrative rights.
A security principal is a person or an object that needs access to a database. The security principal can be considered as one entity or as a group of entities:
This means that a security principal can be considered as a lone entity or as part of a group. For example, a person who accesses a database can be considered an entity. A group of people who exercise the same function and have been give the same function(s) on a database is considered a collection.
To create a group in Microsoft Windows Server 2003 or 2008, open the Active Directory Users and Computers. Right-click the Users node -> New -> Group:
In the New Object - Group dialog box, give a name to the new group. Make the necessary selections in the Group Scope and the Group Type:
When you have finished, click OK. After creating a group, you can use it. To use a group, you can add one or more existing users to it. To do this, locate the group and double-click it or right-click the group and click Properties:
Add the necessary information.
To control the type of access that a security principal can exercise on a machine or a database, it works or acts on a level. There are three levels: Windows, server, and database:
Based on the functionality of a security principal, it can be considered as belonging to a collection.
To help the operating system identify them, each security principal uses a unique number called a security identifier (SID).
A role is an action or a set of actions that are granted to a security principal. For example a person A can be allowed to create and use a database. The ability to perform such an action is referred to as a role. Another person B can be allowed only to use an existing database without being able to create a new one. This is another type of role.
In order to access something (such as a computer or a database), the object must be authenticated. Such an object can use a username and a password and use the group it belongs to. For this reason, the ability to be authenticated in order to access the database or resource is called a login.
We will see how to create a login in Lesson 3.
To make it possible for you and other students to study databases and SQL, Microsoft made available a trial version of Microsoft SQL Server 2008. This full version is available from the Microsoft web site. To get the trial edition of Microsoft SQL Server 2008, go to the Microsoft web site, do a search on "trial software", and follow the links to locate the trial edition of Microsoft SQL Server 2008 Enterprise Edition (this is a very big file: 3GB).
You can download from any computer that has enough space and can allow you to create a DVD.
If you are downloading, the file will be saved in your computer. When the download is over, you must create an image. After creating the DVD image, you can insert the DVD in the drive.