Table Storage

Official Documentation

Service Description

Microsoft Azure Table Storage is another NoSQL database in the Microsoft Azure platform. Despite what the name suggests, it is not a table-based relational database system but instead a memory for storing large semi-structured data sets in the cloud that require only a primary key for access and do not require complex relational database operations. From a single key (consisting of two mandatory attributes: partition key and row key), it is possible to read entities that consist of freely definable, typed properties (a property consists of a name, a type (e.g., string, integer), and a value).

Using the primary key values, Microsoft Azure can consolidate entries into partitions and distribute these automatically to various storage media to optimize performance. The data is automatically stored in triplicate, in a high-availability way, and can be accessed via RESTful interfaces. Alternative means of access include .NET, Java, and PHP class libraries. Although Table Storage has less functionality than SQL Database in terms of data management and complex access operations, it does provide affordable storage of semi-structured data and enables efficient, high-performance access to this data. Data sets of up to 500 terabytes per storage account are supported.

Getting Started

  1. Azure Storage Performance, Scalability and Security
    4/29/2015, Video, 0:56:44
  2. Azure205x - Microsoft Azure Storage
    5/30/2017, Mva
  3. Blobs and Tables: New Azure-Consistent Storage for your Datacenter
    5/19/2015, Video, 1:20:35
  4. Microsoft Azure Storage Explorer
    6/20/2016, Tool

Latest Content

Subscribe to News about Table Storage

Title  
Video
Video
Video
Video
Blog
Video
Blog
Blog
Video
Video
Blog
Blog
more...

Azure Documentation

1. Overview
     1.1. Introduction
     1.2. Choose Blobs, Files, or Data Disks
2. Get Started
     2.1. Create a storage account
     2.2. Blob Storage
          2.2.1. .NET
          2.2.2. Java
          2.2.3. Node.js
          2.2.4. C++
          2.2.5. PHP
          2.2.6. Python
          2.2.7. Ruby
          2.2.8. iOS
          2.2.9. Xamarin
     2.3. Queue Storage
          2.3.1. .NET
          2.3.2. Java
          2.3.3. Node.js
          2.3.4. C++
          2.3.5. PHP
          2.3.6. Python
          2.3.7. Ruby
     2.4. Table Storage
          2.4.1. .NET
          2.4.2. F#
          2.4.3. Java
          2.4.4. Node.js
          2.4.5. C++
          2.4.6. PHP
          2.4.7. Python
          2.4.8. Ruby
     2.5. File Storage
          2.5.1. Portal
          2.5.2. .NET
          2.5.3. PowerShell
          2.5.4. Windows
          2.5.5. Linux
          2.5.6. Mac
          2.5.7. Java
          2.5.8. C++
          2.5.9. Python
          2.5.10. Create a file share
          2.5.11. FAQ
     2.6. Disk Storage
          2.6.1. Create a VM using Resource Manager and PowerShell
          2.6.2. Create a Linux VM using the Azure CLI 2.0
          2.6.3. Attach a managed disk to a Windows VM using PowerShell
          2.6.4. Add a managed disk to a Linux VM
          2.6.5. Create copy of VHD stored as a Managed Disk using Snapshots in Windows
          2.6.6. Create copy of VHD stored as a Managed Disk using Snapshots in Linux
          2.6.7. Using managed disks in Resource Manager templates
