Skip to content

{ Tag Archives } SQL

Database Schema Migration Tool

I have been working on database schema migration tools lately. We have 25+ database instances spread across 7 servers and sometimes it can get difficult to track which SQL changes got run against each of the databases (especially in the development environments). First I surveyed some of the existing tools.  I looked at Rails Migrations, [...]

Also tagged

SQL Hacks

Most of my SQL is usually something along the lines of: CREATE TABLE …. DROP DATABASE …. But recently I have been working on a report that has been causing some trouble. The report issues a large SQL query for each of our partners and then a fancy perl script filters, sorts, aggregates, and formats [...]

Also tagged , , ,