Log Shipping for SQL server

SQL Server deployment architecture uses Log Shipping for disaster recovery. Database Mirroring is configured within the primary data center and Log Shipping is configured within the cross-data center. To achieve automatic failover, synchronous database mirroring with a witness (a third SQL Server instance) is configured. When zero data loss is required, the database mirroring high-safety…


UI Browser Automation using Appium with Visual Studio Android Emulator

Appium is an open source cross platform automation tool for native/hybrid and mobile web based apps. Why? You can use Appium with various languages like c#, java or Objective C with Selenium driver. Thus it is truly a cross platform automation tool! How? The machine which is running the web driver scripts communicates with the…


Beginner’s Guide to Azure Automation

Azure Automation For Azure IAAS enthusiasts, Microsoft has provided a platform to automate all the azure services using powershell. The language is tweaked and used as “powershell workflow”. Why to Use Reducing Manual Effort and help in consistent testing Managing resources (deployment/VM’s etc) How to Use Create a powershell workflow in azure web portal and…


Adjustable Think Time For Dynamic Polling Requests

So, you just recorded your script and see a polling request from the browser and if that isn’t painful enough you also notice that the time between requests changes. Never fear, we have a plug-in for that.   First, let’s deal with the pesky polling request by using the built-in loops and extraction rules. This…


Connecting Outlook with Visual Studio Online or TFS

TMO-TFS Meets Outlook! is an excellent Outlook Add in that bridges the gap between Team Foundation Server (Visual Studio Team Services) and Outlook. You can create Work Items in on premises TFS or Visual Studio Team Services from Microsoft Outlook using TMO. Once a work item is created in TFS corresponding to an Outlook object,…


Setting up Always on Availability Group

Note: It is expected that reader has basic understanding of Always On Availability groups.   Pre-requisites :- Setting up Windows Server Failover Cluster (WSFC) Installation of Windows Server edition (2008 R2 or higher), SQL Server 2012, Windows Cluster + KB for quorum voting configuration, SQL Light Speed and DFS. The primary and the secondaries on…

0

How to import Perfmon logs into a SQL Database to create Excel Pivot Charts

We came across a scenario where a customer needs to run a Performance Test of an Application but due to security policies, customer is not able to provide Server-Level access to the Servers where the Application is hosted. Without the access, a Visual Studio Load Test will not be able to collect performance metrics from…


Little Law of Queuing Theory and How It Impacts Load Testers

Load testing is all about queuing, and servicing the queues. The main goals in our tests are parts of the formula itself. For Example: the response times for a test is equivalent to service times of a queue, load balancing with multiple servers is the same as queue concurrency. Even when we look at how…


Testing and Digital Transformation

Digital Transformation Scenario World is moving from relying on paper to cloud storage, physical stores to online store, from being physically connected to becoming wireless. Due to constant changes in technology and competition, businesses are eventually forced to undergo a digital transformation to stay relevant in a dynamic marketplace. Any organization which is undergoing a…

0

How to run a PowerShell script inside a Unit Test Method

Recently, a customer had the request of  creating sanity tests to validate driver builds they were working on against the latest builds from Microsoft. The scope of the tests needed to be high level, so Coded UI tests worked for the most part to drive the test from a UI level. Some tests, though, could…