Category

Azure

Power Query for Azure tables and Updating Column Names

Power Query for Azure Tables and Updating Column Names I recently did some PowerBI work using Azure Table Storage. In the query editor, it seemed that each table I pulled in from Azure Tables had a very similar process.: Get the list of tables available for the storage account. Select a table Select the Content of the table (excluding the RowKey, PartitionKey, and timestamp columns) Expand the columns in the Content Rename the columns Azure...

How Can You Protect Your Cloud Applications from Outages?

How Can You Protect Your Cloud Applications from Outages? Were you affected by the Amazon Web Services (AWS) outage this week? If you use Quora, Slack or Trello chances are you were.  S3 Storage services in the US-East region was essentially unavailable for 4-5 hours.  Since many other AWS services and customer applications depend on S3, this had a large wide-ranging impact across many services, sites and applications. Some popular sites that were affected included: Quora...

Scaling Azure SQL Databases Up and Down

Scaling Azure SQL databases up and down   I've recently been working on a project where we push data from an on-premise database to a set of Azure SQL databases daily, and use that Azure SQL database as the source for a Power BI dataset. The dataset gets refreshed once a day. Our Azure SQL data marts are pretty small - all but one of them are under 2 GB, and the largest one is...