Marty Mavis, December 15, 2018

AWS Glue - ETL in the Cloud Data Warehousing and Reporting are critical business functions. ETL (Extract, Transform and Load) plays a major role in making them possible. ETL "massages" the data, transforming and moving it between databases and systems. This enables Data Warehouses to use storage patterns conducive to ...

David T, December 1, 2018

SQuirreL SQL: The ultimate review. Read our in-depth review and walk through of SQuirrel SQL to see if it's the right SQL Editor for you.

Doug Breaker, October 8, 2018

Postico Overview and Review. Which SQL editor should you choose? That question spikes anxiety and causes night terrors to crawl up the spines of the best of us. Navicat ? HeidiSQL ? DBeaver ? Postico? You could spend weeks trying them all out. Read our review instead.

Doug Breaker, October 4, 2018

Rails find_by_sql (or joins!) - boost your rails app performance with this incredibly easy SQL tweak. Does your rails app feel sluggish? Do your app users exhale loudly in utter desperation as they wait for pages to load? Does it need a red bull and a few shots of espresso? ...

Doug Breaker, September 29, 2018

Who Needs a Slack SQL Bot? Why Start SQLBot ? Because I NEEDED it to do my CEO job well (and I hate wasting time!) Let me tell you a story. Or perhaps a couple, I tend to get wordy. I'll tell you two stories: 1. Why I started SQLBot ...

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.