How to find locked tables and kill the session in Microsoft SQLServer?
Open SQL Server Management Studio (SSMS). Connect to the SQL Server instance. Open a new query window. Execute the following query to find the sessi...
Recent posts
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
Making custom fields is required in a workflow transition in Jira (ScriptRunner)
This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
How to get the value of textarea in jQuery?
You can get the value of the <textarea> control in jQuery using the below code snippet.
How to add or remove multiple classes in jQuery?
You can add or remove multiple classes from div/span/any tag in jQuery using the below code snippet,
How to add or remove the class of the div using jQuery?
You can add or remove the class of the div in jQuery using the below code snippet,
HTTP Error 500.19 - Internal Server Error
Error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.
How to get the number of rows affected in SQL Server (Transact-SQL)?
You can retrieve the no of affected rows using the system variable - ‘@@ROWCOUNT’
IIS - Cannot Start Application Pool
Error: Cannot Start Application Pool. There was an error while performing this operation.
Error: Uncaught (in promise): TypeError: Cannot read property ‘push’ of undefined TypeError: Cannot read property ‘push’ of undefined
Cannot read property ‘push’ of undefined? let fareConfigList: FareConfig[]; Solution: Initialize the array with ‘[]’ let fareConfigList: FareConfig[] = [];
How to clear the immediate window in Visual Studio 2019?
What is the use of an immediate window? It is used to debug and evaluate expressions, execute statements, and print variable values.
How can we locate the anchor element using their text in XPath?
Below code, snippets help you to find the anchor element using its text in XPath and the sample code to use it in the selenium.
npm is not recognized as internal or external command, operable program or batch file
Add the Nodejs path in your environment variables.
Setup a default route in ASP.NET Core 3.1 MVC
ASP.NET Core Creating a new ASP.NET Core Web Application on choosing an empty template will leave you with the empty configuration in the startup class fi...