Blog

How to tech guides and tutorials

How To Import Data From Excel Sheet Into A SQL Server Database using C#

Recently I was working on project where I was given huge set of master data in a excel file which i had to migrate to the database. Generally I used to prefer some migration tools for such task like Talend but unfortunately the software was not installed on my system because of recent formatting of Read more about How To Import Data From Excel Sheet Into A SQL Server Database using C#[…]

Top 15 .NET Framework Interview Questions and Answers

.Net Framework is the most widely used framework for developing the applications on windows. It supports multiple languages such as C#, VB .Net, C++, Perl, etc. to develop applications. The following section consists of top 20 interview questions with answers related to .Net framework. Most Popular .Net Interview Questions and Answers Given below is the list of Read more about Top 15 .NET Framework Interview Questions and Answers[…]

How a .NET application is Executed?

.NET framework is most popular for build different kind of windows application. In this post, we will explain how a .NET application is executed. The way .NET applications are executed is a little bit different. The below diagram shows how a .NET application is executed. The .Net framework supports many languages(C#, VB.NET, C++/CLI,F# etc.) to Read more about How a .NET application is Executed?[…]

How to kill the process running on any specific port in windows?

In this post, we will look at how can we kill a process running on any specific port in windows. If you are a developer, then often, you would have found this error message: Port 80 in use by “Unable to open process”! Follow the below steps to kill the process. Step 1 : Start command Read more about How to kill the process running on any specific port in windows?[…]

How To Drop Multiple Databases In SQL Server

During development, Developer generally create a bunch of temporary databases that you probably do not want to keep in the database for long term. Most DBAs drop at a time using either a single DROP statement or SSMS. This post explains how we can drop multiple databases in a single query. To drop multiple database we Read more about How To Drop Multiple Databases In SQL Server[…]

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[…]