In my soon to be Part 1 of this series I walk through the basics of SQL and even venture a bit into intermediate territory.  However this discussion is geared specifically at ACCESSING data AKA the R of our CRUD actions.  This is fine for those who are primarily focused on retrieving data from a database to be used for some purpose (e.g Economics, Stats, Math, Marketing and Finance denizens).  While this subset of SQL skills is well suited for this target audience it makes it difficult to "play on your own" – writing SQL queries and reviewing the results.  This experimentation is super important for gaining experience and comfort with SQL so I'm taking some time here to show this group a way to get started writing SQL queries.

More after the jump.

Like many folks I have been stuck using Microsoft's Communicator client to IM around the office.  I have been trying to move entirely to osx at work and Communicator has been the last hold out.  Jump past the break to see how ditched Communicator.







I was thinking about my important ssh keys and how annoying it would be if they were lost.  I thought it might be a good idea / kinda fun to solve this with QR Codes. 

Have a lot of digital books?  Wish you could read them in the car or on the go?  Don't mind alex's lovable robo voice?  I have just the thing for you.

I wanted take a second to share a little shortcut I just started using recently with several of my rails projects.  I added a little function to my .bash_profile a while ago and it has been super useful.

migrate from svn to git
So you have done the whole SVN song and dance but now you figure its high time you put on your big boy pants and moved your projects over to Git.  First off congratulations.  Git is the greatest thing since sliced bread but if you migrating you already know that.  I put together a few quick and easy steps to get you migrated to Git in no time.


A Sample Of Apple's Phone Number Detection
I'm working on a webapp and I have been struggling with disabling phone number detection in uiwebviews on ios but I believe after a bit of trial and error I may have something that works.  You may think uiwebviews and mobile safari are the same so it shouldn't matter.  Or you may think uiwebviews don't concern you.  Your just a web developer after all.  Well apple just might surprise you.  Jump past the break for a review of the situation and how I solved it.