Get-AzureTable -StorageAccount $myStorageAccount -StorageKey $myStorageKey
$tableName = "Table$(Get-Random)" Add-AzureTable -Name $tableName
$item = Get-Counter '\Processor(_total)\% Processor Time' | Select-Object -ExpandProperty CounterSamples Set-AzureTable -TableName $TableName -PartitionKey PerformanceInfo -RowKey ARow -InputObject $item
1..4 | Foreach-Object { New-Object PSObject -Property @{a=$_;b=get-random} } | Set-AzureTable -TableName $tableName
$articleLink = New-Object PSObject -Property @{ Name = 'Brevity is the Soul of Wit' DatePublished = [DateTime]'2/19/2012' Keyword = 'Quote, Irony' Url = 'http://wiki.answers.com/Q/What_does_%27brevity_is_the_soul_of_wit%27_mean' Description = 'Brevity may the Soul of Wit, but Polonius was never brief' } $articleLink.pstypenames.clear() $articleLink.pstypenames.add('http://Schema.org/Article') $articleLink | Set-AzureTable -TableName $tableName -PartitionKey 'Articles' -RowKey ("{0:x}" -f (Get-Random))
Get-Web -Url "http://www.imdb.com/title/tt0000001/" -AsMicrodata -ItemType http://Schema.org/Movie | Set-AzureTable -TableName $tableName -PartitionKey Movies -RowKey { [Guid]::NewGuid() }
Search-AzureTable -TableName $tableName
Search-AzureTable -TableName $tableName -ExcludeTableInfo
Search-AzureTable -TableName $tableName -Where { $_.PartitionKey -eq 'Default' }
Search-AzureTable -TableName $tableName -Where { $_.psTypeName -eq 'http://Schema.org/Article' }
$myTypeName = 'http://Schema.org/Article' $ItsMyTypeName = [ScriptBlock]::Create("`$_.psTypeName -eq '$myTypeName'") Search-AzureTable -TableName $tableName -Where $ItsMyTypeName
Search-AzureTable -TableName $tableName -Where $ItsMyTypeName -Select Name, Url, Timestamp
$term = 'Brevity' Search-AzureTable -TableName $tableName -Select Name, Description, RowKey, PartitionKey | Where-Object { $_.Name -ilike "*$term*" -or $_.Description -like "*$Term*" } | Get-AzureTable -TableName $tableName
Search-AzureTable -TableName $tableName -Select Name, Description, RowKey, PartitionKey | Where-Object { $_.Name -ilike "*$term*" -or $_.Description -like "*$Term*" } | Remove-AzureTable
Search-AzureTable -TableName $tableName -Where { $_.PartitionKey -eq 'PerformanceInfo' } -Select TableName, RowKey, PartitionKey| Remove-AzureTable -Confirm:$False
Remove-AzureTable -TableName $tableName -PartitionKey Default -RowKey 0
Remove-AzureTable -TableName $tableName -WhatIf
$replicateToTable = "ReplicatedTable$(Get-Random)" Add-AzureTable -TableName $replicateToTable Search-AzureTable -TableName $tableName | Set-AzureTable -TableName { $replicateToTable }