Category Archives: Uncategorized

Connecting ActiveRecord to SQL Server

What is ActiveRecord?

  • ActiveRecord is a Ruby library that was written by the creators of Ruby on Rails to do database integration. It connects classes to relational database tables to establish an almost zero-configuration persistence layer for applications.

That’s great, but we’re not using Ruby on Rails and our web app has SQL Server on the back end. How can we leverage ActiveRecord in our environment?

  • Good news! You can use ActiveRecord without Rails! If you are a Ruby programmer, you can can connect very easily to SQL Server to create models! You get a great deal of functionality such as basic CRUD operations, data validations, search support and many others!
  • All of this can be accomplished with the activerecord-sqlserver-adapter gem.

How do I connect ActiveRecord to SQL Server?

For more information, check out my example:


Cha’ Cha’ Changes

In November, I accepted a new position as a SDET within my company. With it, I get the opportunity to program in Ruby full-time, something I’ve been wanting to do for quite some time. Since then, my life has become quite the whirlwind. I have been engrossed in learning the language as well as coming up to speed with the testing culture and being an evangelist to our Devs and QAs.

I’ve also had the opportunity to talk to many people active in the community who are experts in testing to try and learn the best ways to implement automated acceptance testing within an organization.

My first order of business is to implement automated UI testing using Cucumber and Watir. I’m sure over the next few months I’ll be blogging about the challenges that we face to achieve these goals. Stay tuned!

Tagged , , ,

Software Engineering 101

On September 23rd, the Microsoft office in Polaris is hosting a FREE one day event thats targeted to help you build software.  It doesn’t cover the latest and greatest tech skill of the day, but rather fundamentals and principles to help you understand how to build software that is better designed, more maintainable and more testable.

The morning will be spent on the fundamentals surrounding object oriented programing, SOLID principles, as well as a few others.  The afternoon will be more of a hands on TDD workshop.

The conference is being put together by Jim Holmes and has a great lineup of speakers, including Jon Kruger, Scott Walker and Leon Gersing.

This is definitely one to put on the calendar.  Not to mention again…it’s FREE! 

Click here for more details and how to register