Buka situs diamkan 30 detik dapet uang

Bagi anda yg ingin menambah penghasilan, mungkin anda bisa join salah satu link dibawah ini. iseng iseng berhadiah, sambil nunggu downloadtan atau email.

daftar gratis,

http://www.zumin-ads.com/index.php?ref=basmal


http://neorupiah.com/register.php?r=basmal


http://www.kumpulrupiah.com/?r=basmal


Atau yang ini per survey dibayar $10 dolar, daftar gratis. gampang kok ngisinya asal aja lagi. lumayankan kalau di rupiahinkan jadi 100rb. ya ela cuma kerjaan dibawah 1 menit ngisi juga cuma asal. kapan lagi...? coba teman teman daftar dech.


http://www.fromhomedataentry.com/members/login.cgi?mode=click&username=basmal

Read More »»

Why is Windows Registry Cleaning Necessary

The configuration and default parameter data stored in the Windows Registry controls the behavior of Windows and all hosted applications and services. Applications are able to interact directly with the Registry to add, change, or remove this data, and the Registry in turn saves altered application data to the permanent hive files from which it is built, retrieving it when the applications are launched. In this way, the Registry is continuously bombarded with changes made by applications, users, and even Windows itself. As new applications are installed and old applications are removed, and as registered applications continue accessing and changing Registry data, they often leave small bits of themselves behind in the form of orphaned Registry entries. Taken individually or over a short time, they're just more stuff your Registry has to go through when it loads. But if they are allowed to accumulate, the combined clutter of all these small errors can become debilitating as the Registry increases in both size and disorganization, causing Windows to frequently stall or crash and eventually preventing it from booting up altogether. For this reason, periodic Windows Registry cleaning will not only optimize your system's performance, but can also extend its life expectancy by keeping the Registry's growth uniform and in check. Software solutions for Windows Registry cleaning There are many third-party Windows Registry cleaning utilities available that can make this necessary cleaning completely painless. These cleaner utilities will scan your Registry for invalid references to items that have been moved or made obsolete. The whole scanning process will generally include the following: Scanning Registry files Before performing the Registry scan, cleaning utilities will scan all your hard drives to build a list of its files and folders. It will later compare items on this list with Registry entries that refer to a file without specifying its full path in order to prevent their incorrect deletion. Scanning Startup If you move or delete executable files that Windows automatically runs upon Startup, the Registry entries referring to the file remain but are invalid and can cause delays and error messages when you boot up your computer. The cleaning utility will scan all entries in the Startup section, and remove any whose files cannot be found. Scanning Shared DLLs (Dynamic Link Libraries) DLLs contain stored functions that can be called on to perform various tasks. Since they can be shared by multiple applications, they are stored in the SharedDLL key of the registry. If a shared DLL is deleted or moved, these registry entries become invalid and applications can't them. If the cleaning utility can't find a DLL that is listed in the ShardDLLs key, the registry entry pointing to the DLL will be removed. Scanning File Extensions If programs are incorrectly or incompletely uninstalled on your computer, the file extension associations may still remain in the Registry as orphans. The cleaning utility will scan File Extension Records and File Type Records in the Registry to check the validity of registered file extensions. It will remove each File Extension record that is not associated with a valid File Type. All File Extension records that contain pointers to a GUID (Globally-unique Identifier) are considered valid, as they are used to uniquely identify OLE/COM classes. Creating Backups Almost all repair and cleaner utilities allow you to easily create and store backups of your registry before scanning or making any changes to your Registry. Whether the Windows Registry cleaning utility you choose does or not, it is very important to create a backup before performing scans or making changes to your Registry.

Read More »»

Search Engine Friendly CMS

A CMS (or content management system) can be a great way to manage a website of any size. One problem that a lot of these content management systems face is that they fail when it comes to meeting SEO standards. Two areas that they tend to create problems are keywords and "search engine friendly" urls. The urls for most cms software are long and complicated, and have little to do with the actual contents of the pages. Around the internet Joomla/Mambo (a cms) seems to be mentioned a lot as a "SEO Friendly" CMS. It has an option for search engine friendly urls, and add-on modules (that I haven't tried) that are supposed to make the urls more related to the content. Another plus of using Joomla/Mambo is that it allows additional keywords for each separate content page. I initially had some problems getting "search engine friendly" urls to work in the Joomla (Mambo) CMS. When I got to looking on the internet I realized that many other people had been having the exact same problems. There were a few answers out there ... but it seemed a lot more questions about how to get this part of Joomla/Mambo to work. Below is a description of the issues that I encountered while setting up search engine friendly urls in Joomla, and the simple solution that I finally came to. This will probably not work for everyone, though I hope a few people looking for answers on the Internet might find this useful. Initially, when I would change the setting under "SEO" in my Joomla CMS (which my site is run on), I would get funky errors and it would break the site. There was a little popup tooltip that said to rename htaccess.txt to .htaccess, which I made sure was done. Here is what the little popup failed to mention. Perhaps I should have known it ... and I probably would have if I were more knowledgeable about this stuff. First off, you have to make sure the .htaccess file is in the CORRECT DIRECTORY. It needs to go in the root directory of your Joomla/Mambo Installation. For example, for my site Joomla is installed under the /cms directory. So the .htaccess file has to be in this directory. Secondly, you need to EDIT the .htaccess file to reflect the correct directory for your installation, etc. Here's what mine looked like when it was done: RewriteEngine On RewriteBase /cms RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*) index.php Once I had my .htaccess file edited correctly, and placed in the correct directory, it worked just fine. At this point all you have to do is select the box under the "SEO" tab in the control panel of Joomla to enable search engine friendly urls. The above is exactly what I had to do to get this to work on my installation of Joomla. Like I said before, it might not work for everyone. I know there are some other issues that people have had but my limited experience prevents me from being able to talk about them here. Hopefully this will help a few people that are having this issue.

Read More »»

Windows vs. Linux?

There has been written alot about this, i know, but i wanted to share my insight to subject.

There are people out there that belive there is no real difference between the two OS, like if Linux just invented the plate again. But this is of course not true in any way, yes its true the way a OS works depends on the setup and skills of the admin. But this does not mean that there are not a difference between Windows and Linux or the many different Linux OS out there (even that they share, the same kernel in some cases).

The main difference between windows and Linux is that Windows is closed source and Linux is Open Source, now some of you might think: yes, and?

Well, this means that with 3 party driver and suchs, you are able to install it directly into the kernel (core) of a Linux OS. But not with a windows, since its closed. This in return means that you will have a better integrated system with Linux, then with Windows and of course this has influence on your OS as a whole. It might get more unstabile, more slow and even have security risks on a windows.

