Fiverr buyers

fiverr-LogoBox1_10-48-46_My experience as a fiverr seller is going rather well after the first two months of tweaking my key gig based on what buyers ask for / try to get away with initially. Coming up to 100 orders and working out how to increase the value of orders beyond the $5 basic gig is the fun really, developing the product.

One recent buyer from Turkey has me a bit confused though rating a gig done in full and delivered early as 4 out of 5 then proceeding to order another 2 gigs. Now this guy has already screwed my 100% satisfaction 80 orders completed level 2 seller status why does he think I will give him the chance to do more damage?.

My 5th buyer was obviously a competitor out to ruin newcomers by bad rating which support kindly fixed. But what do you do with buyers who most likely through poor understanding of English also do your brand damage?.

I want to build up hourlies at people per hour too but seems harder to crack that egg as there are not so many buyers there as at fiverr where people sometimes think a seller should scrub the floor as well for $5 which once you take the fiverr commission off then the PayPal fee then the currency exchange works out to f@@kall really. It pays for me to have a nice SSD VPS for my own use though at least.

Posted in Ramblings

London web development consultant

London web development consultant

Portrait of a female executiveThis is the internet age and almost everything can be done online today, in a far more easy and convenient manner. The whole world has today become a global village owing to the closeness that the internet has brought about. The World Wide Web has opened up new avenues of income and employment for millions across the globe. It has now become significantly easier for entrepreneurs and companies to cross physical boundaries and borders of nations to expand their business on an international level thanks to the effective reach of the internet. Every company is increasingly realizing the importance of creating a strong digital presence besides having a wholesome real life image. Basically, small, medium or large scale firms as well as individual aspiring entrepreneurs are busy creating a powerful online presence through social media marketing and a well-developed website that would hook in prospective customers and clients and get them noticed among their target audiences.

Why you would need a web development consultant

Although these aspirational company heads may be having all that it takes to make it big with the right attitude and a good head on their shoulders, what most of them lack is good knowledge about the working of the online world. In short, they are not tech savvy enough to make an effective and far reaching digital impact of their brand. This is where a web development consultant steps in to help. What such companies do is offer all kinds of web related services, be it designing of the website, creating mobile applications, coming up with unique and apt e-commerce solutions, etc. All that clients have to do is share their vision of how they want their brand placed in their prospective customers’ minds and the web development handlers will convert them into reality. The developers in most agencies of repute are backed by years of experience and know exactly how to make their customers stand out from the stiff competition online so as to garner as much attention towards their brand, as possible. The London web development consultants offer a variety of web related services such as website auditing, web portal design, graphic design, online marketing, hosting and support, among other things. A good web consultant is one which gives effective advice about the clients’ online profile and digital presence in a way that it yields the desired results, or at least results that are close enough to what the customer wants.

Being tech savvy is the way to go

In this day and age of smartphones, tablets, laptops and PCs, all of which have replaced the regular file and paperwork form the offices of yore; one cannot afford to be anything but tech savvy if one is a business head. There is a lot of profit to gain online once a company gets the knack of marketing themselves on the World Wide Web in a powerful way for which taking up web consulting services is a must.

 

photo by:
Posted in experiments

SQL Server Queries to help you find fields and values

SQLIf you ever find yourself looking at a SQL server DB with no diagram, no integrity rules, and over a decade of legacy stuff lurking somewhere deep within, you may want to make use of the following two queries that will help you to find your way around and answer questions such as “where is an email address stored?”, or “I know the value 5144abc is stored in the DB but where?”

Firstly a query that will output the table name, schema, and full column name where searching for a column by full or part of it’s name.

SELECT t.name AS table_name,
  1. SCHEMA_NAME(schema_id) AS schema_name,
  2. c.name AS column_name
  3. FROM sys.TABLES AS t
  4. INNER JOIN sys.COLUMNS c ON t.OBJECT_ID = c.OBJECT_ID
  5. WHERE c.name LIKE '%password%'
  6. ORDER BY schema_name, table_name;

The second query to help you find your way around is the below which finds a value in an entire database

DECLARE @SearchStr nvarchar(100) = 'Events/Conferences'
  1.  
  2. DECLARE @Results TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630))
  3.  
  4. SET NOCOUNT ON
  5.  
  6. DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
  7. SET  @TableName = ''
  8. SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')
  9.  
  10. WHILE @TableName IS NOT NULL
  11. BEGIN
  12.     SET @ColumnName = ''
  13.     SET @TableName = 
  14.     (
  15.         SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
  16.         FROM    INFORMATION_SCHEMA.TABLES
  17.         WHERE       TABLE_TYPE = 'BASE TABLE'
  18.             AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
  19.             AND OBJECTPROPERTY(
  20.                     OBJECT_ID(
  21.                         QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
  22.                          )'IsMSShipped'
  23.                            ) = 0
  24.     )
  25.  
  26.     WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
  27.     BEGIN
  28.         SET @ColumnName =
  29.         (
  30.             SELECT MIN(QUOTENAME(COLUMN_NAME))
  31.             FROM    INFORMATION_SCHEMA.COLUMNS
  32.             WHERE       TABLE_SCHEMA    = PARSENAME(@TableName, 2)
  33.                 AND TABLE_NAME  = PARSENAME(@TableName, 1)
  34.                 AND DATA_TYPE IN ('char''varchar''nchar''nvarchar')
  35.                 AND QUOTENAME(COLUMN_NAME) > @ColumnName
  36.         )
  37.  
  38.         IF @ColumnName IS NOT NULL
  39.         BEGIN
  40.             INSERT INTO @Results
  41.             EXEC
  42.             (
  43.                 'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) 
  44.                 FROM ' + @TableName + ' (NOLOCK) ' +
  45.                 ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
  46.             )
  47.         END
  48.     END 
  49. END
  50.  
  51. SELECT ColumnName, ColumnValue FROM @Results
photo by:
Posted in SQL Server

Responsive Email templates

Looking for a nice easy to implement set of templates for responsive HTML emails, these look great and I’m sure I will use at some point soon.

 

http://zurb.com/ink/templates.php

 

Know of any others?

Posted in Coding

Duplicate folder names on iOS

Or at least on ipad, designed to be possible?. Just found on my ipad 2 that consolidating icons to a group created a second “social” folder.

Posted in Ramblings Tagged with: , ,