Solent Systems

Web Design & Development

Top Search Engines, by Search Volume

Date posted: 24 June 2010

The lastest figures from Hitwise show the popularity of Google UK for UK based searches. These figures are based on visits to Search Engines for the 4 weeks ending 19/06/2010. Rank Website Searches 1. www.google.co.uk 87.64% 2. www.google.com 6.72% 3. www.bing.com 3.05% 4. uk.search.yahoo.com 2.58% 5. www.uk.ask.com 1.34% This continues to highlight the importance of [...]

Continue reading about Top Search Engines, by Search Volume

Consuming a WCF Service from PHP

Date posted: 5 May 2010

Below is an example PHP script which accesses the sample WCF Service defined by the WCF template in Visual Studio 2010. GetDataUsingDataContract(CompositeType composite) This function is declared by the template WCF Service in Visual Studio 2010.  It accepts a ‘CompositeType’ object as the parameter, which is itself defined within the webservice.  This object has two properties, a [...]

Continue reading about Consuming a WCF Service from PHP

If you are familiar with your database structure, and have permissions, it is possible to quickly setup a user interface to your SQL database using just Microsoft Excel. There are 2 approaches that can be taken to achieve this in a matter of minutes: Office Data Connection On the Data tab, select ‘From Other Sources’>’From [...]

Continue reading about Creating interfaces to SQL databases in Excel

Returning an ADODB.Recordset from Function

Date posted: 29 March 2010

To return an ADODB.Recordset in Visual Basic Application (VBA), from a function, the Recordset must be disconnected. Function queryDatabase(strSQL, username, password) As ADODB.Recordset       'Declare our variables     Dim strConnection, conn, rs       'Initialisation     Set rs = New ADODB.Recordset     strConnection = "Provider=sqloledb;Data Source=serverName;Initial Catalog=DbName;User Id=username;Password=password"   [...]

Continue reading about Returning an ADODB.Recordset from Function

SERP Click-Through Share

Date posted: 18 March 2010

Data temporarily released by AOL has revealed some interesting statistics regarding search engine usage. The dataset contained information on just over 36million search queries, and 19million click-throughs.  The data reinforces the importance of the first position on a search engine results page (SERP), with 42.4% of all click-throughs. The first 10 positions account for 89.9% [...]

Continue reading about SERP Click-Through Share

Top Search Engines – Volume

Date posted: 18 March 2010

The lastest figures from Hitwise show the popularity of Google UK for UK based searches. These figures are based on visits to Search Engines for the week ending 13/03/2010. Rank Website Visits 1. Google UK 73.15% 2. Google 6.72% 3. Google UK images 5.67% 4. Bing 3.57% 5. Yahoo! Search UK & Ireland 2.31% 6. Ask [...]

Continue reading about Top Search Engines – Volume

Ethical SEO

Date posted: 26 February 2010

‘Ethics’ is a term used regularly in the SEO industry due to some SEO companies who behave in a way that only benefits themselves.  There are a number of strategies available when performing search engine optimisation, but what makes a paticular strategy ethical or unethical, and why shouldn’t particular strategies by implemented? Normative ethics is [...]

Continue reading about Ethical SEO

WordPress Word Count Plugin

Date posted: 24 February 2010

Steps to Install Download plugin and unzip. Upload the plugin file to your WordPress plugins directory inside of wp-content. Activate it from the plugins menu inside of WordPress. Type ‘[ word_count ]‘ in a page or post to display the plugin (without the spaces). Enter some text in the plugin field and this SEO tool [...]

Continue reading about WordPress Word Count Plugin

WordPress String Length Plugin

Date posted: 24 February 2010

Steps to Install Download plugin and unzip. Upload the plugin file to your WordPress plugins directory inside of wp-content. Activate it from the plugins menu inside of WordPress.  Type ‘[ string_length ]‘ in a page or post to display the plugin (without the spaces). Enter some text in the plugin field and this SEO tool [...]

Continue reading about WordPress String Length Plugin

Word Count Calculator

Date posted: 23 February 2010

Enter some text in the field below and this SEO tool will let you know how many words are in the string. This simple SEO tool gives some brief, but very effective, advice for when creating a brief description of your website. This tool has been created for the reason that when submitting your URL [...]

Continue reading about Word Count Calculator