There are of course also other difference between the two like messenger in windows has a lot of ads, where in a Linux you are in a ad free desktop. Linux does not need to run Antivirus and you have a lot of freedom to choose between 10,000+ software packages from a software manager (apt, yum or pacman).This can be used to change your desktop, you could use gnome, KDE, Fluxbox, Xfce or such as desktop.

You also get a lot of tools and default software like Openoffice (linux version of Office), putty (SSH), gftp (ftp client), pidgin (gnome messenger), kopete (kde messenger) and such of a high quality. The best part with Linux and Open Source is that most of it is free and this means you dont have to steal a windows to get a OS, you can just run Linux. ;)

There of course is more software currently to windows and in paticular more games, but if you want high quality games why not buy a playstation or you could just setup a Linux with wine (windows emulator), cedega (game version of wine), snes (super nintendo games) or Vmvare (virtual machines).

The reason there are more software to Windows is only because more people use it, if they used Linux then there would be made more games and software for that OS. ;)

Read More »»

Text To Speech Online

Text to speech or the also called speech synthesis is the artificial production of a human voice. This technology has many applications such as improving accessibility for disabled people allowing visually impaired people or people with reading difficulties to listen to written works on a home computer, providing new services or even in the entertainment field. Most of the modern computer systems have text to speech modules that allow text seen on the screen to be converted into speech. Apart from the personal computer operation system modules there are much software available so it is a matter of choice which one should be used. Of course when making a choice the quality of the speech synthesis should be taken into account.
The quality of text to speech conversion is estimated by its similarity to a human voice, and by its ability to be understood. Apart for the text to speech modules that the modern computer operation systems have and the similar software available, there are many online text to speech resources. They are useful to people who are not able to use their home computer or who do not have the required modules installed. Some of the online speech synthesis services are paid but there are some which are free or with free trials. The online text to speech website has the same or even more options compared to the integrated services. You can choose the type of the voice male or female and usually there is more than one voice available per gender. This is great as this way you can pick up the voice that you understand the best. The voice level and the speed of talking can also be adjusted. The online text synthesis services also feature a variety of languages. Obviously the English language is the most popular but there are many websites that offer a vast variety of language options. This is great news so people of any nationality can benefit from the online services. When choosing an online text to speech program you should check what it can read. Some programs can only read the text from the internet browser or the text from specific text processing programs such as Word. The best option is to get a program that reads from as many sources as possible. Some programs are able to perform dictionary look ups, have magnifying glass tool, translation tool. Some text to speech programs have the option to record the text read. This is a great option since all that is on the screen can be recorded in an MP3 format and listened later.

4dm1n..

Read More »»

website, software, bisnis online, making money: Cara masukin kode html ato script ke blogger

website, software, bisnis online, making money: Cara masukin kode html ato script ke blogger

Read More »»

A little about Linkreferral.com

A blog for Linkreferral.com has been long overdue, I've just been so busy with everything, it's always been on the backburner, which I hope to change now. Along with what's new, and current topics regarding the site, I'll also attempt to touch on other general topics around the internet.

