unit test: sql log in console

Hi.
I found unit testing in Rails very frustrating and I hope you guys can help me.
I would like to see the generated SQL when I run my unit tests that involves ActiveRecord, is that possible?

Why cant i use logger.info in test mode. The test message does not appear in the console, is it possible to turn the loggin feature on?