Blog

How to tech guides and tutorials

What is Chrome Option in Selenium?

1. ChromeOptions in Selenium which will help to manage options like (browser in headless mode, disable info bar, add Extensions, setBinary, Load default or custom profile) to Chrome Driver. 2. ChromeOptions class extends MutableCapabilities. 3. If you want to pass any capabilities, try to use ChromeOptions. Ex.1.  Chrome Automation Info-bar            ChromeOptions Read more about What is Chrome Option in Selenium?[…]

Why Robot framework in Selenium?

Why to use  Robot Class? Because Selenium  is unable to Interact with operating system pop-ups or .exe Application So,Whenever there is a need to control keyboard or mouse to interact with OS windows like Download pop-up, Alerts, .exe applications like Notepad,Calculator, etc. Its required to use   “Robot  Class”. It helps in downloading/uploading of file. Robot  Class Read more about Why Robot framework in Selenium?[…]

Create a selenium java Framework and Project.

Readers can directly use this framework, this is compatible with all types of framework. You can download the framework using following link: https://drive.google.com/open?id=1B4ASNArSaUo8p4tB-Hf6959K0pBL5bta Create a Sample selenium java Framework and Project.    Step 1. Install TestNg Using Eclipse Marketplace.  Step 2. Go To                 File-> New -> Other -> -> Maven ->Maven Project -> Click Next Read more about Create a selenium java Framework and Project.[…]

How To Alter User-Defined Table Types in SQL Server

I cannot use ALTER to modify the type nor can I drop and recreate it since it is being referenced by existing Stored Procedures. That means, reference must be removed first. In this post, We will learn how to alter User-Defined Table types in SQL Server. Example Case: Let’s say we have multiple stored procedure Read more about How To Alter User-Defined Table Types in SQL Server[…]

How To Get Row Count For All Tables In SQL Server Database

Recently, I was working in analyzing a healthcare database where one simple task was to identify the big tables in terms of “Number of records”. So. I needed to get the row count for each tables in a SQL Server Database. There are many way to get this data. See the below T-SQL scripts: 1. Read more about How To Get Row Count For All Tables In SQL Server Database[…]

Elasticsearch For .NET Developer : How to work with Elasticsearch using c#

In this post, we are going to take a look at how to integrate Elasticsearch with .NET so that it can be useful in your .NET based projects. This post is part 3 of the series “elasticsearch for .net developer”. Before proceeding, I strongly recommend to check out previous parts listed below: Part 1 : Elasticsearch for .NET Read more about Elasticsearch For .NET Developer : How to work with Elasticsearch using c#[…]

Elasticsearch For .NET Developer : Installing and Configuration

In this post, we will guide you how to quickly set up and running single instance elasticsearch in windows operating system. This post is part 2 of the series “elasticsearch for .net developer”. Before proceeding, I strongly recommend to check out previous post Part 1 : Elasticsearch for .NET Developer – What and Why Elasticsearch You Read more about Elasticsearch For .NET Developer : Installing and Configuration[…]

Elasticsearch For .NET Developer : What and Why Elasticsearch ?

What is ElasticSearch ? Elasticsearch is an open source, NoSQL, distributed, and highly scalable full text search database that is built on top of Lucene, a search engine library written in Java. It provides extremely fast searches and makes data discovery easy. It’s a NoSQL database because it’s a document based storage system instead of using tables and Read more about Elasticsearch For .NET Developer : What and Why Elasticsearch ?[…]

How to take Screenshots when test fails in Selenium?

This method is used to take snapshot on test fail. This method will create separate folder for each test Class and store snapshot everytime with qualified name that contains ClassName, method name and date time of screenshot. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Read more about How to take Screenshots when test fails in Selenium?[…]

How to Track Stored Procedure, Function, View changes in SQL Server

Do you want to track the changes made on database objects like Stored Procedures, Views, Functions? SQL Server supports DDL Triggers that can be used to accomplish this task. SQL Server DDL Triggers is a special kind of trigger that fire in response to Data Definition Language (DDL) statements – CREATE, ALTER, DROP (Table, Function, Read more about How to Track Stored Procedure, Function, View changes in SQL Server[…]