Monthly Archives: January 2026

T-SQL: List open transactions

January 12, 2026T-SQLRoman

SELECT * FROM sys.sysprocesses WHERE open_tran = 1

SELECT * FROM sys.sysprocesses WHERE open_tran = 1

List active user T-SQL connections

January 7, 2026T-SQLRoman

SELECT
    DB_NAME(dbid) as DBName,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
    AND DB_NAME(dbid) = 'mydb'
GROUP BY
    dbid, loginame

SELECT
    DB_NAME(dbid) as DBName,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
    AND DB_NAME(dbid) = 'mydb'
GROUP BY
    dbid, loginame

mysql

January 3, 2026Cheat Sheet, MySQLRoman

Backup

mysqldump -u root dbname > backup.sql

Restore

mysql -u root dbname < backup.sql

Commands

# Create database
CREATE DATABASE dbname;

# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';

# Create database
CREATE DATABASE dbname;

# Create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';