Menu

Microsoft Announces Retirement of Access Web Apps Microsoft Announces Retirement and Shutdown of Access Web Apps and Web Databases in Office 365 and SharePoint Online Did you hear? Microsoft has announced that Access web apps and Access web databases in Office 365 and SharePoint Online…

Power Query Function for Dense Ranking Power Query Function for Dense Ranking Recently I was having issues writing a measure in DAX to rank items properly (not an issue with the DAX, but in my understanding of the DAX). I did some searching and came…

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…

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…

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 for the users, customers, and possibly…

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…