How you can connect with SQL Server 2005 database through Ruby in Home windows

Here's a good example using Ruby and ADO for connecting to and query an SQL Server database:

http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html

Which article demonstrates using Ruby and SQL-DMO to automate server tasks:

http://rubyonwindows.blogspot.com/2007/09/using-ruby-sql-dmo-to-automate-sql.html

David