Can you please take a moment and post your comments/feedback? Thanks!
Check it out!
*SQL Azure Federations is coming soon!
SQL Azure VS Azure Tables is discussed best if the scenario is known! Though both of them “sound” similar – they are different in lot of aspects. The above info graphic is meant to delineate the difference between SQL Azure and Azure Table.
SQL Azure is a RDBMS solution whereas Azure Table is more of a NoSQL solution
SQL Azure has current limitation on Size i.e. 50 GB. Azure Table’s current limitation is secondary index is not supported.
SQL Azure supports SQL Azure reporting, SQL Azure Data sync, SQL Azure Federations (coming soon) out of the box. Also since it is a RDBMS – anyone familiar with SQL server will find the skills are very easily transferred. Also SQL Azure is at better at moving data to and fro from SQL server.
Apparently, Azure table is better at cost and scalability. But one concern is that data tends to get locked into Azure platform. By this I mean, if you use Azure Tables as your backend data store for your app and then someday you decide to move to different cloud platform then get ready for some work. So for more flexibility – opt for SQL Azure.
That’s it. It was just an introduction to “SQL Azure VS Azure Table storage”.
can you please take a moment and drop your comments/feedback – Thanks!
Update [2 jan 2012]
SQL Azure Federations is released and Max Size of a SQL Azure DB is now 150 GB.
My guest post on “SQL Azure interview questions and answers” got published on Pinal Sir’s blog. URL: http://blog.sqlauthority.com/2011/07/25/sql-server-azure-interview-questions-and-answers-guest-post-by-paras-doshi-day-25-of-31/
List of Interview questions:
1. What is SQL Azure?
2. What is cloud computing?
3. How is SQL Azure different than SQL server?
4. How many replicas are maintained for each SQL Azure database?
5. How can we migrate from SQL server to SQL Azure?
6. Which tools are available to manage SQL Azure databases and servers?
7. Tell me something about security and SQL Azure.
8. What is SQL Azure Firewall?
9. What is the difference between web edition and business edition?
10. How do we synchronize On Premise SQL server with SQL Azure?
11. How do we Backup SQL Azure Data?
12. What is the current pricing model of SQL Azure?
13. What is the current limitation of the size of SQL Azure DB?
14. How do you handle datasets larger than 50 GB?
15. What happens when the SQL Azure database reaches Max Size?
16. How many databases can we create in a single server?
17. How many servers can we create in a single subscription?
18. How do you improve the performance of a SQL Azure Database?
19. What is code near application topology?
20. What were the latest updates to SQL Azure service?
21. When does a workload on SQL Azure get throttled?
It all began when I saw interesting info graphics on his blog and asked him – how he did that? So he promptly replied back: Word 2010 smart art!
Below proverb sums up, his approach to teach me how to do it too!
So from that day onwards, I have been using smart art to create some info graphics for my blog.
It’s interesting, try it out some day!
About Yuva Microsoft Student Partner program:
YUVA is a NGO based in India and one of their campaign is to spread computer literacy among slum children’s. For this campaign they partnered with Microsoft and the name of the initiative was Yuva + Microsot student partners Digital literacy campaign. I was a part of this wonderful initiative and the few snapshots that you see were taken when we volunteers used to go and teach this wonderful bunch of intelligent students basic computer stuff.
Here are the photos from some of our sessions in Ahmedabad, India:
I read anything – literally anything and so you should know that there was no sane reason to pick up this book. Anyways here is what I promised – a monologue on why I liked reading “One Minute manager”:
I have a perception that “management” books are either exhaustive or boring. In some case, both! Also, I find no point in reading passage after passage of theories – It would have made sense if I had decade of managerial practice but sigh – I do not have any such experience; so what if I just wished to learn few things before I began the managerial journey? After reading “one minute manager”, I think, I now know few fundamental management practices. I like the feeling! So +1 here!
The book is a story of a young man in a quest to know effective management practices. yes, no boring paragraphs on management mumbo jumbo but a book having a story format. I like it! so +1 here.
Next, there are only three “secrets” that sums up the knowledge imparted in the book. Only three! I like it! so +1 here too.
The first half of the book is about knowing these three secrets. and the second half about knowing why they work. Some fundamental pointers on human behavior – I like it! so +1 here too.
And biggest +1 on the fact that it is an one hour read. That’s it – only an hour! I like it! so +1 here too.
I just watched the amazing episode number 52 of cloud cover show. it was on the newly released “windows azure toolkit for social games” and it was fun!
Anywho! I am a big fan of this show – it keeps me updated on the new and shiny things happening in the domain of the Microsoft’s cloud platform i.e. windows Azure. It’s fun and it’s one of the best way to stay updated –> check it out http://channel9.msdn.com/Shows/Cloud+Cover
“A picture is worth a thousand words” –> so here are those thousand words:
But remember that the list is based on the features and limitations (because nothing is perfect, Eh!?) of SQL Azure as on July 2011. And thanks to the ever evolving nature of SQL Azure, some of the missing features will be provided in near future. But basically, SQL Azure VS SQL server is an open ended question – it means different things in different context and it’s better discussed when the context is known.
please do drop your feedback/comments/advice/(random text of string) in comments section. if you really do that – Thanks!
After the SU8. Read What’s new in SQL Azure
Alternatively, Azure blobs can be used to store contents too. For eg. a video can be stored in blobs and since a URI is provided for a blob content, a website hosted somewhere else (say a website hosted in web role) can access the video through the URI.
Also, I found this blog post by John Viele where he shows he hosted “static” aspx web pages in Azure Blog Storage: http://jvshangout.wordpress.com/2012/02/17/virtualpathprovider-for-windows-azure-hosting-aspx-web-pages-in-blob-storage/