motivational quotes from book How to be a winner

By | April 4, 2021

Motivational quotes from book How to be a winner, Dare to do new things Dare to come out of the routines which you are following from long time. Never hate anyone, don’t waste energy there. Show your love to the people you love in your words, act  etc. Start now….now…now Think, Act and Speak Positivity.… Read More »

Singleton design Pattern in C# with examples

By | April 3, 2021

Singleton desing Pattern in C# with example It is creational design pattern, as it deals with object creation and manipulation. Here we are going to learn, What is singleton desing pattern When to use singleton design patterns / Why to use singleton design patterns Real-time examples of Singleton design patterns Advantages of singleton design patterns… Read More »

How to disable download bar of chrome in selenium

By | January 14, 2021

currently we faced one issue in automation like buttons were not clickable due to chome download bar was overlapping on buttons. we googled lot of keywords like “disable-infobars chrome selenium, chromedriver disable-infobars not working, disable download bar chrome, How to disable infobar in Chrome browser in Selenium”. tried below things, MoveToElement method of action class,… Read More »

Earnings at risk You need to fix ads.txt file issues to avoid severe impact

By | January 10, 2021

“Earnings at risk – You need to fix some ads.txt file issues to avoid severe impact to your revenue.” OR “To prevent severe impact on revenue, download an ads.txt file then upload the file to the root level domain of each site” Recently my Adsense Account prompt with above errors. To prevent severe impact on… Read More »

Execute store procedure with input and output parameters

By | January 10, 2021

Syntax for Executing store procedure with input and output parameters is as below, Declare @Count int exec StoredProcedureName @inputparameters = input parameter value, @outputParamsOfSP = @rowCount output For example, Lets say you are building store procedure to get details of employee by passing employee Id, and that sp should return employee is permanent or contractual.… Read More »

Splitting a list or collection into chunks in C#

By | December 12, 2020

Problem Statement –  While working on project, one requirement came like client wants to save 50k of records into db in one go. which was taking lot of time to save long list of data to be proceessed and saved in database. also we had 8 api nodes and this code were running on signle… Read More »

How to hit breakpoint of global.aspx

By | November 10, 2020

Problem Statement- How to hit breakpoint of global.aspx or breakpoint in global.aspx not getting hit or application_start is not being hit  or global.asax – breakpoint not working or hitting breakpoints in global.asax Solution for all above statements are same as below, Open the global.aspx file by clicking on it. 2.  Add space at the end before… Read More »

How to compare Columns of two tables in SQL Server

By | November 6, 2020

Background / Problem Statement – Many times while working on projects, we need to compare columns of two tables in sql server and find out what are matching columns and what are different columns in both the tables. Solution –  lets say we have below two tables, CREATE TABLE dbo.Employee ( EmployeeId INT ,fullName VARCHAR(100)… Read More »

How to clear nuget cache to get updated files on local

By | July 1, 2020

Clearing the nuget cache Many times we face wired problem like nuget packages are not getting updated locally, even after we take latest code and build or rebuild [or even clean and build] the solution properly. Then also latest nuget packages are not getting downloaded on local folder and we get some errors. Solution 1:… Read More »