Microsoft Ignite took place September 24-28, 2018 in Orlando, Florida. During the conference, Microsoft has made big announcements about new features and products across a variety of business areas.
You are here
Lately I've been experimenting a bit with Azure Logic Apps, in combination with an On-premises data gateway. If you've ever used Logic Apps, you may have noticed that you have a set of actions for a SQL Server connection. What you may not know is that you can connect to a local database on your machine using a data gateway.
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.
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
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.
I was working in SharePoint and had an issue where a Managed Metadata database was showing a status of "Database is too old and upgrade is required."
I found a post that outlined how to fix a similar issue for a BDC database. The command in question was:
Recently, I was working on an implementation of a Kendo Grid. We decided that we wanted to be able to save the filters that a user had added, so that the next time they visited, the same filters would automatically be applied to the grid. Kendo has a pretty good sample of persisting the entire grid state in their forums (this can include the columns, page, pagesize, sorting, filtering, etc.).
Being able to group data into batches can be quite useful and often done for reporting purposes, but I found it handy to group a series of multiple choice questions and answers for displaying a given tester. In this case, it was for a quiz that asked the capital of a given state with four possible answers provided for each question (see Figure 2). The data was in a SQL Server database table, but it could have been retrieved via a service or a text file.
One problem that users have been facing since CRM 2011 is the discrepancy between what they see in the Activity Associated View for a record and an Activities subgrid included on the form. Someone may log a Phone Call with an Account or Contact as a recipient, but reference a Case in the Regarding field. In this instance, they’ll be able to find it in the Activity Associated View:
One of the things I typically do when working with a load script in QlikView is to assign a variable to the file path to my QVD files. That way, if the path changes, I only have to update it in one place instead of multiple places throughout the script. It usually looks something like this: