It's an ok environment. There is a lot of tooling around it which is to its advantage.

Once you start doing something more advanced, though, you start seeing its flaws. I've had pretty miserable time with its query optimizer and sprocs.