VSTS Test Results Reporting with Power BI

Would you like to use Power BI to build data visualizations around your Visual Studio Team Services user stories, test cases and test results?

Here are the steps to get you there: 

1. In the VSTS Work hub, build a query in VSTS to extract user stories and their associated test cases

Using C# 7 Local Function

A handy new feature introduced with C# 7 is Local Functions. As an example, in the LINQ query below, the select method is bit hard to read and can be simplified using a helper function.

void Main()



Dynamics 365/CRM 2016: How to Share Personal Views in the Mobile App

Whether you’re a user that just wants to share a view with someone or you’re an administrator/manager that would like to create and distribute personalized views, sharing personal views is a very common thing, so it’s surprising that CRM for Tablets does not support it. Shared views that a user does not own do not display in the mobile app. Even worse, if the user has access to a dashboard that contains personal views, they’ll receive a generic error:

CORS Security, and Allowing JSONP Responses from Web API

When building a Web API project, you need to keep in mind how requests to your methods will be made. If requests are made client-side, you'll need to take CORS (Cross-Origin Resource Sharing) security into consideration. This can be done a few ways, which I won't get into for the sake of this post, but you can find more information about CORS here.

Follow the Sun: Handoffs via Kanban within VSTS or TFS

Do you have a global software development team? Do tasks get passed daily from work site to work site around the world?

Task handoffs can be tricky when team members are many time zones apart. 

You can try using email to communicate work assignments, but emails can be overlooked and emails lack trackability.

You can try a shared spreadsheet of work items, but the spreadsheet can be cumbersome and time-consuming to maintain.

Dynamics CRM: Add Items to an OptionSet

While working in Dynamics CRM, I needed to add several options to a few different optionsets on the Lead entity. Adding the options isn’t difficult, but can be tedious and repetitive, so I didn’t want to do it manually. I decided to leveraged the CRM SDK and used a LINQPad query to populate the optionset as shown in Figure 1.

Succeeding in the 2017 IT Hiring Market

The 2017 technology hiring trends are accelerating, creating both opportunities and challenges for organizations searching for tech talent. There are many factors behind the trend. Corporate executives are anticipating deregulation and lower taxes, which is freeing up both operating budgets and capital expenditure budgets. Company information technology budgets across a wide spectrum of industries are supporting higher spending to drive organizational technical excellence forward to support revenue increases.