Installing Oracle Prerequisites on Red Hat Linux 6
# cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-ol6.repo # yum install oracle-rdbms-server-12cR1-preinstall –nogpgcheck
Powershell – Recursive Search for Strings in Files
To search for a string (grep) in files recursively with Powershell (example): gci -recurse -include *.sql|%{gc $_} | %{$_|select-string “dba”} To get the filename(s): gci -recurse -include *.txt|%{$Filename=$_;gc $_} | %{$res=$_|select-string “dba”;if ($res) {Write-Host “$Filename”}}
SQL Server – Translate object_ids/object_names
— Get object_id from object name select OBJECT_ID(‘[dbo].[testobject]’) — get object_name from object id select OBJECT_NAME(213575799)
SQL Server – Display Running Tasks
Use this query in conjunction with sp_who to display running tasks and determine whether there are sessions blocking other sessions, and who is executing the query (sp_who) SELECT command, r.session_id, r.blocking_session_id, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600)…
Changing SQL Server Database Collation
See the article: http://sqlmag.com/database-performance-tuning/seven-step-process-changing-database-collation
free -m
Real Memory Consumption = Total – (free + buffers + cached) # free -m total used free shared buffers cached Mem: 15943 15678 265 6 511 3706 -/+ buffers/cache: 11460 4483 Swap: 8159 0…
Flush and Reset Client Resolver Cache
ipconfig /flushdns
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…