Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I ended up on two excellent white papers on Microsoft’s site. If you are into learning SQL Database deployed on Azure, these two are essential white paper for learning.
Windows Azure SQL Database and SQL Server – Performance and Scalability Compared and Contrasted
This white paper is recently updated and one of the most important article to know the difference between SQL Server and Windows Azure SQL Database (SQL Database). There are lots of similarities and differences between SQL Database and SQL Server and they are often confused among each other. This article takes on the vary subject and explains the differences between them very clearly and with the help of examples. Here are few important sections of this white paper.
- Standard Application Scenarios
- Several Common Expections
- Classic Patterns
- General Performance Evaluation
- Evalute Performance of SQL Database
Reference: Pinal Dave (https://blog.sqlauthority.com)