This depends on the structure of your data, but if you can compose a query for all records, you can add each to a [`TableBatchOperation`][0] and execute them all at once.

Here's an example that just gets all the results inside the same partition key, adapted from [How to get started with Azure Table storage and Visual Studio connected services][1].



    // query all rows
    CloudTable peopleTable = tableClient.GetTableReference("myTableName");
    var query = new TableQuery<MyTableEntity>();
    var result = await remindersTable.ExecuteQuerySegmentedAsync(query, null);
    
    // Create the batch operation.
    TableBatchOperation batchDeleteOperation = new TableBatchOperation();

    foreach (var row in result)
    {
        batchDeleteOperation.Delete(row);
    }
    
    // Execute the batch operation.
    await remindersTable.ExecuteBatchAsync(batchDeleteOperation);

[0]: https://learn.microsoft.com/en-us/dotnet/api/microsoft.windowsazure.storage.table.tablebatchoperation?view=azure-dotnet
[1]: https://learn.microsoft.com/en-us/azure/visual-studio/vs-storage-aspnet5-getting-started-tables#insert-a-batch-of-entities

I have an Azure Storage Table and it has 3k+ records. 

What is the most efficient way to delete all the rows in the table?

Delete All Azure Table Records

## This is now possible with [Static websites on Azure Storage][1]

### Creating a Static Website

1. Navigate to your storage account
2. Select Static Website from the blade and toggle to "enabled"

  [![Add Static Website][2]][2]

3. Once you save, this will create a URL endpoint and also a bucket named `$web` to host your files

   [![Static Endpoint][3]][3]

4. Go to your `$web` storage container and upload any files you want

### Add CDN / Custom Domain

1. Navigate to your CDN Profile and either Create / Edit your Endpoint
2. Select 'Custom Origin' and use the 'Origin Hostname' that was created for your static site

   [![Custom Origin CDN][4]][4]

3. Give Azure up to 30 minutes to propagate all the settings

### Further Reading

* [Tutorial: Host a static website on Blob Storage][5]
* [Tutorial: Use Azure CDN to enable a custom domain with SSL for a static website][6]

  [1]: https://azure.microsoft.com/en-us/blog/static-websites-on-azure-storage-now-generally-available/
  [2]: https://i.stack.imgur.com/qdy7V.png
  [3]: https://i.stack.imgur.com/i1cMA.png
  [4]: https://i.stack.imgur.com/7j6S6.png
  [5]: https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website-host
  [6]: https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-static-website-custom-domain

I have now successfully setup my static website in a CDN, 
Is there a way to specify that index.html is the default document ?
It is a 1 page site I just would like to browse to the root url without having to type /index.html .. 

Thank you

Azure CDN default document index.html

You can get a lot of noise due to minor OS and browser variations.  Here's a query that pulls the same data, but also simplifies the values so they can be grouped by more easily

```js
// scalars
let startDate = ago(31d);
let totalCount = toscalar(pageViews | where timestamp > startDate | count);
// query
pageViews
| where timestamp > startDate
| project
    Browser = case(
        client_Browser has "Firefox", "Firefox",
        client_Browser has "Safari", "Safari",
        client_Browser has "Chrome", "Chrome",
        client_Browser has "Samsung", "Samsung",
        client_Browser has "Edg", "Edge",
        client_Browser has "Opera", "Opera",
        client_Browser has "Internet Explorer", "Internet Explorer",
        client_Browser has "Silk", "Amazon Silk",
        client_Browser has "Facebook", "Facebook",
        client_Browser has "Instagram", "Instagram",
        client_Browser has "Apple Mail", "Apple Mail",
        client_Browser has "Android WebKit", "Android WebKit",
        "Other"),
   OS = case(
        client_OS has "iOS", "iOS",
        client_OS has "Android", "Android",
        client_OS has "Mac", "Mac",
        client_OS has "Windows", "Windows",
        client_OS has "Linux", "Linux",
        client_OS has "Chrome OS", "Chrome OS",
        client_OS has "Firefox OS", "Firefox OS",
        "Other")
| summarize Freq = count() by OS, Browser
| project OS, Browser, Freq, Percent = round(100.0 * Freq / totalCount, 2)
| order by Freq desc
```

