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

Synology: Commonly Used Commands

Commonly used commands via ssh with Synology NAS.
Read more

Install the .NET Core Windows Server Hosting bundle

Remember to schedule in advance, since IIS must be reset after installing .NET Core Windows Server Hosting bundle.
Read more

American Accent Training Resources

American Accent Training Book and CDs American Accent Training by Ann Cook Rebecca Linquist https://www.youtube.com/user/rebeccalinquist LISA’S YOUTUBE VIDEOS http://www.accurateenglish.com/lisas-youtube-videos/ Rachel's English Youtube Channel https://www.youtube.com/user/rachelsenglish Accent Ace https://www.youtube.com/user/AccentAceConfidence Practice American English sounds with free video lessons by Cheryl A. Posey http://www.speakingyourbest.com/freevideolessons.html Shaw English Online https://www.youtube.com/user/ShawEducation Pronunciation Pro https://www.youtube.com/user/pronunciationpro Heather Hansen https://www.youtube.com/user/heatherhansen
Read more