There are quite a few good articles on the internet with examples.

https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx