CodeCloudy

Azure | .Net | JQuery | Javascript | Umbraco

Does Azure tables internally use relational SQL to store its values?

Storage Emulator which comes with the Azure SDK, will simulate the Azure Cloud Storage environment in the local Development environment. And it uses sqlExpress/localdb with NTFS files systems to simulate this environment. It creates this resources the first time when we run a Cloud Project using visual studio.

StorageEmulatorArchitecture

But this is only for the simulation by the Storage Emulator.

Note: In earlier azure versions after we start the storage emulator some temporary databases will be created in the sqlExpress. With new versions of SQL tools sqlExpress doesn’t run as service anymore. I couldn’t see the databases using Visual Studio Server Explorer. But, i found those temporary database files (mdf & log) in the user profile folder (C:\User\UserName\).

DevelopmentStorageDB

The actual Azure storage will store data in a completely different way without using SQL Server architecture.

BasicAzureStorageInternalArchitecture

this is a very basic view of the internal architecture. So, we have Front Ends which will authenticate & authorize incoming requests and then will route those requests to partition layer. Partition servers in the partition layer will manage all the partitions in the server.

Leave a comment »

Windows Azure Storage – Session 01 – Sri Lanka .NET Forum

Areas Covered:

 

  • —Introduction to Windows Azure Storage
  • —How to get a free account for Azure
  • —How Azure storage enables you to build highly scalable applications
  • —NoSQL with Azure storage & Comparison of Relational SQL
  • —Hands on azure portal
  • —Azure storage tools
  • —Demo on Azure storage, emulator, access programatically

Material of the Session can be downloaded via the following link:

https://onedrive.live.com/redir?resid=CBB792500B0D7760!207&authkey=!AIG9Tk5qer-wPBg&ithint=folder%2c.zip

The above link is also stored using windows azure storage blobs which we discussed in the session.

In future sessions we will try to cover more with azure technologies such as how to start with cloud applications, push notifications with Windows 8 & Windows Mobile, access control services, SQL Azure, Azure Virtual Machines, Web sties, Mobile Services, Cloud services, Service Bus, etc.

Hope you gained something from the First Session on Azure. Cheers!

Leave a comment »