Skip to main content

[MSSQL]: Common T-SQL



-- Check version
PRINT @@Version


 SELECT * FROM sys.configurations


-- Show all processes
SELECT * FROM sys.sysprocesses


-- Check active connections
SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame
FROM sys.sysprocesses
GROUP BY dbid, loginame
ORDER BY DB_NAME(dbid)


-- Check Collation used by all databases
USE Master
GO 
SELECT NAME, COLLATION_NAME 
FROM sys.Databases 
ORDER BY DATABASE_ID ASC 
GO

-- Enable 'sa' login
ALTER LOGIN [sa] ENABLE
GO

Popular posts from this blog

GNS3: Notes

As usual, notes is for myself and might be useful and also save time for beginners start using GNS3 .
Read more

Debian: Install NASM - The Netwide Assembler

sudo apt install nasm Check NASM Version nasm -v Find out more about NASM at https://nasm.us/doc/nasmdoc0.html
Read more

Linux: compound commands

command1 ; command2 ; command3 command1 is executed, then command2, and then command3 command1 && command2 && command3 command2 is executed only if command1 run successfully (exit code is 0), command3 is executed only if command2 run successfully (exit code is 0) command1 || command2 || command3 command2 is executed only if command1 exit code is 0 (failure), command3 is executed only if command2 exit code is 0 (failure)
Read more