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
Click here to read Windows Azure SQL Database and SQL Server – Performance and Scalability Compared and Contrasted
Reference: Pinal Dave (https://blog.sqlauthority.com)
Both White Papers seem to be unavailable. Do you have alternate links ?
Fixed one link. I am not sure where did they move the second one so I removed reference.
The link now points to “Windows Azure Table Storage and Windows Azure SQL Database – Compared and Contrasted”, not “Windows Azure SQL Database and SQL Server – Performance and Scalability Compared and Contrasted”
What we have is Windows Azure Table Storage (key:value NoSQL-ish), Windows Azure SQL Database (limited, hosted SQL Server) and SQL Server (hosted in IaaS or on-premise)…