To get help about regular expressions in powershell, at the command prompt: help about_regular_expression

use[master] — SQL Server authentication logins select * from sys.sql_logins — all logins/users select * from sys.server_principals order by type_desc

use [msdb] select * from sysjobs select * from sysjobactivity select * from sysjobs_view select * from sysjobhistory order by job_id, step_id

systeminfo | findstr /C:”System Boot Time” $BootTime = (systeminfo | find “System Boot Time:”).Replace(“System Boot Time:”,””).Trim() $BootTime $Uptime = (Get-Date) – [datetime]$BootTime $Uptime

— see users logged – table variable example DECLARE @whotable TABLE ( SPID INT, Status VARCHAR(1000) NULL, Login SYSNAME NULL, HostName SYSNAME NULL, BlkBy SYSNAME NULL, DBName SYSNAME NULL, Command VARCHAR(1000) NULL, CPUTime INT NULL,… 

use [master] go SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame order by 2 desc SELECT * FROM sys.dm_exec_sessions where host_name is not… 

select CHARINDEX(<char>,<columnname>,[<startpoint>]) from <tablename>;

use [XYZ] — your database name go select name, type_desc from sys.all_objects where object_id in (select object_id from sys.all_columns where upper(name)='<your column name>’) go

use [<dbname>] go SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN…