I have come across a couple scenarios where it has been really helpful to be able to edit the data connections and queries in an Excel file directly. In one case a connection was read-only and in another case there were multiple connections that needed to be updated to a new address and making the
Azure Key Vault is a feature within Microsoft Azure focused on the secure storage of secrets. Secrets could include user names, passwords, license keys, access keys that would be utilized by scripts or programs. So for example, a web app, PowerShell script, or an Azure function my need to utilize a service id or password
Azure Key Vault is a feature within Microsoft Azure focused on the secure storage of secrets. Secrets could include user names, passwords, license keys, access keys that would be utilized by scripts or programs. So for example, a web app, PowerShell script, or an Azure function my need to utilize a service id or password
There was a recent project announcement at Microsoft that I would like to highlight for those interested in Microsoft web development – Project Blazor. This project is being developed by the ASP.NET team and will deliver the ability to have .NET code (C#/Razor) execute directly client side in browsers at native speed in place of
Idle session timeout is a feature that kicks off after a period of inactivity, first displaying a warning prompt and then signing the user out of SharePoint Online and OneDrive for Business. This feature was announced at Ignite 2017 and is in preview tenants at the time of this post and scheduled to be rolled
SharePoint Online column formatting was announced at Ignite and is now available in production. The column formatting feature allows SharePoint site owners to control the display of fields in a SharePoint view including conditional formatting, applying formatting based on a date range, creating clickable actions, some visualizations (such as a status bar), and the use
Azure Logic Apps allow you to create workflows and processes inside your Azure environment. Logic Apps are part of the ‘serverless’ compute solutions for Azure. This means that you just pay for Azure Logic apps as you use and run them. Of course, they actually do run on servers but they are close to the
Azure Runbooks are part of Azure Automation, they are written in PowerShell and run in Azure. Azure Runbooks are typically used to automate a process done by an administrator. They can accomplish anything that you can do in PowerShell. And you can automate tasks done inside or outside of Azure, in my case I will
A good thing to know about Sharegate when doing migrations of file share data into SharePoint is that Sharegate will not import files with the file attributes of hidden or system. This is generally a good thing because these hidden files may include things like temporary files associated with Office documents. If you would like
Back in April a new feature for SharePoint Online and OneDrive was announced, support for the special characters # and % in file and folder names. This post from Bill Baer provides some background on the announcement. As I’m writing this post in August 2017, many production Office 365 tenants have this capability. However, the
