I’m working on a problem for a client which involves connecting to a Microsoft SQL Server 2005 database from Linux using Ruby. Here’s what I did to get it working, based off some useful instructions that are tailored for Ruby on Rails:

Growing Rails Applications in Practice

Check out our e-book. Learn to structure large Ruby on Rails codebases with the tools you already know and love.

Introduce design conventions for controllers and user-facing models
Create a system for growth
Build applications to last

Connecting to MSSQL with Ruby on Ubuntu - lambie.org

Growing Rails Applications in Practice