Powershell Environment Variables
$env $env:path $env:PSModulePath Full list Get-Childitem env:
Snipping Tool – Capture Contextual Menu
When you want to capture a menu option, (that annoyingly disappears when you try to capture with snipping tool), use the following procedure: Ensure there is no current capture in the snipping tool program (open/reopen…
Help about regular expressions in powershell
To get help about regular expressions in powershell, at the command prompt: help about_regular_expression
List Server Principals (Logins/Users) – SQL Server
use[master] — SQL Server authentication logins select * from sys.sql_logins — all logins/users select * from sys.server_principals order by type_desc
Display Job Information – SQL Server
use [msdb] select * from sysjobs select * from sysjobactivity select * from sysjobs_view select * from sysjobhistory order by job_id, step_id
Get last reboot time
systeminfo | findstr /C:”System Boot Time” $BootTime = (systeminfo | find “System Boot Time:”).Replace(“System Boot Time:”,””).Trim() $BootTime $Uptime = (Get-Date) – [datetime]$BootTime $Uptime
Display users using sp_who, sp_who2 – SQL Server
— 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,…
Query Connection Data – SQL Server
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…
Get position of a character in a string SQL Server T-SQL
select CHARINDEX(<char>,<columnname>,[<startpoint>]) from <tablename>;
Find a column in a SQL Server Database
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