Marty Mavis, September 29, 2018

HeidiSQL: SQL in the Land of Alps and Watches The majestic call of the Alphorn comes echoing down the mountain, filling the air with ancient mystery. A goat herder tending his modest collection of livestock patiently guides them through an alpine meadow. Children in villages festively dance around the maypole ...

Marty Mavis, September 14, 2018

Amazon Redshift 15 Minute Tutorial First, let's start with a new term to learn YACTYNTL: (Yet Another Cloud Thing You Need To Learn) You may have heard of Amazon's data wharehouse solution , Redshift - their latest and greatest magical thing in the cloud. If you're like me, you want ...

Doug Breaker, September 10, 2018

Delayed Job vs. Sidekiq - Which One Should You Choose? A few weeks ago I posed a question to Reddit asking the contributors to tell me which background job system I should use for a new project, Delayed Job or Sidekiq . I took everyone's feedback and wrote this handy ...

Marty Mavis, August 24, 2018

Sp_send_dbmail May Answer Your Reporting Problem "Can you send us a report of this data every day?", asks the ever-eager, smiling business person as he knocks on your monitor to interrupt you. He wants his reports! Businesses rely on data, and typically that data lives in a SQL Database. Reporting ...

Doug Breaker, August 7, 2018

Data stuck in Mongo? Build an crazy simple data warehouse using Zapier, Heroku, Rails, and SQLBot.co. Step by step instructions.