Website Designers and Webmasters

Dedicated to all the tasks Webmasters, Website Developers and Website Designers find themselves facing.

By: Ashton Sanders

What CMS Fits Your Website Needs?

May 16 2009

This is a question I’ve been asking for a few years.

Recently, I’ve heard a lot about WordPress, Joomla, and Drupal, but it’s practically impossible to find someone who knows all three and is unbiased enough to tell you the pros and cons of each.

Through Montana Programmers, I’ve been able to find a very unbiased Polson Website Developer who has been an excellent resource for asking all sorts of random questions. Although he knows more programming languages than I have fingers and toes, he hasn’t spent years of time testing out CMS’s. 😉

As you can tell, it’s pretty hard to find a unbiased website developer who knows a lot about many of the Content Management Systems, who could give me a good comparison of the Pro’s and Con’s of each. There are a few problems here:
Continue Reading…

By: Ashton Sanders

Dreamweaver: Disable Searching for New and Changed Files

May 7 2009

Filed under: Dreamweaver,Webmaster

I use Adobe Dreamweaver 8, and every time I go to work on a large website (where I have a large number of files on my local server), I get a little pop up dialog saying:

Opening Site WebsitesinaFlash.com

Searching for new and changed files.
You can safly stop this if you have not
changed any files outside of Dreamweaver…

Here’s a quick screenshot of the dialog that pops up:

Searching for new and changed files.

Searching for new and changed files.

This has been getting increasingly annoying, as if I don’t his stop, it takes up to 10 seconds to finish the scan. Most of the time when I do hit stop, it lags for 6 seconds and then stops.
Continue Reading…

By: Ashton Sanders

Useful MSSQL Queries and Statements

May 2 2009

Filed under: SQL,Webmaster

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…

By: Ashton Sanders

Website Up Time Checker

Feb 19 2008

Filed under: Web Hosting,Webmaster

I have a couple websites that I need to make sure is always up and running. And I’ve found that using Site Up Time.com is a great way to do it.

For absolutely free, Site Up Time will check your website every 30 minutes, and email you if it is down!

Sounds like a deal to me,
-Ashton Sanders

By: Ashton Sanders

Content Management System for Websites

Nov 12 2007

From my years of working on the internet, I have come to realize that the one thing that almost all of my clients desire, is the ability to manage their own website. This way, they never have to wait on their web guy to change a phone number on their website. If they have a new product, they have the ability to add it to their own website.

Because of this huge demand for a CMS for websites, we have developed one that I call “Database in a Flash.” This Content Management System is a very user-friendly program that uses MySQL and PHP. It allows anyone who knows a little bit about the internet to communicate with their MySQL database to update their website.

It really is an amazing program. For more information, feel free to contact us.

-Let me know if you have any questions,
-Ashton Sanders

« Newer PostsOlder Posts »
RSS

Where Am I?

You have found the semi-coherent ramblings of Ashton Sanders: a website designer, developer and webmaster. This is primarily Ashton's place to save notes about techniques and things that he learns in his never-ending conquest of the internet. Hopefully it's coherent enough to be useful to you too.

Subscribe:

Enter your email to get automatic emails whenever Ashton posts on the blog.

Email:

Tags and Categories

Links

Blog Roll