Steve Grunwell

Open-source contributor, speaker, and coffee snob

Tag: MySQL

SQL-generated Hyperlinks in your Spreadsheets

I was building a QA spreadsheet the other day, where I needed to generate a number of randomly-generated WordPress posts with the posts’ titles, URLs, admin URLs, and publication date to be shared with the client via Google Drive, and needed my SQL query to generate links that could readily be pasted into the spreadsheet.

Continue reading→

WordPress Security Basics

Each year thousands of websites are hacked. Sometimes it’s by way of a crafty social engineer (someone who tricks someone into giving up information without realizing it) conning some unsuspecting user out of his/her login. Other times it’s a backdoor in some code that grants a malcontent access to a site.

If your site is running on WordPress you can rest easy – WordPress core is considered to be a very secure application. The downside to WordPress core being secure is that if someone breaks into your site you likely have nobody but yourself to blame. Never fear: these tips will help keep your site safe and sound.

Continue reading→

Elmer’s Science Fair

The Elmer’s Science Fair Facebook application allowed Facebook users who had liked the Elmer’s page to submit photos, either through direct upload or from their Facebook albums, of their children’s science fair projects for the chance to win a trip to Washington D.C.

Continue reading→

200Columbus: The Bicentennial

2012 was a big year: CERN found the Higgs Boson, Instagram was sold to Facebook for a cool $1B, and The Avengers and The Dark Knight Rises have some of the largest openings ever (both great movies, by the way). In an agency responsible for branding a city of 2M+ people, 2012 meant one thing: The Columbus Bicentennial.

Continue reading→

Columbus Museum of Art

To correspond with the re-opening of the museum after a major expansion project, the Columbus Museum of Art came to Fahlgren Mortine to completely rebuild their site. It was an ambitious project, but our efforts paid off; the new Columbus Museum of Art website was awarded a Silver ADDY at the 2011 Columbus ADDY awards.

Continue reading→

Be excellent to each other.