How to identify open transactions in SQL Server

There are many ways to find open transaction which is not COMMIT or ROLLBACK.

Below script may help you to find out open TRANSACTION in SQL Server
1- Using  SYS.SYSPROCESSES 
SELECT * FROM SYS.SYSPROCESSES WHERE OPEN_TRAN = 1

2- Using  SYS.DM_TRAN_SESSION_TRANSACTIONS
SELECT * FROM SYS.DM_TRAN_SESSION_TRANSACTIONS

PostgreSQL: How to change the password of the user

This article will teach you to change the password of the user in PostgreSQL. To change the password, we use the ALTER ROLE, its uses are ...