3. How To
     3.1. Create a storage account
     3.2. Use blobs
          3.2.1. Service overview
          3.2.2. Searching Blob storage with Azure Search
          3.2.3. Hot and cool tiers
          3.2.4. Custom domains
          3.2.5. Using the Azure CDN to access blobs with custom domains over HTTPs
          3.2.6. Anonymous access to blobs
          3.2.7. Samples
     3.3. Use queues
          3.3.1. Concepts
          3.3.2. Samples
     3.4. Use tables
          3.4.1. Overview
          3.4.2. Table design guide
          3.4.3. Samples
     3.5. Use files
          3.5.1. Overview
          3.5.2. Troubleshoot Azure Files - Windows
          3.5.3. Troubleshoot Azure Files - Linux
          3.5.4. Samples
     3.6. Use disks
          3.6.1. Disks and VHDs for Windows VMs
          3.6.2. Disks and VHDs for Linux VMs
          3.6.3. Azure Managed Disks Overview
          3.6.4. Migrate Azure VMs to Azure Managed Disks
          3.6.5. Migrate from AWS and other platforms to Managed Disks
          3.6.6. Frequently Asked Questions about Azure IaaS VM Disks
          3.6.7. Premium Storage
               3.6.7.1. High-performance Premium Storage for VM Disks
               3.6.7.2. Migrating to Premium Storage using Azure Site Recovery
               3.6.7.3. Design for high performance
          3.6.8. Standard Storage
               3.6.8.1. Cost-effective Standard Storage and unmanaged and managed VM Disks
          3.6.9. Using unmanaged disks
               3.6.9.1. Migrate to Premium Storage
               3.6.9.2. Back up unmanaged VM disks with incremental snapshots
     3.7. Plan and design
          3.7.1. Replication
          3.7.2. Scalability and performance targets
          3.7.3. Performance and scalability checklist
          3.7.4. Concurrency
     3.8. Develop
          3.8.1. Samples
               3.8.1.1. .NET
               3.8.1.2. Java
          3.8.2. Designing HA Apps using RA-GRS
          3.8.3. Configure connection strings
          3.8.4. Use the Storage Emulator
          3.8.5. Set and retrieve properties and metadata
     3.9. Manage
          3.9.1. PowerShell
          3.9.2. Azure CLI 2.0
          3.9.3. Azure CLI 1.0
          3.9.4. Azure Automation
     3.10. Secure
          3.10.1. Security guide
          3.10.2. Encryption for data at rest
          3.10.3. Encryption at rest with customer keys
          3.10.4. Shared key authentication
          3.10.5. Shared access signatures (SAS)
          3.10.6. Tutorial: Encrypt and decrypt blobs using Azure Key Vault
          3.10.7. Require secure transfer
          3.10.8. Client-side encryption
               3.10.8.1. .NET
               3.10.8.2. Java
               3.10.8.3. Python
     3.11. Monitor and troubleshoot
          3.11.1. Disaster recovery guidance
          3.11.2. Backup and DR for IAAS disks
          3.11.3. Troubleshoot Storage Explorer
          3.11.4. Metrics and logging
               3.11.4.1. Storage Analytics
               3.11.4.2. Enable and view metrics
               3.11.4.3. Monitor, diagnose, and troubleshoot
               3.11.4.4. Troubleshooting tutorial
          3.11.5. Troubleshoot disk deletion errors
          3.11.6. Troubleshoot File storage
     3.12. Transfer Data
          3.12.1. Move data to and from Storage
          3.12.2. AzCopy on Windows
          3.12.3. AzCopy on Linux
          3.12.4. Using the Import/Export service
          3.12.5. Using the Import/Export Tool
               3.12.5.1. Setting up the Import/Export Tool
               3.12.5.2. Preparing hard drives for an import job
                    3.12.5.2.1. Setting properties and metadata during the import process
                    3.12.5.2.2. Sample workflow to prepare hard drives for an import job
                    3.12.5.2.3. Quick reference for frequently used commands for import jobs
               3.12.5.3. Previewing drive usage for an export job
               3.12.5.4. Reviewing job status with copy log files
               3.12.5.5. Repairing an import job
               3.12.5.6. Repairing an export job
               3.12.5.7. Troubleshooting the Import/Export Tool
               3.12.5.8. Import/Export service manifest file format
               3.12.5.9. Import/Export service metadata and properties file format
               3.12.5.10. Import/Export service log file format
          3.12.6. Using the Import/Export Tool (v1)
               3.12.6.1. Setting up the Import/Export Tool
               3.12.6.2. Preparing hard drives for an import job
                    3.12.6.2.1. Setting properties and metadata during the import process
                    3.12.6.2.2. Sample workflow to prepare hard drives for an import job
                    3.12.6.2.3. Quick reference for frequently used commands for import jobs
               3.12.6.3. Previewing drive usage for an export job
               3.12.6.4. Reviewing job status with copy log files
               3.12.6.5. Repairing an import job
               3.12.6.6. Repairing an export job
               3.12.6.7. Troubleshooting the Import/Export Tool
               3.12.6.8. Import/Export service manifest file format
               3.12.6.9. Import/Export service metadata and properties file format
               3.12.6.10. Import/Export service log file format
          3.12.7. Using the Azure Import/Export service REST API
               3.12.7.1. Creating an import job
               3.12.7.2. Creating an export job
               3.12.7.3. Retrieving state information for a job
               3.12.7.4. Enumerating jobs
               3.12.7.5. Cancelling and deleting jobs
               3.12.7.6. Backing up drive manifests
               3.12.7.7. Diagnostics and error recovery for Import/Export jobs
