SQL Server – Logins, Users
sp_helpuser SELECT * FROM sys.database_principals SELECT loginname FROM syslogins where loginname like ‘%NAME%’ EXEC sp_helplogins
Oracle – Shrink Tablespace
ALTER TABLESPACE temp SHRINK SPACE KEEP 3G VIEWS: v$tempfile V_$TEMP_SPACE_HEADER DBA_TEMP_FILES DBA_TABLESPACE_USAGE_METRICS
Linux – Print a Directory Tree
ls -R | grep “:$” | sed -e ‘s/:$//’ -e ‘s/[^-][^\/]*\//–/g’ -e ‘s/^/ /’ -e ‘s/-/|/’
SCOM Notes
scxadmin commands: Usage: scxadmin Generic options (for all commands) [-quiet] Set quiet mode (no output) General Options scxadmin -version Service Management scxadmin {-start|-stop|-restart|-status} [all|cimom|provider] Providers Management scxadmin -config-list {RunAs} scxadmin -config-set {RunAs} {CWD=|ChRootPath=|AllowRoot={true|false}} scxadmin -config-reset…
Oracle Inventory
Display Oracle Inventory Location Linux: see file /etc/oraInst.loc
Determine which databases have FILESTREAM configured in a SQL Server instance
exec sp_msforeachdb ‘use [?]; select [DBName]=”?”, ds.* from sys.data_spaces ds where type=”FD”’
Richard’s Page
hdasah fd gffghh
Powershell – Concatenate files
Example: To concatenate all .txt files in directory C:\temp and store result in outfile.txt