• SQL

    The SQL SELECT Statement

    Most tasks you will execute against a database are done with SQL statements. Think of statements as a query, an insert, a change, or a delete operating. For example, to see all of your data, you would select all of the records from a database using the SELECT statement. Then we’ll ask for all, or *, and tell the command to show us where the data is coming from, which is the Customers table. Finally, we’ll be nice and tidy and put a semi-colon at the end; although if you forget, you can always do so after you hit return: SELECT * FROM Customers; As can be seen above, the…

  • sites

    Websites & Hairdressers

    When driving by the Aveda Institute one day, my wife pointed out to me that you can always tell how far into the program that the students are. The new hairdressers have long locks of hair, but those further along in the program have their hair get shorter and shorter and shorter. This is seemingly because they keep tweaking their hair through the program until there’s practically nothing left. Websites can turn out to be almost the exact opposite. The more you tweak it the bigger it gets, the longer it takes to load and the less time you have to focus on content. I’ve added a bunch of new…

  • sites,  Social Networking

    More Additions

    At the bottom of the sidebar, you will now find badges for my pages on the main social networks. I also added Flickr & Facebook into a new Pictures page (and added pictures to the actual Flickr account since I mostly used Facebook for that)… Also changed the title and post-info/comments sections to the dark red color scheme, since I didn’t really think they looked right as black any longer. Finally, made the navbar a little slimmer. Hope ya’ll like the changes.