SQL servers implementation is pretty good although it has no real turn-key management solution (yes, it provides some infastructure) and the exact encryption result can not be reproduced external to the server.

Key management is by far the most important element of security involving encryption and it requires serious thought and planning to come up with an optimal solution. For maximum security key management should be a roll your own approach.