Introduction To Microsoft Sql Server

Introduction to Microsoft SQL Server
Microsoft SQL Server Setup |
|
 
Introduction |
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). |
Wewill 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 XPProfessional, 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.
Introduction to Security |
|
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 theroom 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.
Creating an Administrator Account |
|
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 orcreate 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.
Practical Learning: Creating an Account in MS Wnd XP or Vista |
|
1. StartControl Panel and click User Accounts:
 

2. Click Create New User:
 

3. Type the name for the new account as pkatts:
 

4. Click Next.
Make sure the Computer Administrator radio button is selected
 

5. Click Create Account
6. To assign a password to an account, in the User Account, click the pkatts account
7. Click Create A Password
 

8. In the Type A NewPassword text box, type Password1 and press Tab
9. Type Password1 to confirm and type anything in the last text box:
 

10. Click Create Password
11. In the same way, create another account named gmonay that has administrative rights with the password Password1

Practical Learning: Creating an Account in a Server |
|
1. Log in to Microsoft Windows Server 2003 or 3008 withan account that can create an administrative account
2. To create an account in Microsoft Windows Server 2003 or 2008, on the taskbar, you can click Start -> Administrative Tools -> Active Directory Users and Computers
3. In the left frame, right-click Users -> New User
 

4. Set the First Name as Patricia, the Initials as G, the Last Name as Katts, and the User Logon...