Recently I had a need to extract the number from a string in the database. The string would be something like ‘Monitor 16″‘ or “16 inch Monitor”. I would need to get the size for various reasons including fees and reports, but no real good way of doing it. I have come up with the following Scalar SQL Function to do this very job.
Continue reading How to use SQL to Extract a Number from a String
Kevin Douglas, Wayne Thayer and Jas Romain all assisted me with designing the Breaking the ICE Conference website. This conference is about empowering
by breaking down the communication barriers and is a very good cause. I give kudos to these gentleman as they helped me with the design and the ideas. I have attached the letter of gratitude for all to read.
Continue reading Letter of Gratitude and Kudos to People Who Helped Me
In a table I have a field that you can use comma delimited value (example 1,2,3,22). When I tried to filtering use a “LIKE” statement on the value 2, I was being returned 2 and 22. ARG!
So what do you do? You create a simple function the returns a 1 or 0. 1 being successfully found and a 0 meaning failed to find. Seems simple enough? Well it was and the function can be easily tweaked to match the solution you need! Here is the function as I used it:
Continue reading SQL Function – Find a Value in a String of Values
Recently I implemented a GEOIP solution on a client site; however, the site was built on a Microsoft SQL database engine and I could not find a solution for looking up the country name easily. Through some quick Google searches I had tripped on the site for which I started at ( http://dev.maxmind.com/geoip/csv ). The site maxmind.com gave me the MySQL solution and the mathematical solution for creating the integer. Based on this information, I created my own function in MS SQL to retrieve me the calculated IP integer for easier use.
Sometimes it is like turning a large ship around; SEO can be hard to turn around if the site is degraded. You need time and room to work. Most importantly you need to have a plan.
I have been working very hard for one of my clients to turn their site around. There is no budget for any SEM; so it is purely site structure and other basic SEO practices.
I began with some SEO Analysis using several free tools, some code, speed and structure reviews and some client interviews of where they would like to take it.
Having troubles with bots that may be scraping, hammering on your sites or other inappropriate activities and you have a classic ASP site?
This is a common issue that a lot of people go through. The trick is to filter out the good bots from the bad. Continue reading ASP – Bot Killer
Pinterest is often thought as a forum to find craft ideas, search out fashion and home decoration techniques. I thought this for a very long time. However; it can be so much more. Continue reading Using Pinterest to Enahance Ecommerce
SEO – Mobile – Web – Social Media –
These are technologies and concepts that need to be utilized in everyday business life. Just because you have been doing the same thing for the past dozen years does not mean it will work for the next dozen years. You have a story to tell and SEO, Mobile, Web and Social Media are the concepts and technology that can help you bring life back to your story. Continue reading Cha-Cha-Changes
These are the slides from my workshop that I gave on January 12, 2013. We had a good group of questions and all sorts of wonderful questions.
Before I got started was asked:
Question: “I am a lurker…How do I filter out the noise?”
My Answer: “You do not have to follow everyone. Create lists that of people that you are interested in. Check that list daily. If you are graphical type person or you like a newspaper; there are services like “Paper.li” that will read from a list and create a newspaper.
Continue reading Social Media Workshop – January 2013
Customer:
“My site is dropping ranks in Google! I used to be on the first page! I am getting really nervous!” Continue reading 3 Statements that Should Cause a Call to Action