anyone knows how to query Azure App Insight to get analytics on client devices ? or OS ? I seem to be able to get good stats on Client countries but not devices 

Application Insight Analytics - Query Client Browser and Device

When creating an Azure Web Bot, one of the default Web Chat clients is a fork of microsoft's [BotBuilder-Samples][1] project, specifically [49 - QnAMaker All Features][2]

The source code for `Dialog/QnAMakerBaseDialog.cs` defines the constant [`DefaultNoAnswer`][3]:

```cs
public const string DefaultNoAnswer = "No QnAMaker answers found.";
```

And then uses that value when returning a response from [`GetQnAResponseOptionsAsync`][4]:

```cs
protected async override Task<QnADialogResponseOptions> GetQnAResponseOptionsAsync(DialogContext dc)
{
    var noAnswer = (Activity)Activity.CreateMessageActivity();
    noAnswer.Text = DefaultNoAnswer; // <- used right here

    var cardNoMatchResponse = (Activity)MessageFactory.Text(DefaultCardNoMatchResponse);
           

    var responseOptions = new QnADialogResponseOptions
    {
        ActiveLearningCardTitle = DefaultCardTitle,
        CardNoMatchText = DefaultCardNoMatchText,
        NoAnswer = noAnswer,
        CardNoMatchResponse = cardNoMatchResponse,
    };

    return responseOptions;
}
```

This particular sample repo doesn't appear to leverage the `DefaultAnswer` configuration key anywhere.

You can opt to include it when available by updating the `noAnswer.Text` like this:

```diff
- noAnswer.Text = DefaultNoAnswer;
+ noAnswer.Text = this._configuration["DefaultAnswer"] ?? DefaultNoAnswer;
```

You'll also have to pass in the configuration object through the dependency management system. See [this commit][5] for a full example.

[1]: https://github.com/microsoft/BotBuilder-Samples
[2]: https://github.com/microsoft/BotBuilder-Samples/tree/gary/4.8-dotnet-templates/samples/csharp_dotnetcore/49.qnamaker-all-features
[3]: https://github.com/microsoft/BotBuilder-Samples/blob/gary/4.8-dotnet-templates/samples/csharp_dotnetcore/49.qnamaker-all-features/Dialog/QnAMakerBaseDialog.cs#L23
[4]: https://github.com/microsoft/BotBuilder-Samples/blob/gary/4.8-dotnet-templates/samples/csharp_dotnetcore/49.qnamaker-all-features/Dialog/QnAMakerBaseDialog.cs#L57-L73
[5]: https://github.com/VermontDepartmentOfHealth/covid-bot/commit/b81fd55acc927bc2aca0d15f96ece4812bd4cd17

I want change Default Answer in Q&A Maker Azure Framework Bot, but I cant find field that respond this value. I'm reading documentation (but it looks like it uses an older interface), and I'm trying to find this field but with result.

Here's my current configuration screen:


[![azure configuration screenshot][1]][1]


[1]: https://i.stack.imgur.com/x3eaD.png

How can i set default answer in Q&A Azure bot

This seems to have something to do with IPv6 - you can disable it by doing the following:

1. Go to View **Network Connections**

    [![View Network Connections][1m]][1]

2. Right click on your current network and select **Properties**

    [![Network Properties][2m]][2]

3. **Deselect IPv6** Internet Prorotcol Version 6

    [![Internet Prorotcol Version 6][3m]][3]


  [1]: https://i.stack.imgur.com/NvLtv.png
  [2]: https://i.stack.imgur.com/hp5XO.png
  [3]: https://i.stack.imgur.com/RQE7I.png
  [1m]: https://i.stack.imgur.com/NvLtvm.png
  [2m]: https://i.stack.imgur.com/hp5XOm.png
  [3m]: https://i.stack.imgur.com/RQE7Im.png

I've been working with a repo in Azure for months without any issue, but recently started getting this error intermittently when I try to update my remotes or push/pull:

OpenSSL SSL_connect: Connection was reset in connection to dev.azure.com:443

If I keep retrying, it will eventually work. No idea what is causing this.

Things I've tried:
- Updated Git
- Turned off firewall
- Tried on a different computer with no issues