Efficient way to retrieve work item details from a Linked Query using TFS API

Requirement: Retrieve WorkItems details of a linked query using TFS API Problem Statement: We can query a linked Query item using TFS Workitem Query language, But the challenge with linked query is, it displays only SourceId and TargetId along with LinkTypeId. It does not display other important fields like title, status, description e.t.c In Order … Continue reading Efficient way to retrieve work item details from a Linked Query using TFS API

Tool to calculate 90th percentile for common transactions on a visual studio Load test run

Requirement As a performance tester, I need to calculate 90th percentile for common transactions, from the Transaction summary of Load Test Runs Problem Statement In the visual studio Test transaction summary report, we have scenarios where in same transaction reported multiple times with different response times(due to load and application behavior). Example: Login transaction which … Continue reading Tool to calculate 90th percentile for common transactions on a visual studio Load test run

Read data from multiple data sources using Visual studio WebTest

Requirement As a performance tester, I should be able to read the data from any number of the datasource based on the my requirement (Ex: Different environments Test,UAT,Prod) We can accomplish the same using below code snippet     [DataSource("TestDataSource", "System.Data.SqlClient", Constants.TestDataConnectionString, Microsoft.VisualStudio.TestTools.WebTesting.DataBindingAccessMethod.Sequential, Microsoft.VisualStudio.TestTools.WebTesting.DataBindingSelectColumns.SelectAllColumns, "Users")] [DataBinding("TestDataSource", "Users", "userid", "TestDataSource.Users.userid")] [DataSource("UATDataSource", "System.Data.SqlClient", Constants.TestDataConnectionString, Microsoft.VisualStudio.TestTools.WebTesting.DataBindingAccessMethod.Sequential, Microsoft.VisualStudio.TestTools.WebTesting.DataBindingSelectColumns.SelectAllColumns, "Users")] [DataBinding("UATDataSource", "Users", … Continue reading Read data from multiple data sources using Visual studio WebTest

Control code execution between Load and Webtests

Requirement As a performance tester, I would like to Execute a specific plugin/block of Code during Webtest and skip the same code, when I execute the load test(Which has this WebTest) and ViceVersa This need to done without making any configuration changes while running web or loadtest. We can use below sample codesnippet to accomplish the same … Continue reading Control code execution between Load and Webtests

Difference between Azure Service Manager and Azure Resource Manager

ASM ARM     This is an old portal which provides Cloud service for Iaas Workload and few specific Paas Workload They are new portal provides service for all Workload of IaaS and PaaS Access over the Url: https://manage.windowsazure.com which  termed as V1 portal. Access over the Url: https://portal.azure.com which  termed as V2 portal  having … Continue reading Difference between Azure Service Manager and Azure Resource Manager

Configuring SQL Reporting Services for Remote or different SCOM DW Database

This article mentions how to configure the SQL Reporting Services for generating reports from a remote SCOM Data Warehouse database (DW DB). This will also be of help for reconfiguring the Reporting Service when there is a change in the SCOM DW DB, Port or Server Name. In a simple/test single server SCOM installation environment, … Continue reading Configuring SQL Reporting Services for Remote or different SCOM DW Database

Docker – Fails to create container on Windows 10 – Error response from daemon container..encountered an error during start

Thought to share findings that came across on fixing the below issue. May be it can help someone while working in docker with Windows 10.  Issue: Unable to create docker container on Windows 10 Version 1607 Workaround: docker run -it --rm --net=none microsoft/nanoserver cmd  Finding & Cause: Gather the network trace using command - netsh … Continue reading Docker – Fails to create container on Windows 10 – Error response from daemon container..encountered an error during start