Microsoft provides a rich set of database technologies that can be use to implement on-premise and cloud based products and services. The question of which tool to use for a given scenario often comes up.
This well thought-out white paper lists the pros and cons of each one and the reasons for making a choice. It includes an overview of a few of these products, including:
- SQL Server
- SQL Azure
It also discusses some of the requirement areas to consider as part of the decision-making process.