Getting Rails 2.0 and MS SQL Server Talking

December 17th, 2007

With version 2.0 of Rails, getting it talking to SQLServer has become a whole lot easier.

Read the rest of this entry
Posted by mikel Filed in Ruby on Rails, SQL Server and Rails
2 comments »

Query the results from a stored procedure

December 10th, 2007

I have some databases that use stored procedures for various functions, they return sets of data and I needed to query this resulting data. Found this good site on how to do it.

Posted by mikel Filed in SQL Server and Rails
0 comments »

Copying an SQLServer Database

December 1st, 2007

When you are testing and developing code, you don’t want to be playing with a live database at all, this is how you copy it to your local system.

Read the rest of this entry
Posted by mikel Filed in SQL Server and Rails
0 comments »

Connecting Active Record to a Legacy Database with Stored Procedures

November 28th, 2007

Sometimes you just have to go ahead and do it the hard way.

The last three days was that time for me. I had to write an application that interfaced with an existing MS SQLServer system, and I couldn’t change the schema of any existing table… what to do? Well… I can tell you it was a lesson in the difference between being opinionated software and bigoted software…

Read the rest of this entry
Posted by mikel Filed in Ruby on Rails, SQL Server and Rails
0 comments »

Stored Procedures and MS SQL Server

November 18th, 2007

OK, ok, OOOOKAY ALREADY!

I’ll say it…..

My name is Mikel, and I’m using Microsoft SQL Server with Rails…

Read the rest of this entry
Posted by mikel Filed in SQL Server and Rails
0 comments »