So a little history.... Linkreferral.com (actually the first year under a different domain name) went online originally in 2000, with the one basic component of referral traffic, and has expanded over the years to include a peer review directory, active forums and several other components. It first started when in '99, I was looking for traffic for my own little web development business, I came across a crappy little multi-level advertising page, whereby signing up and referring others would create this cascade of traffic. It didn't work of course, but it intrigued me as to the fact that I signed up for it. I figured if it were presented better, there may be promise. And so after some work, the site with the referral component was launched, with mixed success, as getting people to sign up was not an issue, but to sell a high enough percentage of them on doing the upfront work to gain referrals was a difficult proposition, although some individuals in the know do very well in this regard. Additionally, no one had a reason to come back - hard to build a following without that. And so it was necessary to add the additional component of the 'directory' to balance the referral component with something that would produce more conservative, but predictable and immediate results. In order to get people to keep coming back, it seemed to make sense to get them to earn a high ranking by visiting other sites which would in turn fuel others to do the same. It was a big success, and funny enough, although the concept of this 'directory traffic' component is similar to 'traffic exchanges' (although every will agreed it's much more targeted, transparent and user-friendly) I never knew about them until after the fact and I'm not even sure they were around when I first came up with this. later, A 'review' link was added, but there was rampant spamming abuse and little participation, and so it was revamped to be included 'for ranking credit'. This helped, although the quality of the average review was still poor and so a 'quality' grade was included as well. A similar story with the addition of the linkreferral forums a few years ago, as initially it was unmoderated and a spam haven. It was revamped to be included as 'for ranking credit', moderated, and now one of the most valuable parts of the linkreferral program.

Many pieces have been added, the latest has been the much requested 'search tool' to find sites within our database by keyphrase. If you don't know what I'm talking about, log in, hit the 'directory traffic' tab, then looking underneath the listed categories. The reason this was so long in coming was due to concern over cannibalizing the nature of how earning credit within the directory works, however the search results have been set up as such that the integrity of the credit system should be kept safe.

Linkreferral.com is a small site no longer, and now runs on two, well tuned dual xeon servers, serving over 20 million pages and 5 million visitors per month (although one of our 3rd party tracking services puts us at 4.5 million pages and 2.5 millions visitors per month) the discrepancy would make for a good separate post. Also, we see over 200 new accounts registered per day.

Linkreferral.com's Alexa rank is currently 3,655 (meaning we are the 3,655 most trafficked site in the world, out of 20+ million ) We've doubled in the past year, and 10-fold in the past 3. We're looking forward to being an established and household web presence in the next couple of years that will have an impact on how the average user finds new sites, and gets exposure for their own online endeavour.
Posted by Admin.

Create Account now is FREE

Read More »»

SEO On page Optimisation

In the economic downturn, marketing budgets are being slashed and jobs are being cut. Companies are cutting costs any way possible to stay afloat. However, companies still need to keep a presence in the market place, otherwise their brand awareness will diminish. Many companies have been looking to towards internet marketing and search engine optimisation (SEO). In this article we will shine some light on one of the most fundamental SEO techniques: on page SEO.

In SEO there are two factors that will help you rank highly in the major search engines. The first one is on page factors. These are like dotting the I's and crossing the T's. These on page factors help tell the search engine spiders that your website is relevant for the keywords that you would like to appear for. The second is off page factors. These dealing with creating inbound links to your website. This is where the majority of your rankings will be derived from. However, you first need to get your on page work done, as linking campaigns can take many months to implement.

On Page Factors
To understand how Google sees your site go to Google and type in a search query. When the results show go to anyone of the results and choose the small link at the bottom right of the result that says cached. The cached version is a snapshot of the page that Google took the last time that they updated their indexing. At the top of the page choose the option "text only version". This is what Google actually see's when they crawl your site. Google does not actually see the graphics on page, only the text. The enlarged bolded headings on the page are your H1 and H2 tags. Knowing how the search engines see your page make help you realise the importance of creating correct on page optimisation. We will go on to explain these main tags as we go through this article.

Title Tags
Title tags are the most important elements in on page SEO. This is the first tag that search engine spiders read. Your title tag tells the search engines what the most important phases are for the page. There is an art to creating title tags that are keyword rich for search engine spiders, and still accurately and succinctly conveying the content of the page to the reader.

With your title tag, always place your most important keyword first. For instance, let's take an example of a site that was trying to optimise for Accounting. If from your keyword research that you would like to optimise for accounting and also the long tails of accounting such as accounting in the state you live and accountants, then your title tag should read as follows:
Accounting, Accounting Melbourne, Accounts

In this example you will accurately convey to the search engine spiders that the relevant terms on page are accounting, accounting Melbourne and accountants. Now the rest of your tagging and copy needs to show the spiders content relevant to your title tags.

One note to remember when you are creating any major on page tags is not to key word stuff your tags. An example of keyword stuffing in the same example would be Accountants, Accountants, Accountants. This may seem odd, however in the early days of SEO spammers use to trick the search engine spiders with such techniques. This second example would now be detected by the search engine spam filters instantly.

Meta descriptions
Meta descriptions are used to give search engines and users a 160 character description of what the content on page is about. Keep this consistent with your title tags. The content of this tag is important as a well worded meta will increase your click through rate when it appears in the search results.

The second use for meta descriptions is to give a snapshot of the page content to users on the search engine ranking placements (SERPS).

H1 Tag
In HTML tags go from H1-H6. The H1 tag is the most important of these. There are a few ways that you can position H1 tags. The aim should to have the H1 at the top of the page so this is the first thing that they crawlers read after they have read you title and meta's. An effective way is to put these in the header file at the top right of the page. The other way is to make your main headline your H1.

One word of warning with H1 tags. Be careful about hiding them in the style sheet. Some designers will do this, as at times it is difficult to find a place to position the H1 tag. While Google can't read your style sheet, you run the risk of a competitor reporting you to Google for spamming.

H2 Tag
The easiest way to position the H2 tag is in a heading. Try adding a keyword at the beginning of the heading.

Other on page techniques

Keyword density
Keyword density and keyword saturation are important to let search engines know that your page is relevant for the keywords that you are optimising for. However, keyword density is becoming less important as search engines become more sophisticated. Still try and keep keyword density to 2-3%.

Strong Tagging
tagging is when a word on the page appears bold. Don't overuse this. Once or twice on page is fine.

These on page SEO tips will help your SEO campaign and help you rise to the top of the search engines!

Read More »»

How A Router Works

In the past when you referred to a router you were talking about a tool that was used to design and shape wood. The internet has changed that.

In its simplest form a router is defined as a device or setup that finds the best route between any two networks. A router is the most important part of a computer network in that it helps data get where it is supposed to be. When it is given the choice of where to make it's delivery one of the tools a router uses to decide where information should go is a configuration table. A configuration table is a collection of information, including:

- Information on which connections lead to particular groups of addresses
- Priorities for connections to be used
- Rules for handling both routine and special cases of traffic

The internet is really an unbelievable invention. Think about this. You can send an email to someone anywhere in the world and they receive your message in a matter of seconds. You can download a file or surf from web page to web page very easily today. All of this because of routers.

An easy way to understand a router is like this. You send a letter to a friend in Australia. They read it and send it back to you. This might take several days or weeks with snail mail. On the internet routers are the mailman that gets your letter to your friend and then their letter back to you.

Routers are very versatile. For example they allow two computers to receive the internet under one IP address simultaneously. An IP address is what allows your computer to connect to the internet. If you have a network of computers a router will allow them to use the Internet with the same access.

In many households today a cable modem is the router. The internet is accessed through the modem directly into a computer. If you have more than one computer you can purchase a router and connect it to the cable modem. The internet is passed through the router and delivered to the computers either through a wire or more commonly today now through wireless technology.

Wireless routers allow you to connect computers, portable computers, personal desk assistants, and printers without using wiring. Wireless routers are excellent for connecting notebook computers to the Internet and networks.

As you are running more computers on your network you may experience a slight drop in speed, but today many broadband routers are able to deliver the internet without much of a slowdown. You probably will not even notice it.

Read More »»

9 Ways To Protect Yourself From On-Line

As a professional organizer I frequently work with people who have been the victims of Internet fraud and I bet you probably know someone or have heard of someone who has also been a victim. Become proactive and protect your identify so you won’t become a statistic of Internet fraud. We live in a wonderful world where technology is always at our finger tips but we need to use it wisely and make sure our personal identity is protected.In getting rid of clutter on our computers we also need to be conscious of online fraud and ID theft. One way to protect yourself from online fraud and ID theft is to use free state-of-the-art Rapport security software from Trusteer. Trusteer.com works with leading banks to prevent criminals from taking money from your accounts. Their service has been specifically designed to combat online banking and shopping threats and represents an essential part of your bank’s security systems. Other things to do to protect yourself online: * Don’t click pop-ups and don’t download files from websites you don’t trust. ·When making online transactions, be sure web addresses begin with https (not http) and look for a key or padlock icon in your browser window. ·Don’t surf to other sites while you are visiting a secure banking site; finish banking, always log out and close your browser before you move on. · Don’t click links or open attachments in suspicious emails. ·Never send personal or sensitive information by email. · Choose passwords that are difficult to guess and change them on a regular basis. An internet technology expert told me to use complex passwords. A complex password has a capitol letter, a symbol, a number and lower case letters. These don’t need to be in any particular order nor do they need to be long. The people looking for personal information have programs that search by all words that are in the dictionary. By creating a complex password it thwarts their efforts to get your personal ID. An example of a complex password: P@ssw0rd · Back up your important computer files at least once a month. · Don’t let spyware sneak onto your computer to give others a peek at information you enter online. · Phishers are looking to lure you with bogus emails and pop-ups that seem safe. Don’t take the bait. If you think someone is ‘phishing’ for your personal information, forward the email to spam@uce.gov and also to the company, bank or organization that was being impersonated. Onguardonline.gov provides practical tips from the federal government and the technology industry to help you be on guard against Internet fraud, secure your computer, and protect your personal information. This site offers topics on computer security, games to test your Cyber Smarts with Interactive quizzes and videos about online safety. There is also a section with information talking about parents having the right to control what information websites collect from their kids under 13. When we are getting rid of clutter in our homes or offices we are careful to take measures so people won’t get our personal information, but we also need to be just as careful with our information on line. Marilyn’s Bio: Marilyn is a professional organizer who works with women and seniors in clearing clutter and providing organizing tips. Clearing clutter helps those she works with to have less stress in their lives and feel more joy in living. Marilyn invites you to visit her website http://www.marilynbohn.com where you can find organizing solutions. You will find fun stories and free organizing tips in her blogs, articles and videos.

Read More »»

Benefits Of VoIP Solutions

July 2nd, 2009 in Business and Technology.

VoIP or Voice over Internet Protocol uses the Internet for voice communication unlike traditional landline phones. With Voice over IP, IP packets are transferred from router to router until they reach their destination. VoIP solutions are being considered as the best alternative for making long distance calls as savings are much greater in comparison to landline phones. In 2008, there were more than 24 million VoIP users in the US. VoIP services are also known as Internet telephony, broadband telephony, IP telephony, etc.

Many Atlanta based IT firms provide the Atlanta VoIP solutions. Some benefits of VoIP solutions include:

Highly Economical: When you use small business Voice over IP, you will be able to save more over your current phone system. Based on call service plans offered by VoIP service providers, you can reduce your phone bills by 50% or more.

Enhances Productivity: VoIP allows end users to participate in virtual meetings using video conferencing and shared data. Documents can also be attached to voice messages as voice is treated just like any other form of data. The employees of any organization can keep in touch with their clients and each other easily with the help of VoIP. Better client communication ensures that the company grows at faster pace.

Integrates With Data, Audio and Video: VoIP saves you time as well as money by integrating services like fax, web conferencing, email and video in one basic application. This enables you to use your phone while having simultaneous access to other services.

Numerous Features: Providers of Voice over IP in Atlanta will offer you many features included at no extra cost, such as Caller ID, Call Block, Call Return, Do Not Disturb, Voice Mail, Call Waiting and Call Forwarding.

Read More »»

New something like google ads

Now, not just the software house and computer retail can have many. But who the people can connect to the internet, they can make a lot of money or make Extra Income. Something NEW like Blogsvertise.com, Beside the old style like Ciao, ziddu, and linkpayer. It’s make review of the products offered by blogsvertise.com. Shortly, the program like this is called paid to review. I think that the program can potentially to Extra money per month.

The site is one of provider Paid To Review on the internet. They get money from the Advertiser who want to their product or website reviewed by the Publisher by the netter in the world. The money is used to pay the Publishers.

Blogvertise provide jobs for the registered bloggers to review a particular item or product in the publisher’s blogs.
The publisher to write a review about the product or item in the English language in their blogs.
Publisher paid through Paypal within one month after the review-approve. The average charge for a review is in the $ 10.
I you have not a blog yet, according to blogsvertise.com, first setup your own blog, by using one of free blog resources. Once you have setup your blog, you need to compose some entries in your online journal. Once you’ve setup your blog / journal you can then register for an account to begin earning revenue with blogsvertise blog.

No matter who you are or your skill have. this good for you to Join here. It FREE...!!!


Don't Forget, please tell all your friends and coworkers about http://www.blogsvertise.com/

This is tip for your blog before you applied :

1. Exchange links with your friends. Make your blog popular by exchanging links and letting others know about your blog. Visit other blogs and online communities, put your blog in your signature and network!

Blogger Forum

Blog Catalog

Blogarama

2. Keep your blog fresh with content. Keep your blog up-to-date with the latest news in your field, and update your blog regularly so your readers will come back to see whats new.

3. Setup your own domain. If you are running your blog on a free blog host, for example blogspot, we recommend to setup your own domain and host your blog on its own domain, for example yournameblog.com . Advertisers generally prefer bloggers who are on their own domain.

4. Always respond to task requests. Do NOT just ignore our emails- if you do not want a task, make sure you decline it rather than just simply not responding. Not responding to task emails leads to account suspension.

5. Avoid excessive ads & badges. Avoid badges, bubbles, and copy & pasted disclosure policies. If you feel obligated to tell your readers that you particpate with blog ad services, use your own words for your disclosure.



Best regard

Basmal

Read More »»

Business Intelligence in SQL Server 2008

Published by Basmal July 13nd, 2009 in Education and Technology.
Introduction
In an increasingly competitive marketplace, businesses are realizing that they can only succeed by proactively identifying market trends and opportunities, and by responding rapidly to new customer demands. Additionally, employees need to prioritize business activities and expenditure to ensure the most efficient use of the available resources and make effective business decisions.
To meet these challenges, employees need to gain actionable insight into the business, so that they can make intelligent, informed decisions and contribute to driving business success. Organizations want to embed this insight into everyday business activities so that all employees are engaged, either explicitly or implicitly, in acting on the results of analysis of a complete and consistent version of all enterprise data.
Microsoft Business Intelligence Technologies
Microsoft provides a comprehensive Business Intelligence (BI) offering that is based on a scalable data platform for data warehousing, analysis, and reporting, and offers powerful and intuitive tools that end users can use to access and analyze business information. At the core of the Microsoft BI end-to-offering is Microsoft SQL Server 2008, a complete data services platform that enables you to:
* Unify storage and access for all data across the enterprise.
* Build and manage sophisticated BI solutions.
* Increase the reach of your business intelligence solution to empower all employees.


The specific technologies of SQL Server 2008 that form the basis of this powerful BI offering are described in the following table

Component Description
SQL Server Database Engine Provides a scalable, high-performance data storage engine for extremely large volumes of data. This makes it an ideal choice for consolidating business data from across the enterprise into a central data warehouse for analysis and reporting.
SQL Server Integration Services Is a comprehensive platform for extract, transform, and load (ETL) operations, which enables the population and synchronization of your data warehouse with data from the disparate data sources that are used by your business applications throughout the organization.
SQL Server Analysis Services Provides an analytical engine for Online Analytical Processing (OLAP) solutions, including business measure aggregation over multiple dimensions and key performance indicators (KPIs), and for data mining solutions that use specialized algorithms to identify patterns, trends, and associations in business data.
SQL Server Reporting Services Is an extensive reporting solution that makes it easy to create, publish, and distribute detailed business reports both within the enterprise and outside the enterprise.

While SQL Server 2008 delivers a comprehensive BI platform, it is through deep integration with productivity tools, such as the 2007 Microsoft Office System, that you can empower employees throughout the enterprise to use this platform and turn business insight into effective actions.
2007 Microsoft Office System Integration
The SQL Server 2008 BI platform reaches information workers through the following 2007 Office System components:
• Microsoft Office Excel. A powerful spreadsheet application that you can use as an interface for OLAP analysis, data mining, and report rendering. Through deep integration between SQL Server 2008 and Excel 2007, you can:
• Enhance the end user’s ability to access and analyze data from SQL Server 2005 Analysis Services. With Excel 2007, end users can browse data that is stored in multidimensional OLAP cubes in Analysis Services. Excel 2007 enables users to easily build Microsoft PivotTable dynamic views to “slice and dice” data any way they wish through the tools that are already installed on most desktop computers.
• Gain more value from your Excel implementation by using the tight integration between Excel and Analysis Services that enables end users to easily use the Analysis Services features, such as translations, Key Performance Indicators (KPIs), calculated members, named sets, and the server actions within Excel that turn Excel into an analytical client.
• Make predictive analysis available to everyone and enable non-technical users to harness the highly sophisticated data mining algorithms of SQL Server 2005 Analysis Services within the familiar environment of Office. Designed with the end users in mind, Data Mining Add-Ins for Office 2007 empowers end users to perform complex analysis directly in Excel and Microsoft Office Visio.
• Add automatic analysis features, such as highlighting exceptions where data seems to differ from patterns in other areas of the table or data range, forecast future values based on current trends, analyze what if scenarios, and determine what needs to change to meet a specific goal.
• Deliver reports in the format preferred by most end users by using the new and enhanced Reporting Services Excel rendering capabilities, which enable end users to receive reports directly in Excel.
• Microsoft Office Word. A word processing application that you can use as a format for reports. Use the new, highly requested report renderer for Microsoft Word, which enables you to render SQL Server 2008 Reporting Services reports in Word format.
• Microsoft Office Visio. A drawing and diagramming application that you can use to annotate, enhance, and present your data mining graphical views. With SQL Server 2008 and Visio 2007, you can:
• Render decision trees, regression trees, cluster diagrams, and dependency nets.
• Save data mining models as Visio documents embedded into other Office documents, or saved as a Web page.
• Microsoft Office SharePoint Server. A comprehensive collaboration, publishing, and dashboard solution that you can use as a centerpiece for providing one central location for placing all your enterprise-wide BI content and tools, so that everyone in your organization can view and interact with relevant and timely analytical views, reports and KPIs. The integration of SQL Server 2008 Reporting Services with Office SharePoint Server 2007, enables you to:
• Use one consistent user interface to manage and view reports.
• Track versions and workflow of reports when they are stored in the Office SharePoint Server 2007 document libraries.
• Manage a single security model for reports through the SharePoint document library.
• Use the Office SharePoint Server 2007 out-of-the-box Report Center template to easily build a site to store reports.
• Microsoft Office PerformancePoint Server. An integrated performance management application that employees can use to monitor, analyze, and plan business activities based on the analytical data provided by SQL Server 2008.
Throughout the rest of this whitepaper, you will learn how SQL Server 2008 and its integration with the 2007 Office System can help you to unify business intelligence data storage and access, build and manage sophisticated BI solutions, and extend the reach of those solutions to all of your employees.
Unifying Data Storage and Access
Most organizations have multiple business systems, each with its own dedicated data store. Although you can often generate reports from individual applications, and perform analysis on the data they contain, you can only achieve a complete and consistent insight into the business by consolidating the disparate data throughout the enterprise to create a central source of business data for reporting and analysis.
Consolidating Corporate Data for Analysis and Reporting
SQL Server 2008 supports two common approaches to unifying business data for analysis and reporting:
• Data warehouse. A dedicated data store for enterprise-wide data, which is populated and synchronized with business data from disparate data sources throughout the enterprise. The key advantage of this approach is that you can design the data warehouse for optimal analytical and reporting performance with no impact on the performance of the line-of-business applications from which the data originates. Another advantage of this method is that you can clean and consolidate data that comes from multiple sources into a single consistent version of the truth.
• Data source abstraction. SQL Server 2008 Analysis Services enables the creation of data source views to provide an abstraction layer over one or more sources of data. You can then use the data source view as a single source for Analysis Services, Integration Services, and Reporting Services. With a data source view, the data is retrieved from the underlying source systems when analysis occurs or a report is generated. The key advantage of this approach is that it enables real-time analysis of the data in your business applications. Additionally, the data source view through its added layer of abstraction can be used to create friendly names to replace long or cryptic table names.
These approaches are shown in Figure 1. With SQL Server 2008, you can use either of these approaches or a combination of the two.

Figure 1
Work With All of Your Data the Way You Want to
Regardless of which approach you take to unify your business data, SQL Server 2008 builds on its strong legacy of support for both relational and non-relational data by providing data types that enable developers and administrators to efficiently store and manage unstructured data, such as documents and images, so you can store, manage, and analyze data in the format that best suits your business.
SQL Server 2008 includes enhanced support for XML data storage as well as a FILESTREAM data type that enables large binary data to be stored in the file system yet remain an integral part of the database with transactional consistency. Additionally, restrictions on the size of user-defined data types have been removed, which makes it possible to exceed the 8 KB limit imposed in earlier releases of SQL Server. Support for spatial and location data types makes it possible to store and analyze geographical data that conforms to industry standards.
Integrate All Enterprise Data Sources
SQL Server 2008 data source views enable integration of data and access to data that originates from heterogeneous enterprise-wide data stores, such as SQL Server, Oracle, DB2, and Teradata. These views also provide a OLAP store of enterprise scale, and the breadth of support for diverse data sources in SQL Server Integration Services means that you can extract data from all kinds of existing business applications. Therefore, unifying the data in all of your enterprise data sources is easy to accomplish, regardless of whether you want to build an abstraction layer through a data source view or use an ETL process to synchronize a dedicated data warehouse for analysis and reporting.
Additionally, through support for Web services and the Microsoft .NET Framework, SQL Server 2008 supports interoperability with multiple platforms, applications, and programming languages, so you can maximize your investment in new and existing systems by integrating and connecting your disparate data sources. Support for existing and emerging open standards, such as HTTP, XML, SOAP, XQuery, and XSD, further facilitate communication across your extended enterprise systems.
Data Warehouse Performance
SQL Server 2008 provides a comprehensive and scalable data warehouse platform that enables your organization to integrate data into the data warehouse faster so you can scale and manage growing volumes of data and users.
Optimize ETL Processes
Data warehouses are usually populated and updated with data from source systems through an ETL process. After the initial load of data into the data warehouse, periodic refreshes of new and changed data from the source systems are performed to ensure that the data warehouse is up-to-date.
SQL Server Integration Services provides a comprehensive platform that you can use to extract data from diverse source systems, make any required transformations to the data or its structure and format, and then load the transformed data into the data warehouse. Performing lookups to match records from source systems to existing records in the data warehouse is a common operation in ETL processes, and in SQL Server 2008 the performance of lookups has been significantly improved so that these operations scale to extremely large tables.
To help track data changes and ensure data warehouse consistency, SQL Server 2008 introduces Change Data Capture (CDC) functionality to log updates in change tables, which makes it easy to identify rows that have been modified and to determine the details of the modification and its cause.
Manage Hardware Resources Efficiently
Through support for data compression, SQL Server 2008 enables you to store your data more effectively and reduce storage costs. In addition, the compression significantly improves performance for large input/output bound workloads. SQL Server 2008 also provides native support out-of-the-box for backup compression. Additionally, the VARDECIMAL data type and new sparse columns in SQL Server 2008 help you to get the most efficiency from your disk storage resources by reducing the amount of space that is required for the large tables that contain the predominantly numeric or NULL values that are often found in data warehouses.
In addition to efficiencies in data storage, SQL Server 2008 supports dynamic allocation of Address Windowing Extensions (AWE) mapped memory that supports up to 64 gigabytes of memory with Windows Server 2003, Datacenter Edition, and 2 terabytes with the 64-bit edition, to support large data warehouse environments.
SQL Server 2008 also introduces Resource Governor, which enables administrators to define resource limits and priorities for different workloads, so that concurrent workloads can provide consistent performance and make it possible to manage resource contention issues proactively.
Optimize Database Performance
SQL Server 2008 includes a high-performance relational database engine that enables you to build highly effective data warehouse solutions. Innovations, such as query optimizations for star schemas and tools to help you tune indexes and data structures, make SQL Server a natural choice for a heavily queried data warehouse. With the introduction of the MERGE Transact-SQL statement in SQL Server 2008, developers can more effectively handle common data warehousing scenarios, such as checking whether a row exists and then executing inserts or updates. Additionally, an extension to the GROUP BY clause enables users to define multiple grouping in the same query. Grouping Sets produce a single result set that is equivalent to a UNION ALL of differently grouped rows, which makes aggregation querying and reporting easier and faster.
SQL Server 2008 supports partitioned tables to help you optimize the performance and management of large tables, and with new support for partitioned table parallelism, you can significantly optimize a data warehouse by using partitioned tables.
Building and Managing Sophisticated BI Solutions
As organizations demand ever increasingly complex analytics, the need to be able to build and deliver effective BI solutions quickly and to reduce the management overhead of your BI infrastructure has become a major consideration. SQL Server 2008 includes innovative tools that increase developer productivity and manageability, which enables faster capitalization on new analysis and reporting capabilities while incurring reduced administrative overhead.
Developer Productivity
SQL Server 2008 simplifies the development of business intelligence solutions. BI developers benefit from easy-to-use utilities and tools that increase control and automate routine, time-consuming tasks, and can use the productivity features of SQL Server 2008 to create effective analysis and reporting solutions more quickly than ever; so your organization can take advantage of them sooner.
Use a Rich, Modern Programming Environment.
Through a tight interoperability with Microsoft Visual Studio, developers can easily build and maintain robust, secure, scalable BI applications. SQL Server Business Intelligence Development Studio offers a single tool that covers multiple types of BI solution and provides a single, consistent environment for developing ETL, analysis and reporting solutions. Intuitive BI wizards that are delivered as part of the Business Intelligence Development Studio make it easy for even novice developers to build advanced Business Intelligence models and projects.
By embedding the Common Language Runtime in the database engine, SQL Server 2008 enables developers to choose from a variety of languages to develop applications, including Transact-SQL, Visual Basic, and C#. This flexible environment enables developers to use their existing skills to efficiently develop database applications.
When integrated with Visual Studio, the development experience across all of the SQL Server 2008 BI technologies is optimized for providing a true application development environment that supports the full project development life cycle (develop, test, deploy, modify, and test).
Implement Best Practice Solutions
However, enabling developers to build solutions more quickly is only effective if those solutions are optimally designed. To help ensure the best possible performance and correct functionality, SQL Server 2008 includes the following development environment features that promote best practices and help developers create effective analysis solutions:
• A consistent development environment for all BI solutions, including Analysis Services, OLAP, and data mining applications.
• Built-in support for the full development lifecycle, including design, build, debug, and deploy operations; and support for team-based development through integrated support for source control.
• A number of intuitive designers and wizards that make it easy to create Analysis Services solutions quickly.
• An attribute relationship designer that includes built-in validations to help in creating optimal dimension designs.
• A dimension editor that has been slimmed down to provide better productivity and the presence of parent child relationships is automatically detected.
• A cube designer that has also been streamlined and improved to provide better detection and classification of attributes along with identification of member properties.
• Aggregation of individual partitions, which enables you to optimize measures from different periods or areas.
• The aggregation designer has a new algorithm to help create initial aggregations. The aggregation designer is optimized to work with usage driven aggregations. You can now look at the aggregations that have been created and add to those aggregations or remove them. Intelligent support is provided to help with merging existing and new aggregation designs.
Additionally, SQL Server 2008 provides AMO warnings to alert developers when their design breaks one of over 40 best practices. These warnings are integrated into real-time designer checks, and provide a non-intrusive way for developers to detect potential problems with their design.
Increase reporting flexibility
Reporting is a significant element of any BI solution, and business users are demanding increasingly complex reports. SQL Server Reporting Services provides the following features to make it easy to build reporting solutions:
• A Visual Studio-based report development interface in Business Intelligence Development Studio that developers can use to build, debug, and deploy reports.
• A business-focused report development tool named Report Builder, which business users can use to create and deploy reports.
• A wide range of data display structures, including tables, matrices, lists, and charts.
Additionally, SQL Server 2008 includes extensive enhancements to Reporting Services that improve reporting performance and provide increased flexibility for formatting and publishing reports. One of the enhancements made to Reporting Services in SQL Server 2008 is support for a new layout structure that combines Table and Matrix data regions into a new Tablix data region. Tablix enables developers to generate reports that combine fixed and dynamic rows. Previously, layouts of this kind had to be developed by using multiple matrix data regions and shrinking row headers. Support for Tablix data regions simplifies the inclusion of combined static and dynamic data in reports, and extends the formatting and layout capabilities of Reporting Services significantly.
Manageability
Through innovations such as a unified management tool, enhanced self-tuning capabilities, and a powerful management programming model, SQL Server 2008 extends the SQL Server ease-of-use leadership and increases the productivity of database administrators (DBAs). These enhancements enable DBAs to focus on high value tasks, like database architecture, while spending less time on routine maintenance, configuration, and tuning.
Use a Single, Unified Tool
SQL Server 2008 provides DBAs with SQL Server Management Studio; a single, unified management tool that provides integrated management of Analysis Services, Reporting Services, Integration Services, and multiple versions of SQL Server, from the same interface for increased DBA productivity, flexibility, and manageability across extended SQL Server implementations.
Monitor Data warehouse resources
SQL Server 2008 also includes Performance Studio, which provides a centralized management tool for monitoring and reporting use of resources across your data services solution.
Enterprise Scalability
Another key factor related to successful delivery of truly sophisticated BI solutions requires sustained developer productivity and manageability even through large-scale implementations. Furthermore, the infrastructure must provide performance-related scalability, which in SQL Server 2008 has achieved a wide variety of investments that are focused on ensuring this enterprise-scale sustainability even through the largest scale of BI implementation.
Scalable Analytics
The premise of Online Analytical Processing (OLAP) is that instant access to accurate information enbles end users to answer even the most complex questions at the speed of thought. Thus, the aim to continuously excel in providing even faster query times and data refresh rates is a priority during the development process of any Microsoft SQL Server Analysis Services release, an aim that naturally also has been driving the release of SQL Server 2008 Analysis Services.
SQL Server 2008 includes Analysis Services that enable you to drive broader analysis with enhanced capabilities, including complex computations and aggregations. Analysis Service provides enterprise-scale performance through:
• A flexible caching model. With Analysis Services, you can control how data and aggregations are cached to optimize query performance while maintaining an acceptable level of latency between the cache and its underlying data store.
• Declarative attribute relationships. In an Analysis Services dimension, you can explicitly declare relationships between attributes in a hierarchy. This enables Analysis Services to pre-generate aggregations when a cube or dimension is processed, which improves runtime query performance.
• Block computation. Block computation eliminates unnecessary aggregation calculations (for example, when the values to be aggregated are NULL) and provides a significant improvement in analysis cube performance, which enables users to increase the depth of their hierarchies and complexity of computations.
• Writeback to MOLAP. Analysis Services 2008 removes the requirement to query ROLAP partitions when performing writebacks, which results in huge performance gains.
• Scale-out Analysis Services. A single read-only copy of an Analysis Services database can be shared between many Analysis Servers through a virtual IP address. This creates a highly scalable deployment option for an Analysis Services solution.
• Execution plan persistence. SQL Server 2008 provides functionality to lock down query plans so that, to the maximum extent possible for correctness, the query plans survive server restart, server upgrade, and production deployments. This ensures consistent optimal performance of queries against SQL Server data.
Scalable Reporting
For many organizations, getting the right information to the right people at the right time is a significant challenge. SQL Server 2008 provides a high-performance reporting engine for processing and formatting reports along with a complete set of tools for creating, managing, and viewing reports. An extensible architecture and open interfaces enable easy integration of reporting solutions in diverse IT environments.
You can generate reports from multiple diverse data sources, including SQL Server, DB2, and Oracle, without first building a centralized data warehouse. You can deliver reports throughout the organization both internally and externally through the simple deployment and configuration capabilities that are provided by Reporting Services. This enables users to easily create and share reports of any size or complexity. You can also deliver reports to customers and suppliers easily by deploying reports over the Internet.
Reporting Service provides support and the ability to control server behavior with memory management, infrastructure consolidation, and straightforward configuration through a centralized store and an API for all configuration settings.
Extending the Reach of Your BI Solution
In the past, BI solutions were used by a small group of business analysts. Now, more and more organizations are realizing the benefits of extending the insights that are available through BI to all employees and embedding those insights into the day-to-day operations of the business.
SQL Server 2008 enables you to create a BI solution that can scale to thousands of users and deliver a rich user experience to everyone through an extensible, open, and embeddable architecture that is optimized for interoperability with Microsoft Office.
Extending Business Insight to Everyone Through Familiar Tools
Microsoft Office has become a ubiquitous productivity suite that most information workers in organizations throughout the world use to perform their daily tasks. Through close integration with Office, SQL Server 2008 enables you to empower your employees with critical, timely business information that is tailored to their specific information needs.
Tight integration with the 2007 Microsoft Office System and Microsoft Office PerformancePoint Server 2007 enables organizations to save time and money by using technology that works well together. The integration also provides a quicker return on investment in terms of end-user scale by delivering business insight to everyone through familiar tools that are already installed on every desktop computer.
Extend Your Reporting Solution with Microsoft Office
Reporting Services 2008 supports rendering to both Microsoft Excel and Microsoft Word formats. Rendered reports are fully editable in the appropriate Microsoft Office application, which extends your reporting solution so that users can create custom documents based on business reports.
Use Excel for Analysis
Excel is the tool of choice for many financial and business analysis tasks. By combining Excel with SQL Server Analysis Services, you can bring the full power of your OLAP solution to business users through PivotTable dynamic views and Microsoft PivotChart dynamic views in an Excel spreadsheet.
You can also use the SQL Server Data Mining Add-Ins for Excel 2007 to enable business analysts and executives to go through the entire lifecycle of a data mining project, including preparing data, building, evaluating, and managing mining models, and predicting results by using either spreadsheet data or external data that is accessible through your Analysis Services database.
Publish Business Insights Throughout the Enterprise
SQL Server 2008 integrates tightly with SharePoint Services to make it easy to publish and manage reports centrally in a SharePoint site and to build user-specific dashboards that provide customizable views of relevant reports.
Additionally, Microsoft Office PerformancePoint Server provides a central interface for data analysis that is built on SQL Server Analysis Services and enables customers to monitor, analyze, and plan their business, as well as drives alignment and provides actionable insight across the entire organization.
Empowering End-users Through Flexible Reporting
SQL Server 2008 provides a number of reporting enhancements that enable you to quickly and easily generate the reports that your organization needs, in the format that you want, and in a layout that makes sense of the data they contain.
Create Ad Hoc Reports with Report Builder
Report Builder has been enhanced extensively in SQL Server 2008 to enable users to easily build ad hoc reports with any structure. The intuitive design interface makes it easy for non-developers to create business documents, such as purchase orders, invoices, and contracts, based on report data.
Include Richly Formatted Data
Rich formatting can make business documents and reports more intuitive and significantly easier to understand. The rich text component of SQL Server 2008 enables mixed-formatting text boxes and importing of marked up text strings, and supports the new chart formats and the Tablix data region so that users can generate reports with high standards of visual design to convey business information clearly and logically.
Benefit from Increased Responsiveness
As reports become more central to the way organizations distribute business information, ensuring the highest levels of performance and scalability of your reporting solution has become more critical. The Reporting Services engine in SQL Server 2008 has been significantly re-engineered to resolve current limitations, and now includes on-demand processing and instance-based rendering to provide the best possible reporting performance.
Deploy Reports Securely Over the Internet
SQL Server 2008 enables you to extend the reach of your Reporting Services solution to external users, such as customers and suppliers, by publishing reports securely over the Internet.
Conclusion
SQL Server 2008 builds on the strong momentum in the business intelligence market by providing a scalable infrastructure that enables information technology to drive business intelligence throughout your organization and deliver intelligence where users want it. SQL Server 2008 makes great strides in data warehousing by providing a comprehensive and scalable platform that enables organizations to integrate data into the data warehouse faster and to scale and manage the data while delivering insight to all users. With the more scalable business intelligence infrastructure provided by SQL Server 2008, reports and analysis of any size or complexity can easily be managed, and at the same time empower users through the deeper integration with Microsoft Office. SQL Server 2008 also delivers improved performance in many areas, including data warehousing, reporting, and analytics.

Read More »»

How to Set Up an SMTP Server on Windows XP Pro

SMTP (Simple Mail Transport Protocol) is just that: simple. When you send an email to someone, the email program tells the SMTP server to send a message (the email you just wrote). The SMTP server then connects to another computer and tells it that it has a message waiting for “so-and-so.” If the second server accepts the connection (meaning “so-and-so’s” address is valid), then the message is transferred and put into the recipient's mailbox. Easy, huh?The question is, do you need one on your computer? If you use the same laptop at home, work and while traveling, it might become an irritation to have to continually change your SMTP protocols (outgoing email address). For example, if your SMTP protocol at home is smtp.myisp.com, and the one at work is smtp.myoffice.com, you would have to change the protocol in order to send your mail. Likewise, when you are traveling, staying at hotels will often result in different SMTP protocols. In such a case, having one SMTP server that accommodates multiple protocols is preferable. The good news is that Microsoft Windows XP Pro packages SMTP server software in its operating system. When you install Windows XP Pro, however, the SMTP services do not automatically install; these are optional components. You will need your XP installation disk to install them.

By Basmal

Read More »»

Setting up Apache - PHP5 & MySQL

As an 'internet Marketing' newbie I recently was forced to set up a server on my laptop so I could properly test web-sites written in php code.

I am pretty much a html sort of guy and have come back around to the internet after an absence of five or six years, to find things have moved on, and that you need to be able to use this sort of stuff to do Internet marketing properly- article sights, pre made web-sites etc.

I was unable to open these 'pre-made' sights directly in Interent explorer and was only able to get a vague idea of what they looked like by opening them in Dreamweaver- which recognizes php code. I tried to open these sites in a web browser but was told I needed a local server. "How do I do that"? I asked.

So, I had no way to see what the final product would look like until I put it on my 'proper' Internet server - not a very efficient way to do things if you want to change elements around.

After a bit of a hunt around on the Internet I discovered that I needed to set up a testing server on my own computer. It seemed the easy way to do this was to get Apache server , PHP, and my SQL database installed on my machine. As there were no e-books available on this. [Is that a Niche Market?] I took a trip to my local bookstore and came away with something I thought would do the job.

There I was, filled with excitement and new ideas that this would all be nice and easy. But of course, it wasn't. My first problem was that the book told me to get Apache 1.3. But I could only find only find an Apache two download.

A search for 'Apache 1.3 download 'gives the following 'official' site

http://httpd.apache.org/download.cgi -but you have to look closely to find the 'ARCHIVE' file! Which is where the 1.3 versions live. Apparently The PHP people don't think their software works as well on the Apache2 software- probably still being ironed out- but I wanted to do what the book says. Find 1.3 versions here:

http://archive.apache.org/dist/httpd/ -

you'll need to go into the 'Binaries' for the windows download. But from there on its fairly simple. You need to fill in a few info boxes during the set up:

for network domain enter: localdomain
for Server Name enter: localhost
for Administrator email- whatever you want

Also choose to 'run as a service for All users'

So I downloaded this and installed it successfully on my computer. I then got PHP five from the 'official' PHP site -
www.php.net/downloads.php

Click the windows ZIP option: , This is not an 'Auto install' you Unzip the files and then copy them to your C:/ drive;

Make a folder and call it 'php' and copy your php files into it.

There are a number of sites on the web that will tell you which files to 'fiddle' with to make the Apache-MySQL/PHP trio work, but to keep it all in one place I'll sumarise here from my experience:

Once you have PHP installed, you will need to navigate to the back to the Apache Folder httpd file -

C:\Apache\conf\httpd.conf

Open it with notepad and find the 'AddModule' section. [Hint: use Control F [windows find] and type 'AddModule'] insert the following lines after the final AddModule command: EXACTLY

#start addition

LoadModule php5_module c:/php/php5apache.dll
AddModule mod_php5.c
AddType application/x-httpd-php .php .phtml

#end addition

the bits with the # will not be recognized. I know this is a bit bamboozling but it was for me too! So don't give up yet.

Next, You will navigate to the Folder contining all the PHP files [should be C:/php] and locate the file labeled

php.ini_recommended

Find the line that says

doc_root =

Change this to read- .

doc_root = "C:\Apache\htdocs"
[if there is a # in front of the doc_root command- remove it or it wil only be seen as a comment]

You also need to locate the command

extension_dir = "./" and replace it with

extension_dir = "C:\php\ext""

The final part of the equation is the MySQL database installation, and here I encountered some problems. As I could only find a copy off my SQL5 instead of four as being suggested in the text.

MySQL 5 installation is pre-packaged, but when I came to the final part of the installation. I encountered a problem. The setup wizard said it could not fully install the database because I did not have TCP permissions on port 3306!!!!

Whaaaaaat....is a port 3306? This one again stumped me, and it was off to the mySQL frequently asked questions. Here, I finally found someone who made sense, and I paraphrase his response for any of you who are having the same problem.

here's what you need to do:

Uninstall MySQL completely, turn the computer off and then run the installer again tick all the boxes along the way.

Go to Windows Firewall. Start - Control Panels - Windows Firewall - Exceptions tab.

Click the "Add Port" button:
Name: mysql
Port: 3306

Click the "Add Program" button.
Browse to where you have installed MySQL ( C:/Programs Files/MySQL/MySQL 5.x.x/bin/mysql )

This seems this seems to satisfy Apache For those using another server you may need to follow the other procedure.

Download the the MySQL Administrator program from
dev.mysql.com or mysql.he.net
Unzip the program and launch "MySQLAdministrator.exe" directly out of the unzipped directory by double clicking on the MySQL Administrator.exe file. put in the following information:

Server host: localhost
Username: root
Password: whatever

Click "OK"

Click on the "Startup Variables" item on the left, then the "Security" tab. Check the checkbox for "Disable grant tables."

Click the "Service Control" item on the left and then the "Start/Stop Service" tab.

Click "Stop Service" -- once the services has stopped, click the button again to start the service.

Thanks to Mike from wimpyplayer.com for the bulk of that info.

So, the outcome I was desiring was partly achieved: I am now able to 'see' a full picture of a PHP webpage in the local browser on my computer- but only when I launch it from 'Dreamweaver' my web editing application, but, only one page at a time - it doesn't act like a proper website, but perhaps that's the next thing for me to learn.


Sincerely
Basmal

Read More »»