PEX and Moles – Promising White Box Unit Testing

Pex automatically generates test from Visual Studio code editor. It tries interesting sets of input and output of a method. This provide a high level of test coverage automatically. Currently it is a Visual Studio add in for testing .NET Framework Applications

Moles supports Unit Testing by isolation with detours and stubs.

http://research.microsoft.com/en-us/projects/pex/

You can try it out online with no install at: http://www.pexforfun.com/

6 Steps for Website Testing at a Glance

Website Application Testing Procedures

How to test software

1) Functionality Testing
     a) Identification of requirement and goals
     b) Input data based on functional specification
     c) Output correct based on functional specification
     d) Execution of test case
     e) Compare actual to expected output       

2) Non-functional Testing
      a) Baseline Testing
           
Has performance increased
      b) Compatibility Testing
            Cross Browser, Printer, Mobile, databases, servers
      c) Compliance (Conformance) Testing
            
Sometimes 3 party testing for certification or standards to meet Quality of Service (QoS)
      d) Documentation Testing
            
Is written material readable and usable, with proper spelling and grammer?
      e) Endurance (Soak)Testing
            Testing with significant load for significant amount of time
      f) Interface Testing
           Error Handling, Connections
       g) Load Testing
             
Testing large demand on the software in peak load conditions
      h) Localization Testing
            
Will the application work in required cultures and locale?
      i) Performance Testing  
           Load Testing, Stress Testing, Endurance Testing, Sniff Test, Smoke Test
      j) Recovery Testing
           
How does the softwear recover from crashes, hardware and, services,  failures? Failsafe
      k) Security Testing
           Spam, Hacking, URLs, Scripting attacks
      l) Scalability Testing  
           
Grow to meet needs 
      a)
Usability testing
            Navigation, Content, blackbox, steps, user accuracy, recall, response

Improving Localized Searchability

Local Search Applications

  1. maps.google.com
  2. bing.com/maps
  3. local.yahoo.com
  4. city.ask.com
  5. Yellowpages.com
  6. superpages.com

Upload business data to these websites.  Also search local websites, radio stations, and newspapers for websites that also allow businesses to submit their data.

Local Search Ranking Factors, (David Mihm, Inc)

1.Claim your listing

Make sure your company information is listed and proof read information that is listed. (Getlisted.org)

2. Location

Include location in business listing (New York – Jewelers)

3.Proper Categorization

Appropriate,Keywork-rich Categories. Mention services/products in title. (Johns Kitchen – Donuts and Pastries)

4. Internet Yellowpages

Pay for Internet Yellowpage listing.

5. Customer Reviews

Yelp, Insiderpages, Yahoo, Citysearch, Google

6.Include Media

Add photo’s, videos, help your listing.

7. Link Building

8. Set measurable goals

9. Use Keyword tools

adwords.google.com/select/KeywordToolExternal, freekeywords.wordtracker.com, netconcepts.com/google-keyword-tool-annualizer.  Keyword searches should return local competitors or you may be looking at the wrong keywords.

10. Go Mobile

Negative Factors

1. List a local phone number not a 1-800

2. Don’t use one address for several different businesses.

Take a good look at what good competitors are doing to increase their rankings. And what bad competitors are doing to reduce their ranking.

SQL Server Import of Country, State, Zip, From GeoNames.Org

A few post have been made with complex solutions for importing information from GeoNames.org into SQL Server.  These involved downloading converters to change the file from UTF-8 encoding and downloading additional software (EditPad Pro) to complete the conversion to UTF-16.

A much simpler way is to open the txt file in Microsoft Excel. Let Excel perform it’s magic on the tab delimited file.

Add the headers to the top row:

The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid         : integer id of record in geonames database
name              : name of geographical point (utf8) varchar(200)
asciiname         : name of geographical point in plain ascii characters, varchar(200)
alternatenames    : alternatenames, comma separated varchar(5000)
latitude          : latitude in decimal degrees (wgs84)
longitude         : longitude in decimal degrees (wgs84)
feature class     : see http://www.geonames.org/export/codes.html, char(1)
feature code      : see http://www.geonames.org/export/codes.html, varchar(10)
country code      : ISO-3166 2-letter country code, 2 characters
cc2               : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
admin1 code       : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
admin2 code       : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
admin3 code       : code for third level administrative division, varchar(20)
admin4 code       : code for fourth level administrative division, varchar(20)
population        : bigint (4 byte int)
elevation         : in meters, integer
gtopo30           : average elevation of 30'x30' (ca 900mx900m) area in meters, integer
timezone          : the timezone id (see file timeZone.txt)
modification date : date of last modification in yyyy-MM-dd format

Then save the Excel file. Use SQL Server import to import the Excel file and your done.