Azure Table Storage
For those of you looking into NoSQL engines, Windows Azure Table Storage is another player in the mix. The main difference between Windows Azure Table Storage and other engines is that it is only supported inside the Windows Azure platform. If you wish to use it outside of Windows Azure, it is not available.
How does it work? It has a similar methodology to other NoSQL engines. It uses a Key Value Pair technique to determine and locate where data is stored. There is no required definition to any specific data contents…don’t let the term Table confuse you. In fact, you can store different structures of data inside a single table.
Azure Table Storage performance is enhanced by partitioning. Data is routed to as many machines as defined partitions. This allows data to scale nicely. An additional feature built into Azure Table Storage that caught my attention was the number of duplicates for each partition. Just like SQL Azure, Azure Table Storage has three copies of any data element. In the event of data failure of a machine maintaining a partition, a secondary machine is capable of taking over the load without user intervention.
If you find Azure Table Storage to be of interest you can find lots of information on the service using a Google search for “Azure Table Storage”.
Share your thoughts on this entry into the NoSQL capabilities by email to Btaylor@sswug.org.
With Stephen Wynkoop
Did you miss SSWUGtv with Kevin Kline? He shares is thoughts on Big Data.
Watch the Show
New Features of SQL Server 2012
We have just been greeted by another new version of SQL Server in the form of SQL Server 2012/Denali. This release comes with a number of new features. In this article I talk about a few of them. AlwaysON is definitely going to be one of the most exciting new things that Microsoft has added to SQL Server and seems set to change the high availability methods used by most of the organizations. Contained databases will solve a lot of problems for DBAs who have to regularly move databases from one instance to another. And finally I talk about a new function which is added to the release and that is going to help developers a lot in future.
Featured White Paper(s)
Demystify Tempdb Performance and Management
In this white paper, Robert L Davis demystifies the best practices that work some of the time, but not all of the time, when … (read more)