QA Bean

This week let’s talk about what is ETL System testing, and what exactly do we test when we perform this type of test? But as usual let’s start from the very beginning and understand what ETL type of system is. What Is ETL System? ETL – Extract Transfer Load. This type of a system has a special structure that is usually used in case when we want to either load or extract data in big amounts that cannot be contained in a regular API. In other words we are talking about a components that their main purpose is to move around big amounts of data and manipulate it along the way based on specific logic. ETL system implementations are different; involving different data sources on different platforms; each of those systems can be broken down to a set of interfaces that work together to move the data, but despite the differences we can commonly group them based on the direction the data flows at from data source perspective into two groups:         ...

Today I wanted to discuss a very useful tip to get a Wifi Password of a network that your machine used in the past. For software testers this knowledge is particular useful when dealing with lab equipment that was pre-set and required additional changes and modifications. Imagen a scenario when you as a quality assurance analyst in the company have received a lab laptop that you need to install some software on it, and because of the type of the software you expect that pre-set wifi password for your network might be lost. Your first order of business will be to find out and back-up existing passwords, but how to do it? Here is a quick and easy way: The only thing you need for that tip to work is Admin level access to the machine you are working on. We begin by opening a Command Prompt with admin rights Then we write the following command: netsh wlan show profile A list of existing wifi networks profiles will be shown, pick a name of the network you want ...

For those of you who start with HP ALM, or using it for basic functionality and looking to increase the capacity of the tool, I wanted to mention one of the most powerful features within HP ALM, and the one that sets it above the competitors - the ability to fully customize most of sections within the tool. This customization goes as far as giving the possibility to create new buttons with customizable functionality, updating functionality of existing functions and adding fields to different components. All that can be achieved through HP ALM’s workflow section. This sections allows configuration of day to day functionality like preventing defect from being closed without a reason, to a more complex customization with have VBScripting like exports, execution or even initiation of other tools and applications. In future posts I’m planning to explore some specific application of this powerful tool, meanwhile for those who interested here are some examples of what can be achieved...

It happens, specially when you are doing some testing with mobile devices, that you need to connect to only internally available application. The issue is with devices that have only WiFi connection and cannot be directly connected to internal network (LAN). For those cases you can create a temporary HotSpot (a connection sharing) on your Windows machine that will allow you to connect your device through it to your internal network, to have the following set-up: Lets create the set-up: Click Windows logo at the bottom left hand corner, type cmd , right-click the Cmd.exe link and select “Run as Administrator”. If you don’t have this option you cannot proceed. Sorry. Talk to your System Admin and show them this article. But if you can the following black window will open up: Here Type the command below: netsh wlan set hostednetwork mode=allow ssid=MyNetwork key=MyPass You of-course welcome to replace “MyNetwork” with the name you’d like to use for your new wifi ne...

My team and I were recently faced with a challenge that required us to search the database for a stored procedure that contains reference for a specific table or another stored procedure. We were able to accomplish that by a simple text search query that uses the system object definition and goes like that: SELECT OBJECT_NAME(object_id) FROM sys.sql_modules (nolock) WHERE definition like '%----SOME TEXT HERE----%' The interesting part begins once we were faced with a more complex system structure that included stored procedures which can be called from different databases and include inserts, updates and selects to yet another set of databases. Of curse executing the same query again and again for each database to perform the required search was not an option so the solution presented itself in an undocumented system stored procedure called sp_MSforeachtable . This stored procedure allows us execute the same query for all the databases on the server with "?" us...