Website Designers and Webmasters

I just searched the Wordpress Plugins section for “twitter” and I got 17 pages of plugins and most of them are crap… ugh.

All I want is a Twitter Plugin that will:

1. Send a tweet to my twitter when I post on my blog.
2. Adds a re-tweet link to each blog post.

How difficult can this be? After installing a few highly-rated plugins, and not being satisfied, I decided to write up what I found.  This is only 6 of the most popular twitter plugins I could find. If you know of a better one, please let me know so I can check it out. This is in order of Best to Good. I don’t have any crappy plugins on this list. They should all work, at least partially.

Twitter Tools – v1.6

Wordpress Plugin Page

Twitter Tools is a plugin that creates a complete integration between your WordPress blog and your Twitter account.

Well that’s a promising introduction. It’s a very simple installation, and just about everything is editable in an easily-accessible Twitter Tools Page. Put in your information, select your preferences, and you are good to go.
Continue Reading…

Although I primarily use MySQL on linux servers, I’ve had a couple clients using MSSQL databases for all sorts of things from email marketing to order tracking. For these clients, I use Microsoft SQL Sever Management Studio Express and have saved many of the MSSQL queries I’ve had to create. Some of these will work fine in MySQL as is or with minimal tweaking.

Here’s a collection of the useful MSSQL Queries I’ve used and saved. This is by no means a comprehensive list of all the MSQL Queries and MSSQL statements, but I hope they can be useful for you.

MSSQL Variables

Being able to declare MSSQL Variables has saved so much time for sets queries that I need to run multiple times with slight variations.

This is a very basic example, but has everything you need. MSSQL Variables must begin with a “at symbol” (@). You first declare the MSSQL variables and assign it a character type (in this case, I’m just using varchar(55). 55 is the maximum number of characters to be stored in the variable. Then you set a value for the variables.

Declare @email1 varchar(55), @name1 varchar(55)
set @email1 = ‘%websitesinaflash.com%’
set @name1 = ‘%Ashton Sanders%’

SELECT *
FROM   email_database
WHERE email_address LIKE @email1
AND first_name LIKE @name1

MSSQL UNION

Continue Reading…