When you installed SQL Server, you also installed several databases by default. Although some of them are more important than others, they all serve some function and can assist you as you move through your own projects. Some of them —and this is critical— absolutely should not be altered; otherwise, you run the risk of doing serious damage to your SQL Server installation and the data stored within your individual databases! That said, the following sections will take you through each of these installed databases so you will know what each one does (and so you will know which ones not to mess with).

1. If it’s not already running, start the SQL Server Enterprise Manager.
2. Expand the Databases node.
3. Although you’ll learn about the individual database components a bit later in this chapter, go ahead and expand one of the individual database nodes so you can see how the components are presented.

 Now that you have the default databases accessible and on your screen, take a closer look at each one.

• Master. The master database is the keeper of a great deal of administrative and functional control information for your entire SQL Server. That said, there is very little reason for you to change the values contained therein. (As a matter of fact, you probably shouldn’t touch this database unless you have a very good reason.) Important administrative functionality, such as storing all user login IDs; specific system configuration settings; names, information, and the location of each database contained within the server; and the initialization configurations of SQL Server, is kept within the master database. So again, unless you’ve got a good reason… leave it alone.
• Tempdb. The tempdb database houses temporary information (not surprising, given its name) for not only the queries you execute, but for SQL Server itself, because various transactions and processes are executed within the application. You can use the tempdb database to temporarily store information for your procedures. This is fine as long as you remember that as soon as the database refreshes itself, the data stored within tempdb will be lost. I’ll talk more about tempdb later in this chapter and in other chapters. For now, though, recognize its general functionality and usefulness as a temporary data storage location. It is also used extensively with SQL Server’s Data Transformation Services.
• Model. The model database is useful because you can indeed "model" your databases (and the specific components within them) so that they all share a uniform structure. For example, if you wanted every database on your SQL Server to contain a specific table, you could include this information with the model database. Note, however, that this only works for new databases that are created.
• Northwind. If you’ve worked with Microsoft Access, you are undoubtedly familiar with the Northwind sample database. (You already accessed it to run some of the query examples in the third project, when you worked with the Database Results Wizard, a feature of FrontPage.) Although you can manipulate or alter the Northwind database to your heart’s content, it’s probably a good idea to leave it alone so you have a reference database to fall back on in case you run into trouble in other areas of SQL Server, or you need to test a query or procedure on a predefined set of data (the information contained with the Northwind database) as opposed to your actual live data.
• Pubs. Another sample database, the pubs database is based on a fictitious publishing company. Like the Northwind sample database, you can alter this any way you want, but it might be useful to leave it fairly unchanged so you can use it as a data reference.
• Msdb. Like the master database, you probably should not alter the msdb database. Used to control the functioning of various processes within SQL Server, any change in this database could have adverse results on other critical function areas of your server.

Clearly, the worldwide scope of the W3C—with member organizations and offices located throughout the world—demands that the Consortium have a well-defined focus if it is to succeed and help develop the Web to its full potential. Fortunately, this is indeed the case; the mission and vision of the W3C are clearly defined. Although the Consortium’s mission and vision are described in more specific detail on their Web site (and in various supporting documents), their own seven-point summary serves as a neat capstone to the organization’s central goals.

1)    Providing universal access. With the growing popularity (and functionality) of access devices such as Web-enabled cell phones and PDAs, it seems that people want access to the Web regardless of their location. As a result of this increasing push for Web access on demand, the W3C has a primary goal to not only encourage this (universal) access initiative, but also to help ensure that you have equal access to the Web and the information it contains, regardless of what access device you are using, where you are physically located, what culture you belong to, or even your physical or mental ability.

2)    Enhancing the meaning of information. This article was written specifically for "human consumption"; in other words, it was written in a language that was intended for human beings to read and understand. But what if the information contained in this article could be manipulated so that computers—free of human interaction—could understand it too, and in turn present the findings of their "reading" for quicker manipulation? This is the goal of the W3C’s push toward the "semantic Web" and the additional languages—RDF, XML, and so on—being developed to aid in this process. The idea is to make it easier to exchange and manipulate information in potentially faster and more efficient ways than just using plain text. (In the process, this will aid in the primary goal of universal access.)

The Text Alignment Attribute
HTML includes an align attribute that allows you to do some basic text alignment in your Web pages. As with everything else, the best way to see this attribute in action is to look at a code example.

<p align="left">This text is left aligned.</p> <p align="center">This text is center aligned.</p> <p align="right">This text is right aligned.</p>

The <p> tag simply puts a paragraph break between each line.

Consisting of more than 430 member organizations worldwide, the W3C is committed to developing the Web to its full potential by making technical recommendations and, in the process, by developing protocols with the aim of producing a common, functional infrastructure for true interoperability across all facets of the Web. A collaborative effort, the W3C is hosted by MIT/LCS (Massachusetts Institute of Technology Laboratory for Computer Science), ERCIM (European Research Consortium in Informatics and Mathematics), and Keio University, Japan. In addition to these, other support organizations including CERN (European Organization for Nuclear Research) and DARPA (U.S. Defense Advanced Research Project Agency) contribute to the hosting and support of W3C.

Visit the W3C on the Web at http://www.w3c.org. In addition to current news updates on developing projects, you can view a complete background of the organization, links to member organizations, and fascinating historical archives and documents related to the Web’s history and evolution. Check it out!

Is basic html an outdated technology?
So why should you care about the W3C and its activities? Well, most importantly, you should realize that the basic HTML that is described and illustrated in this book is a somewhat old technology.

One of the best investments in your SEO time is targeting the proper keywords for the type of people you want visiting your site. By explicitly choosing and targeting keywords on your site, you can maximize your site placement (and even page placement) on the search results list.

While it is most important to target the proper keywords for your main page, it is also very useful to per- form the same targeting functions on your most important articles. Each page that ranks highly on the search engine will increase the amount of traffic on your site, as well as the likelihood the visitor will look at other content on your site. It is essential that you get the visitors “in the door.”

Creating a Keyword Starter List
To obtain good ranking on the search engines, you need to know what popular keywords relate to the topic area of your Web site. For example, if your Web site focuses on personal improvement, do people enter “personal improvement” into the search engines when they are looking for your type of site? Or, do they instead look for “self help,” “self improvement,” or “life coaching”? Until you know this information, your site placement will depend more on luck than anything else.