Tag: SQL

Handy SQL Code Snippets

I admit that I can be a bit lazy with my SQL coding and sometimes I do borrow handy snippets to get the job done. I should probably have memorised some of these or at least turned them into functions that can be called when required but I’ve not managed that yet (on the list …

Continue reading

It’s Easier to Save Than to Script Again

While this probably applies more to a significant part of my line of work and others that do coding and/or scripting this can be applied generally to any other sort of data, content or programmatic creation. SQL or Server Query Language is what I use to import, manipulate, interpret and extract data from databases almost every day …

Continue reading

Check Naming Conventions for Consistency

Just a quick blog before I hop on a flight back to Helsinki. One thing I noticed in Denmark was how they labelled floors in buildings, particularly when it came to labels in elevators and around escalators. Unlike what www expect in Australia, the ground floor is marked as “zero” with floor above it incrementing …

Continue reading

Backup Your Facebook, Twitter and Blog with Backupify

Are there some things that you have uploaded to a social medium that you don’t have stored anywhere else? Perhaps you are implicitly relying on Facebook and Twitter remaining operational so that all those funny comments, memorable photos, shared links and event calendars are not lost? If you have been following this blog for a …

Continue reading

Find Software on the Cheap

Have you ever wanted a piece of software but have been left wanting because of the cost? Microsoft software, in particular, can be quite expensive to acquire legitimately but there are legitimate ways to get your hands on their software. If you are studying at TAFE or a university, you may be eligible for a …

Continue reading

Portable Applications – A Convenient Necessity

Have you found yourself using a computer that doesn’t have the applications you need or is locked down to the point where you can’t install anything? I’ve come across this a few times and more often than not they have an Internet connection that is rather slow making application downloads agonising. For a while now, …

Continue reading