Tips and Tricks from the Imaginet Experts

Kick off your 2016 right with some tips, tricks, and best practices from our resident Imaginet software innovation experts. From SharePoint advice to Visual Studio, TFS, and Application Lifecycle Management (ALM) best practices to lessons learned on Custom Application Development projects, we have a lot of great advice to share to get your new year started on the right foot. In this article, we will share 6 tips and tricks from our Imaginet experts, with more to…

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...

Step-by-Step Tutorial: IIS Redirect/Rewrites for SharePoint

Step-by-Step Tutorial: IIS Redirect/Rewrites for SharePoint NOTE: THIS IS NOT SUPPORTED BY MICROSOFT, PROCEED WITH CAUTION AND AT YOUR OWN RISK. Perform the following steps on the Web Front End servers only. When working with websites it is imperative to the users, customers and possibly potential customers to be able to locate information when accessing them. Change is inevitable within life just as much as it is in the companies and organizations that employ us....

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...