Category Archives: Database

Comparing strings to potentially null values in Rails

I’m fairly new to Rails, and Ruby, for that matter, and not yet sure of some basic things. I’ve read a bunch about how to test for (and not test for) nil or empty, and also about how to avoid that need – for instance, see this very useful post on keenertech.com. But, I can’t seem […]

February 20, 2014 – 3:36 pm | By Ian | Posted in Database, Ruby on Rails | Comments (0)

Simple backup logging script for frequently changing sql objects

People talk plenty about data backup, audit trails, etc., and of course that is super-important. But one thing I’ve found is that I sometimes need an easy – or at least, relatively easy – way to either roll back or just view previous versions of sql objects such as stored procedures, functions, and views. Now, […]

September 8, 2011 – 11:58 am | By Ian | Posted in Database, SQL Server, Workflow/Backup | Comments (1)