Home \ Blog
Jan 27
2010

Installing SQL Server 2000

Posted by: admin in Uncategorised

Tagged in: Untagged 

Now that you have a general understanding of the different variations of SQL Server 2000, it’s time to install. Again, for this example, I am installing the Standard Edition.

  1. Insert the SQL Server installation CD into your CD-ROM drive. After a few moments, the autorun installation welcome screen will appear.
  2. Click on SQL Server 2000 Components. From the list of options that appears, click on (for now) the Install Database Server option.
  3. The installation wizard will begin. Click on Next.
  4. The next screen asks you to enter the name of the computer on which you want to install an instance of SQL Server 2000. Select the Local Computer option.
  5. Click on Next. In the dialog box that appears, select Create a New Instance of SQL Server.
  6. The next two dialog boxes ask you to enter your name and company (if applicable) and accept the standard Microsoft licensing agreement. You are then presented with the screen, which asks you to pick the type of installation. For this installation, chose Server and Client Tools.
  7. The next screen asks you to provide an instance name. Provide a descriptive title, then click on Next.
  8. As with most standard software installations, SQL Server 2000 now prompts you for the type of custom installation you prefer. Leave the default setting as Typical, but note the space requirements and the other installation options.
  9. You are next asked to provide information on the service accounts used to access SQL Server. For this dialog box, leave the default setting as Domain User Account, but go ahead and enter some type of password that satisfies the usual requirements—easy for you to remember, hard for others to guess. Don’t leave the password blank because that will make you an easy target for unauthorized access.
  10. Just a few steps left! Select Mixed Mode and be sure to enter a password for the SA (system administrator).
  11. Click on Next. The installation wizard will tell you it has enough information to proceed with the installation. Click on Next. After a few moments, you will see a confirmation screen telling you that the setup is complete. Click on Finish and reboot your server. (You might be asked to do this, but if not, you should go ahead and reboot anyway.)

Understanding Security: Working with Windows Services
SQL Server 2000 runs as a Windows service, which in a nutshell means that if there is any problem with SQL Server, Windows can take care of it without a great deal of human intervention.

You can set specific SQL Server configuration options by navigating through the Services option, under Administrative Tools. (Note that this only works on Windows NT, 2000, and XP because services don’t exist on Windows 9x operating systems.) This Services option is in the Administrative Tools Control Panel applet.

Comment (0) | Read More...
Jan 26
2010

SQL Server 2000 editions

Posted by: admin in Uncategorised

Tagged in: Untagged 

You can really take your Web design to the next level by integrating a database. By doing so, you can make your Web pages dynamic in the sense that you can interact more directly with your visitors by not only capturing information they provide (such as shipping address and customer feedback), but you can also present customized information to your visitors based on their preferences. For example, perhaps the first time they visit your site they complete a customer survey form. Then the next time they visit, you query this information in your database and present only the information, products, and services in which they are interested.

As you will see, setting up and actually integrating a SQL database into your Web site isn’t too difficult.

Perhaps the best place to start is with the actual installation of SQL Server 2000. But before you launch into that, you should be aware of the different flavors of SQL Server 2000.

Comment (0) | Read More...
Jan 25
2010

HTML terminology

Posted by: admin in Uncategorised

Tagged in: Untagged 

General HTML Page Layout Tags
Every HTML page will (or should) have some basic tags.

  • <HEAD>. Think of this tag as the container for all of the general layout information for your page. Within the <HEAD> and </HEAD> tags, you will find general information about your page. (As you will learn later, some of this information is useful in identifying your page to search engines.) Note, however, that except for the title, none of the information contained within the <HEAD> tag will be displayed to your viewers.
  • <TITLE>. This is where you assign the all-important title to your Web page. It’s easy to overlook this tag, so you should be careful that you don’t; the title of a page will appear at the top of the browser window, and is thus an important navigation element to let visitors to your Web site know where they are.
  • <BODY>. This is where most of your HTML code is placed; as such, it corresponds to the body of your Web page content.

Many HTML editors, such as FrontPage or HomeSite, will present you with a basic Web page template when you select File, New. The <HTML>, <HEAD>, <TITLE>, and <BODY> opening and closing tags are presented within this template (see the following code listing). Take advantage of this template to remind yourself to include these important tags within your document (in other words, don’t delete them)!

Utilizing the <META> Tag
<META> tags are quite useful in providing information about the contents of your page so it can be picked up and properly indexed by various search engines. The previous code listing was generated using Microsoft FrontPage, which inserted some default <META> tag information in the opening page template. More than likely, you’ll want to tweak these <META> tags so they are more illustrative of the content that actually exists on your page.  

Comment (0) | Read More...
Jan 24
2010

WordPress Basics

Posted by: admin in CMS

Tagged in: wordpress

Key Components of a WordPress Site
There are some things that need a bit of explaining before we get much deeper. For lack of a better term, we’ll call them “components.” Components represent the main parts of a WordPress site, including the actual files that make things go, and the database that houses all of the data. Together, these two components - the files and database - generate the web pages for your site. Once generated, there are two central types of these web pages, the Admin area that only you see, and the public pages that the whole world can see. Let's take a closer look at each of these different components.

WordPress Core Files
When you go to WordPress.org and download a copy of WordPress, you are down­loading the WordPress core files. It’s a big folder full of files and a few subfolders full of even more files. Once you download and unzip the WordPress package, you’ll notice that most of the file and folder names begin with a “wp-” prefix.

The WordPress core files are the things that make WordPress tick, the things that make WordPress a complete software package. Most of these files you’ll never touch. A few of them you’ll touch very rarely, and a certain subset of these files you’ll be in and out of all the time, especially when building a theme.

Comment (0) | Read More...
Jan 24
2010

Absolute and Relative URLs

Posted by: admin in Uncategorised

Tagged in: Untagged 

The URL (Uniform Resource Locator) is a major building block of the Web. For this discussion, you need to be aware of the difference between absolute and relative URLs and how each one can affect your HTML coding. In an absolute URL, the address includes the entire file location (including the server name). A relative URL only shows the file name relative to the current location.

For example:

http://www.someweb.com/somefolder/somefolder_2/somefile.html somefile.html

Comment (0) | Read More...
«StartPrev1234NextEnd»

Categories

Latest posts from our blog...

Did you know?

Most providers forget that web hosting is, and always was, a service, not a product. You must be very carefull when you are searching for a reliable and an affordable company in order to host your new website.

Tags

Archive

Copyright © 2009 Webhostingart.com. All rights reserved unless otherwise stated.