Exactly, appropriating the transient fault application block was the first step in getting our architecture to work on the cloud. However, connections to SQL are merely one part of the puzzle.
Instances of your worker nodes might also simply vanish.
* If you only have one node this is a "hard fault." Users cannot use your application until the node is restored.
* If you have more than one it's a "soft fault." Users can often immediately retry their request.
* If your own architecture is correctly designed (many nodes with fault tolerance) it is a "transient fault." Users are oblivious to the fact that one of your 100 nodes failed - even if that specific node was servicing their request.