Deploy SSIS Packages SQL Server 2008 R2
Use the Deploy SSIS Packages page to specify where to install Integration Services packages and their dependencies.
File system deployment
Deploy packages and dependencies in a specified folder in the file system.
SQL Server deployment
Deploy packages and dependencies in an instance of SQL Server. Use this option if SQL Server shares packages between servers. Any package dependencies are installed in the specified folder in the file system.
Validate packages after installation
Indicate whether to validate packages after installation.
Next
Go to the next page in the wizard.
Finish
Thursday, June 23, 2011
How to Increase Webside in Search Engine
Most businesses don't take advantage of various techniques to increase search engine ranking, but few things on the Internet can be as beneficial as a high ranking on a search engine. A recent Forrester Research report showed that 80% of web surfers discover the new sites that they visit through search engines (such as Yahoo, Google, or MSN). According to iProspect, 85% of web users use search engines to find solutions and vendors. Properly optimizing a site to increase your search engine ranking for each page helps it to attract numerous, highly targeted visitors- visitors that may become buyers.
For the technically inclined, there are numerous places on the web to get detailed, in-depth information on how to achieve a high ranking on a search engine. However, many people don't care about the technical aspects of search engine optimization- they just want to know what is wrong with their site (and how to fix it). What follows is a practical guide that covers some of the most basic tips that can be used to increase search engine ranking. It is in no way intended to be comprehensive, but it should help the average site owner determine whether their site is optimized, and if not, how to make some simple changes to give each individual page of their site a better chance for a high ranking on a search engine.
Issue #1- The Title Bar
This is one of the most often overlooked techniques to increase search engine ranking. On your homepage, what does the title bar say? If you use Internet Explorer, this is the blue bar at the very top of the window that displays your page (it may include the words "Microsoft Internet Explorer" at the end). Does your company name appear here by itself when you have more important keywords to emphasize? Worse yet, does it say "untitled"? If you want to increase the search engine ranking for that page, this area should contain the most important keywords you see on your homepage. To check the rest of your site, click on any link from your homepage and see if the words in this title bar change for each page in your site. They should - and each title bar should contain the most important keywords from its corresponding page
Issue #2- Content
Search engines all try to list sites that contain good content. Translation: you need words on your pages to achieve a high ranking on a search engine, not flashy graphics. This text should contain the most important keywords that your potential customers would use to find you on a search engine. If you have very few or no words on a page where you wish to increase the search engine ranking, it is a good idea to add some, ideally around 250 per page. For aesthetic reasons, this is not always practical, but even 100 well-written words will give you a better opportunity for a high ranking on a search engine than none. It is also important that you make certain that the words are written in a language the search engines can read. Using your mouse, bring your cursor down to the text on one of your web pages. Clicking and holding down the left mouse button (make sure you aren't near a link) see if you can highlight just one or two words of the text. If you can, everything is most likely fine. If nothing happens, or you can only highlight a large block, it is most likely in graphic form. To increase search engine ranking in such cases, the graphic text needs to be replaced by standard HTML text to allow the search engines to read it.
Issue #3- Meta Tags
Some people believe that meta tags are the Holy Grail of achieving a high ranking on a search engine. Unfortunately, their effectiveness is limited (many engines ignore them completely), but they can play a limited role on some engines. To see if your site has meta tags, go to your home page. Click the "view" command at the top of the browser window. From the pull-down menu, select "source". This should open up another window that shows your code. Much of this may seem indecipherable, but there should be two commands there (usually near the top of the code). One of these says meta name="description" content= and will go on to describe your company and products, and one says meta name="keywords" content= and goes on to list applicable keywords for your site. If these tags are missing, have your web expert insert them. Again, this may not do much to increase search engine ranking, but it will not hurt.
Issue #4- Links
Link popularity has become increasingly important for those who wish to increase search engine ranking, with 19 of the top 20 engines using it in their ranking algorithms. Simply put, search engines give a ranking boost to sites that have links from quality, related sites. There are numerous free tools on the web that will allow you to see what sites link to yours (just type "free link popularity check" in your favorite search engine).
Conclusion
Although following the above guidelines will by no means guarantee you a high ranking on a search engine, fixing one or more of the problems should help increase your search engine ranking. For the volumes of potential customers that a search engine can send to your site, it's certainly worth the effort.
For the technically inclined, there are numerous places on the web to get detailed, in-depth information on how to achieve a high ranking on a search engine. However, many people don't care about the technical aspects of search engine optimization- they just want to know what is wrong with their site (and how to fix it). What follows is a practical guide that covers some of the most basic tips that can be used to increase search engine ranking. It is in no way intended to be comprehensive, but it should help the average site owner determine whether their site is optimized, and if not, how to make some simple changes to give each individual page of their site a better chance for a high ranking on a search engine.
Issue #1- The Title Bar
This is one of the most often overlooked techniques to increase search engine ranking. On your homepage, what does the title bar say? If you use Internet Explorer, this is the blue bar at the very top of the window that displays your page (it may include the words "Microsoft Internet Explorer" at the end). Does your company name appear here by itself when you have more important keywords to emphasize? Worse yet, does it say "untitled"? If you want to increase the search engine ranking for that page, this area should contain the most important keywords you see on your homepage. To check the rest of your site, click on any link from your homepage and see if the words in this title bar change for each page in your site. They should - and each title bar should contain the most important keywords from its corresponding page
Issue #2- Content
Search engines all try to list sites that contain good content. Translation: you need words on your pages to achieve a high ranking on a search engine, not flashy graphics. This text should contain the most important keywords that your potential customers would use to find you on a search engine. If you have very few or no words on a page where you wish to increase the search engine ranking, it is a good idea to add some, ideally around 250 per page. For aesthetic reasons, this is not always practical, but even 100 well-written words will give you a better opportunity for a high ranking on a search engine than none. It is also important that you make certain that the words are written in a language the search engines can read. Using your mouse, bring your cursor down to the text on one of your web pages. Clicking and holding down the left mouse button (make sure you aren't near a link) see if you can highlight just one or two words of the text. If you can, everything is most likely fine. If nothing happens, or you can only highlight a large block, it is most likely in graphic form. To increase search engine ranking in such cases, the graphic text needs to be replaced by standard HTML text to allow the search engines to read it.
Issue #3- Meta Tags
Some people believe that meta tags are the Holy Grail of achieving a high ranking on a search engine. Unfortunately, their effectiveness is limited (many engines ignore them completely), but they can play a limited role on some engines. To see if your site has meta tags, go to your home page. Click the "view" command at the top of the browser window. From the pull-down menu, select "source". This should open up another window that shows your code. Much of this may seem indecipherable, but there should be two commands there (usually near the top of the code). One of these says meta name="description" content= and will go on to describe your company and products, and one says meta name="keywords" content= and goes on to list applicable keywords for your site. If these tags are missing, have your web expert insert them. Again, this may not do much to increase search engine ranking, but it will not hurt.
Issue #4- Links
Link popularity has become increasingly important for those who wish to increase search engine ranking, with 19 of the top 20 engines using it in their ranking algorithms. Simply put, search engines give a ranking boost to sites that have links from quality, related sites. There are numerous free tools on the web that will allow you to see what sites link to yours (just type "free link popularity check" in your favorite search engine).
Conclusion
Although following the above guidelines will by no means guarantee you a high ranking on a search engine, fixing one or more of the problems should help increase your search engine ranking. For the volumes of potential customers that a search engine can send to your site, it's certainly worth the effort.
Wednesday, June 8, 2011
How to Install and Configure PHP 5 to Run with Apache on Windows
How to Install and Configure PHP 5 to Run with Apache on Windows
Steps to Setting Up PHP 5
Download PHP 5
Before you begin, get a copy of PHP 5 from the PHP download page. In particular, download the VC6 thread-safe zip package from the "Windows Binaries" section — that is, don't get the installer. For example, select the package labelled "PHP 5.2.5 zip package" if 5.2.5 is the current version.
Install PHP 5
Create a folder on your hard disk for PHP. I suggest "c:\php" although you can use other names if you wish. Personally though, I prefer to avoid names with spaces in it, like "c:\Program Files\php" to avoid potential problems with programs that cannot handle such things. I will assume that you used c:\php in this tutorial.
Extract all the files from the zip package into that folder. To do that simply double-click the zip file to open it, and drag all the files and folders to c:\php.
Upgraders: Remove the Old PHP.INI File from Your Windows Directory
If you are upgrading to PHP 5 from an older version, go to your windows directory, typically c:\windows, and delete any php.ini file that you have previously placed there.
Configuring PHP
Go to the c:\php folder and make a copy of the file "php.ini-recommended". Name the new file "php.ini". That is, you should now have a file "c:\php\php.ini", identical in content with "c:\php\php.ini-recommended".
Note: if you are using Apache 1, you should either move the php.ini file to your windows directory, "C:\Windows" on most systems, or configure your PATH environment variable to include "c:\php". If you don't know how to do the latter, just move the php.ini file to the "c:\windows" folder. You do not have to do this if you are using Apache 2, since we will include a directive later in the Apache 2 configuration file to specify the location of the php.ini file.
Use an ASCII text editor (such as Notepad, which can be found in the Accessories folder of your Start menu) to open "php.ini". You may need to make the following changes to the file, depending on your requirements
Enable Short Open Tags
Search for the line that reads:
short_open_tag = Off
If short_open_tag is set to "off", tags like "short_open_tag = On
Magic Quotes
By default, input data is not escaped with backslashes. That is, if your visitors enter an inverted comma (single quote) into your web form, the script will receive that unadorned inverted comma (single quote). This is for the most part desirable unless you have special requirements. If you want your input data to have the backslash ("\") prefix, such as, for example, to mimic your web host's settings, search for the following:
magic_quotes_gpc = Off
and replace it with:
magic_quotes_gpc = On
Do not do this unless your web host has this setting as well. Even with the setting of "Off", you can still use the addslashes() function in PHP to add the slashes for the specific pieces of data that need them.
Register Globals
A number of older scripts assume that all data sent by a form will automatically have a PHP variable of the same name. For example, if your form has an input field with a name of "something", older PHP scripts assume that the PHP processor will automatically create a variable called $something that contains the value set in that field.
If you are running such scripts, you will need to look for the following field:
register_globals = Off
and change it to the following:
register_globals = On
WARNING: Do NOT do this unless you have third party scripts that need it. When writing new scripts, it's best to always code with the assumption that the register_globals item is set to "Off".
Display Errors
On a "live" website, you typically want errors in your script to be silently logged to a PHP error file. On your own local machine, however, while you are testing and debugging a PHP script, it is probably more convenient to have error messages sent to the browser window when they appear. This way, you won't miss errors if you forget to check the error log file.
If you want PHP to display error messages in your browser window, look for the following:
display_errors = Off
And change it to:
display_errors = On
This value should always be set to "Off" for a "live" website.
Session Path
If your script uses sessions, look for the following line:
;session.save_path = "/tmp"
The session.save_path sets the folder where PHP saves its session files. Since "/tmp" does not exist on Windows, you will need to set it to a directory that does. One way is to create a folder called (say) "c:\tmp" (the way you created c:\php earlier), and point this setting to that folder. If you do that, change the line to the following:
session.save_path = "c:\tmp"
Notice that in addition to changing the path, I also removed the semi-colon (";") prefix from the line.
Alternatively, you can find out the current TEMP folder on your computer and use that. Or create a "tmp" folder in your PHP directory, like "c:\php\tmp" and set the configuration file accordingly. The possibilities are endless. If you can't decide, just create "c:\tmp" and do as I said above.
SMTP Server
If your script uses the mail() function, and you want the function to successfully send mail on your local machine, look for the following section:
[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25
; For Win32 only.
;sendmail_from = me@example.com
Change it to point to your SMTP server and email account. For example, if your SMTP server is "mail.example.com" and your email address is "youremail@example.com", change the code to:
[mail function]
SMTP = mail.example.com
smtp_port = 25
sendmail_from = youremail@example.com
Note that after you do this, when your script tries to use the mail() function, you will need to be connected to your ISP for the function to succeed. If you do not modify the above lines and attempt to use mail() in your script, the function will return a fail code, and display (or log) the error (depending on how you configure php.ini to handle errors).
(Note that in Apache 1.x, the smtp_port line may not be present. If so, don't include it.)
How to Configure Apache for PHP 5
There are two ways to set up Apache to use PHP: the first is to configure it to load the PHP interpreter as an Apache module. The second is to configure it to run the interpreter as a CGI binary. I will supply information for how you can accomplish both, but you should only implement one of these methods. Choose the module method if your web host also installed PHP as an Apache module, and use the CGI method if they have implemented it to run as a CGI binary.
Running PHP 5 as an Apache Module
To configure Apache to load PHP as a module to parse your PHP scripts, use an ASCII text editor to open the Apache configuration file, "httpd.conf". If you use Apache 1.x, the file is found in "c:\Program Files\Apache Group\Apache\conf\". Apache 2.0.x users can find it in "C:\Program Files\Apache Group\Apache2\conf\" while Apache 2.2.x users can find it in "C:\Program Files\Apache Software Foundation\Apache2.2\conf\". Basically, it's in the "conf" folder of wherever you installed Apache.
Search for the section of the file that has a series of "LoadModule" statements. Statements prefixed by the hash "#" sign are regarded as having been commented out.
If you are using Apache 1.x, add the following line after all the LoadModule statements:
LoadModule php5_module "c:/php/php5apache.dll"
If you are using Apache 2.0.x, add the following line after all the LoadModule statements:
LoadModule php5_module "c:/php/php5apache2.dll"
If you are using Apache 2.2.x, add the following line instead:
LoadModule php5_module "c:/php/php5apache2_2.dll"
Note carefully the use of the forward slash character ("/") instead of the traditional Windows backslash ("\"). This is not a typographical error.
If you are using Apache 1.x, search for the series of "AddModule" statements, and add the following line after all of them. You do not have to do this in any of the Apache 2 series of web servers.
AddModule mod_php5.c
Next, search for "AddType" in the file, and add the following line after the last "AddType" statement. Do this no matter which version of Apache you are using. For Apache 2.2.x, you can find the "AddType" lines in the section. Add the line just before the closing for that section.
AddType application/x-httpd-php .php
If you need to support other file types, like ".phtml", simply add them to the list, like this:
AddType application/x-httpd-php .phtml
Finally, for those using one of the Apache 2 versions, you will need to indicate the location of your PHP ini file. Add the following line to the end of your httpd.conf file.
PHPIniDir "c:/php"
Of course if you used a different directory for your PHP installation, you will need to change "c:/php" to that path. Remember to use the forward slash ("/") here again.
If you are using Apache 1, you will have already placed your php.ini file in either the Windows directory or somewhere in your PATH, so PHP should be able to find it by itself. You can of course do the same if you are using Apache 2, but I find modifying the Apache configuration file a better solution than cluttering your c:\windows directory or your PATH variable.
Steps to Setting Up PHP 5
Download PHP 5
Before you begin, get a copy of PHP 5 from the PHP download page. In particular, download the VC6 thread-safe zip package from the "Windows Binaries" section — that is, don't get the installer. For example, select the package labelled "PHP 5.2.5 zip package" if 5.2.5 is the current version.
Install PHP 5
Create a folder on your hard disk for PHP. I suggest "c:\php" although you can use other names if you wish. Personally though, I prefer to avoid names with spaces in it, like "c:\Program Files\php" to avoid potential problems with programs that cannot handle such things. I will assume that you used c:\php in this tutorial.
Extract all the files from the zip package into that folder. To do that simply double-click the zip file to open it, and drag all the files and folders to c:\php.
Upgraders: Remove the Old PHP.INI File from Your Windows Directory
If you are upgrading to PHP 5 from an older version, go to your windows directory, typically c:\windows, and delete any php.ini file that you have previously placed there.
Configuring PHP
Go to the c:\php folder and make a copy of the file "php.ini-recommended". Name the new file "php.ini". That is, you should now have a file "c:\php\php.ini", identical in content with "c:\php\php.ini-recommended".
Note: if you are using Apache 1, you should either move the php.ini file to your windows directory, "C:\Windows" on most systems, or configure your PATH environment variable to include "c:\php". If you don't know how to do the latter, just move the php.ini file to the "c:\windows" folder. You do not have to do this if you are using Apache 2, since we will include a directive later in the Apache 2 configuration file to specify the location of the php.ini file.
Use an ASCII text editor (such as Notepad, which can be found in the Accessories folder of your Start menu) to open "php.ini". You may need to make the following changes to the file, depending on your requirements
Enable Short Open Tags
Search for the line that reads:
short_open_tag = Off
If short_open_tag is set to "off", tags like "short_open_tag = On
Magic Quotes
By default, input data is not escaped with backslashes. That is, if your visitors enter an inverted comma (single quote) into your web form, the script will receive that unadorned inverted comma (single quote). This is for the most part desirable unless you have special requirements. If you want your input data to have the backslash ("\") prefix, such as, for example, to mimic your web host's settings, search for the following:
magic_quotes_gpc = Off
and replace it with:
magic_quotes_gpc = On
Do not do this unless your web host has this setting as well. Even with the setting of "Off", you can still use the addslashes() function in PHP to add the slashes for the specific pieces of data that need them.
Register Globals
A number of older scripts assume that all data sent by a form will automatically have a PHP variable of the same name. For example, if your form has an input field with a name of "something", older PHP scripts assume that the PHP processor will automatically create a variable called $something that contains the value set in that field.
If you are running such scripts, you will need to look for the following field:
register_globals = Off
and change it to the following:
register_globals = On
WARNING: Do NOT do this unless you have third party scripts that need it. When writing new scripts, it's best to always code with the assumption that the register_globals item is set to "Off".
Display Errors
On a "live" website, you typically want errors in your script to be silently logged to a PHP error file. On your own local machine, however, while you are testing and debugging a PHP script, it is probably more convenient to have error messages sent to the browser window when they appear. This way, you won't miss errors if you forget to check the error log file.
If you want PHP to display error messages in your browser window, look for the following:
display_errors = Off
And change it to:
display_errors = On
This value should always be set to "Off" for a "live" website.
Session Path
If your script uses sessions, look for the following line:
;session.save_path = "/tmp"
The session.save_path sets the folder where PHP saves its session files. Since "/tmp" does not exist on Windows, you will need to set it to a directory that does. One way is to create a folder called (say) "c:\tmp" (the way you created c:\php earlier), and point this setting to that folder. If you do that, change the line to the following:
session.save_path = "c:\tmp"
Notice that in addition to changing the path, I also removed the semi-colon (";") prefix from the line.
Alternatively, you can find out the current TEMP folder on your computer and use that. Or create a "tmp" folder in your PHP directory, like "c:\php\tmp" and set the configuration file accordingly. The possibilities are endless. If you can't decide, just create "c:\tmp" and do as I said above.
SMTP Server
If your script uses the mail() function, and you want the function to successfully send mail on your local machine, look for the following section:
[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25
; For Win32 only.
;sendmail_from = me@example.com
Change it to point to your SMTP server and email account. For example, if your SMTP server is "mail.example.com" and your email address is "youremail@example.com", change the code to:
[mail function]
SMTP = mail.example.com
smtp_port = 25
sendmail_from = youremail@example.com
Note that after you do this, when your script tries to use the mail() function, you will need to be connected to your ISP for the function to succeed. If you do not modify the above lines and attempt to use mail() in your script, the function will return a fail code, and display (or log) the error (depending on how you configure php.ini to handle errors).
(Note that in Apache 1.x, the smtp_port line may not be present. If so, don't include it.)
How to Configure Apache for PHP 5
There are two ways to set up Apache to use PHP: the first is to configure it to load the PHP interpreter as an Apache module. The second is to configure it to run the interpreter as a CGI binary. I will supply information for how you can accomplish both, but you should only implement one of these methods. Choose the module method if your web host also installed PHP as an Apache module, and use the CGI method if they have implemented it to run as a CGI binary.
Running PHP 5 as an Apache Module
To configure Apache to load PHP as a module to parse your PHP scripts, use an ASCII text editor to open the Apache configuration file, "httpd.conf". If you use Apache 1.x, the file is found in "c:\Program Files\Apache Group\Apache\conf\". Apache 2.0.x users can find it in "C:\Program Files\Apache Group\Apache2\conf\" while Apache 2.2.x users can find it in "C:\Program Files\Apache Software Foundation\Apache2.2\conf\". Basically, it's in the "conf" folder of wherever you installed Apache.
Search for the section of the file that has a series of "LoadModule" statements. Statements prefixed by the hash "#" sign are regarded as having been commented out.
If you are using Apache 1.x, add the following line after all the LoadModule statements:
LoadModule php5_module "c:/php/php5apache.dll"
If you are using Apache 2.0.x, add the following line after all the LoadModule statements:
LoadModule php5_module "c:/php/php5apache2.dll"
If you are using Apache 2.2.x, add the following line instead:
LoadModule php5_module "c:/php/php5apache2_2.dll"
Note carefully the use of the forward slash character ("/") instead of the traditional Windows backslash ("\"). This is not a typographical error.
If you are using Apache 1.x, search for the series of "AddModule" statements, and add the following line after all of them. You do not have to do this in any of the Apache 2 series of web servers.
AddModule mod_php5.c
Next, search for "AddType" in the file, and add the following line after the last "AddType" statement. Do this no matter which version of Apache you are using. For Apache 2.2.x, you can find the "AddType" lines in the
AddType application/x-httpd-php .php
If you need to support other file types, like ".phtml", simply add them to the list, like this:
AddType application/x-httpd-php .phtml
Finally, for those using one of the Apache 2 versions, you will need to indicate the location of your PHP ini file. Add the following line to the end of your httpd.conf file.
PHPIniDir "c:/php"
Of course if you used a different directory for your PHP installation, you will need to change "c:/php" to that path. Remember to use the forward slash ("/") here again.
If you are using Apache 1, you will have already placed your php.ini file in either the Windows directory or somewhere in your PATH, so PHP should be able to find it by itself. You can of course do the same if you are using Apache 2, but I find modifying the Apache configuration file a better solution than cluttering your c:\windows directory or your PATH variable.
Subscribe to:
Comments (Atom)