Developer Support
Advocacy and Innovation
Latest posts
Transpose Data Based on Repeating Pattern in a Column in Power Query
Senior Application Development Manager, Robert Reilly, walks us through an approach to transpose data based on repeating patterns in Power Query. You may run into a scenario where you receive data in say a CSV that needs to be transposed (Row become Columns). If you want to transpose a table it's pretty straight forward in Power Query. However, when you want to group the data in the rows by a numbered pattern like the same categories repeat every third row then it's not an out of the box operation you can do with the Power Query UI. This post will cover an approach I came up with to solve this problem. Rea...
HoloLens – How to Create Mixed Reality?
Rick McGuire, Senior ADM, provides an introduction to mixed reality development with a test drive using HoloLens, Unity, and Visual Studio 2015. With the invention of HoloLens, it is now possible to superimpose a virtual 3D world onto our exiting reality. HoloLens lets you create holograms, virtual objects that appear in the in the same space as our real world, and they seem like real objects! I am admittedly a geek and love Sci-fi, I always thought the idea of superimposing graphics/objects in our real-world space was intriguing. I believe that HoloLens is the first step towards making this a common oc...
ASP.Net Session Swapping – Why it happens and what can be done about it?
In this post, Senior Application Development Manager, Sanket Bakshi explains details behind the sometimes perplexing issue of Session Swapping and how to avoid it. Kernel Cache is a powerful and well-known feature introduced in IIS 7 and found in all later versions. It’s the highly performant server level cache that very efficiently delivers frequently used content. Since the cache is in kernel memory, it is served even before the request reaches the IIS pipeline and, hence, it’s lightning fast. The problem arises with ISAPI components if they are attaching session cookies on the content in Kernel cache, th...
Integrating Visual Studio Team Services with Microsoft Teams
In this post, Senior Application Development Manager, Mike Bolser demonstrates how to integrate Microsoft Teams and Visual Studio Team Services. Microsoft Teams the new chat-based workspace in Office365 offers several services to enable work group collaboration. One way of enabling work group collaboration for developers is through a built-in integration with Visual Studio Team Services. Microsoft Teams paired with Visual Studio Team Services provides a comprehensive chat and collaboration experience across your Agile and development work. Some of the features that enable this tight integration can allo...
Bots on Azure – Not as Complex as it Sounds
This post is provided by Dan Simmons, a Technical Delivery Manager within our team here at Premier Support for Developers. I was having a discussion with a colleague about how customers will help you better understand them. I had asked if they had thought about putting a bot on their webpage to help them with this and she said they had not mainly because the cost would be exorbitant to build. In my naivety, I suggested it would likely take me even only 2-3 days to create something which they could use and someone on my team (talented developers) could likely do it within hours. She was astonished and I was no...
Parsing folders in Power BI and adding the folder name as a column in the Power Query
Senior Application Development Manager, Robert Reilly, walks us through parsing multiple files contained in multiple folders from Power BI. On occasion you may have a need to parse multiple files contained in multiple folders from Power BI. As an example I am working with a colleague to generate some Power BI reports from CSV data files he has created some custom code to create by pulling data from another system. The code he uses creates a new folder that's name is a timestamp of the day the job was run. The same 5 report names exists in each timestamp folder. Since Power BI does not currently support cre...
DigiCert Certificate Management through Azure Key Vault
In a recent post from his blog, Application Development Manager Christian Reddington walked us through an introduction to Azure Key Vault. Azure Key Vault helps safeguard cryptographic keys and secrets used by cloud applications and services. It streamlines the key management process, enabling you to maintain control of keys that access and encrypt your data. Developers can create keys for development and testing in minutes, and then seamlessly migrate them to production keys. Security administrators can grant (and revoke) permission to keys, as needed. When designing a solution, you want to be sure th...
Multi-tenant WebAPI – simple admin consent
In this post, Premier Developer consultant Marius Rochon shares his application authentication experience in order to help you create your own Multi-tenant WebAPI applications. The VS.NET 2015 wizard for adding authentication to ASP.NET WebAPI projects does not support using the multi-tenant option. Here are some notes on how to implement this option yourself and create OAuth2 access tokens to such resources using separate tenants. This is not meant as an attempt to document features – rather as a record of my own experience in this area. Read the rest of Marius’ blog, along with code samples, here: https://blo...
What are Microservices and Why Should You Care?
Thanks to Premier Developer Consultant Najib Zarrari for sharing this excellent article on Microservices and the changing nature of software architecture in the industry today. Context Nowadays, trends show that market conditions are changing constantly and at a pace we have never seen before. New companies come into mature industries and completely disrupt them while existing companies that have been around for a long time are struggling to survive and to hold on to their market share. Also, building highly available and resilient software has become an essential competency no matter what business ...