4. Reference
     4.1. Code samples
     4.2. PowerShell
     4.3. Azure CLI
     4.4. .NET
          4.4.1. Resource Manager
          4.4.2. Data movement
          4.4.3. Blobs, Queues, Tables, and Files
     4.5. Java
     4.6. Node.js
     4.7. Ruby
     4.8. PHP
     4.9. Python
     4.10. C++
     4.11. iOS
     4.12. Android
     4.13. REST
          4.13.1. Blobs, Queues, Tables, and Files
          4.13.2. Resource provider
          4.13.3. Import/Export
5. Related
     5.1. Classic Portal
          5.1.1. Create storage account
          5.1.2. Enable and view metrics
          5.1.3. Monitor, diagnose, and troubleshoot
          5.1.4. Troubleshooting tutorial
6. Resources
     6.1. Azure Roadmap
     6.2. Azure Storage client tools
     6.3. Forum
     6.4. Pricing
     6.5. Pricing calculator
     6.6. Service updates
     6.7. Stack Overflow
     6.8. Videos
     6.9. Azure Storage Explorer
          6.9.1. Storage Explorer (Preview)
          6.9.2. Manage blobs with Storage Explorer (Preview)
          6.9.3. Using Storage Explorer (Preview) with Azure file storage
          6.9.4. Storage Explorer (Preview) release notes
     6.10. NuGet packages
          6.10.1. Azure Storage Client Library for .NET
          6.10.2. Azure Storage Data Movement Library
          6.10.3. Azure Configuration Manager
     6.11. Source code
          6.11.1. .NET
               6.11.1.1. Blob, queue, table, and file
               6.11.1.2. Data movement
               6.11.1.3. Resource provider
          6.11.2. Node.js
          6.11.3. Java
          6.11.4. C++
          6.11.5. PHP
          6.11.6. Python
          6.11.7. Ruby
          6.11.8. iOS

Online Training Content

Date Title
5/30/2017 Azure205x - Microsoft Azure Storage
5/24/2017 Developing NoSQL Solutions in Azure
3/7/2015 Microsoft Azure Fundamentals: Storage and Data
12/23/2014 You've Got Documents! A MongoDB Jump Start
2/13/2014 Windows Azure Storage - Design and Implementation Jump Start
2/13/2014 Windows Azure Storage - Design and Implementation Jump Start

Tools

Tool Description
Cloud Combine Cloud Combine is IDE for cloud services that works in a way you expect. It supports Microsoft Azure, Amazon AWS and Google Cloud as well as golden classics such as FTP.
Azure Management Studio One tool to manage your Microsoft Azure cloud storage, diagnostics data and application workflows.
Microsoft Azure Storage Explorer Microsoft Azure Storage Explorer (Preview) is a standalone app from Microsoft that allows you to easily work with Azure Storage data on Windows, OSX and Linux.

Videos

Date Title Length
5/10/2017 Demystifying Cloud Data Services for an App Developer 0:33:50
5/4/2017 How Johnson Controls built an intelligent cloud solution at scale 1:04:34
2/22/2017 Customize table columns in Microsoft Azure Storage Explorer 0:04:04
12/28/2016 Storage Explorer table query 0:03:44
4/27/2016 Introduction to Azure Table Storage 0:29:09
3/31/2016 Introduction to Azure Table Storage 0:29:08
3/31/2016 Introduction to Azure Table Storage 0:29:08
5/19/2015 Blobs and Tables: New Azure-Consistent Storage for your Datacenter 1:20:35
5/14/2015 Azure Table Storage 101 with Jai Haridas 0:00:00
5/4/2015 Building Performance Applications Using Microsoft Azure Storage 0:00:00

Page 1 of 2