[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

SELECT NAME, COLLATION_NAME

FROM sys.Databases

ORDER BY DATABASE_ID ASC

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

Google Credential Provider for Windows: Notes

Google Credential Provider for Windows® (GCPW) lets users sign in to Windows® devices with the Google Account they use for work. GCPW provides users with a single sign-on experience to Google services and all the security features available with their Google Account.

Microsoft Windows: Commonly Used Shortcuts

Windows shortcuts Shortcuts Description Windows + Up Arrow Maximize active window Windows + Down Arrow Restore active window Windows + Left Arrow Move active window to half left of screen Windows + Right Arrow Move active window to half right of screen Windows + A Open Notifications window Windows + C Open C ortana Windows + E Open Windows E xplorer Windows + F Open Windows' F eedback Hub Windows + I Open Windows Settings Windows + L L ock screenr Windows + M M inimize all active windows Windows + P Send screen to P rojector Windows + R Open R UN dialog Windows + Pause Open System Properties window Windows + SHIFT + S Open S creenClipping tool CTRL + SHIFT + ESC Open Task Manager

luyện

Search This Blog