Whats my IP on Linux
1dig +short myip.opendns.com @resolver1.opendns.com
Rolemaster Fate Points
Fate Points Variant Rules for Rolemaster Standard System Copyright Nicholas HM Caldwell 1998 Destiny and the Player Characters “Some are born great, some achieve greatness, some have greatness thrust upon …
MSSQL Blocked Queries
12345SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) where session_id IN ( SELECT blocking_session_id FROM sys.dm_exec_requests WHERE DB_NAME(database_id)=’AIMS’ and blocking_session_id <> 0 )
Deinstall Oracle 12c
Run the installer as an elevated user 1setup.exe -deinstall -home C:\app\oracle\product\12.1.0\dbhome_1
Delete Mac Temp Files
Delete the files MacOS creates that Windows or Linux does not need. 1del /s /q /f /a ._*
Cannot Activate Windows
1). Moving an AWS AMI from one region to another causes Windows Validation to fail (180 days between checks). To tell Windows OS what validation server to use, run this …
Initialize Disk Volume
Drive is attached but not usable in Computer Manager. – Launch command line – Run C:\> diskpart 12345list disk select disk 1 online disk attribute disk clear readonly exit
Recover Windows License Activation Key
Create a vbs file and run it: 1234567891011121314151617181920212223242526Set WshShell = CreateObject("WScript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) Function ConvertToKey(Key) Const KeyOffset = 52 i = 28 Chars = "BCDFGHJKMPQRTVWXY2346789" Do Cur = 0 …
Query MongoDB
1234567891011121314151617181920212223db.getCollection(‘logs’).find({ "datetime" : { $lt: new Date(), $gte: new Date(new Date().setDate(new Date().getDate()-1)) } }) db.getCollection(‘plocsec_capacity’).find( {$and: [ {plocsecid:338}, …
Microsoft Visual C++ 2015 Redistributable Update 3
On Windows 8.1 x64, before installing VC14x64, ensure .Net 4.6.1 is installed first Installer hangs on “Updating Windows81_x64”, log indicates “Error 0x80070642: Failed to execute MSU package.”