Search proved a relatively recession-resistant marketing channel in 2008 and 2009, but growth slowed compared with prior years. The “State of Search Engine Marketing 2010” report, from Econsultancy and the Search Engine Marketing Professional Organization (SEMPO), indicates growth is set to return in 2010. Search engine marketing spending in North America will be up nearly 14% to $16.6 billion this year. That figure includes spending on paid search advertising, search engine optimization and other search engine marketing technology. Most marketers indicated they would be spending more on paid search and search optimization efforts. Almost one-half of respondents planned to shift print budgets to the area, and more than one-third would spend less on direct mail and more on search. Most marketers saw search optimization as a tool for lead generation and driving traffic to their Website and used site traffic metrics, conversion rate and number or sales or leads as the top three ways to measure its success. Paid search was more likely to be expected to sell products directly.

Variables that are used in scripts are called scripting variables. Scripting variables enable one script to be used in multiple scenarios. For example, if you want to run one script against multiple servers, instead of modifying the script for each server, you can use a scripting variable for the server name.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

Most people probably know that can use the variable %0 in a batch file to get the name of the executing batch file. However if you use that in conjunction with some batch parameter modifiers you can easily split that into a drive, directory or filename. Therefore to get the location of an executing batch file from within that batch file you can use the variable %~dp0.