seantunwin

### Reboot is required before changes will take effect
# Disable Hyper-V
## Required to use VirutalBox
bcdedit /set hypervisorlaunchtype off

# Enable Hyper-V
## Required to use Docker for Windows
bcdedit /set hypervisorlaunchtype auto

seantunwin

seantunwin

### Source: https://www.morgantechspace.com/2015/06/powershell-find-machine-name-from-ip-address.html
## Get Computer Name from IP
# Set the known IP Address (variable not required)
#   NOTE: MUST be enclosed in quotes
$ipAddress= "192.168.1.54"
[System.Net.Dns]::GetHostByAddress($ipAddress).Hostname

## Get IP from Computer Name
# Set the known computer name (variable not required)
#   NOTE: MUST be enclosed in quotes

seantunwin

-- Get Column Name from a table
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = @table;

-- Get total number of Columns
SELECT COUNT(*) FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = @table;

seantunwin

EXEC sys.sp_linkedservers

seantunwin

openssl x509 -in CERT_NAME -text -noout

seantunwin

SELECT * FROM @table
WHERE
@column IN (
 SELECT @column FROM @table
 GROUP BY @column HAVING COUNT(*) > 1)

seantunwin

LEFT(@column, IIF(CHARINDEX('@needle', @column) > 0, CHARINDEX(@needle, @column) - 1, LEN(@column)))

seantunwin

SELECT
ROW_NUMBER() OVER (ORDER BY @id) AS num
[, columns]
FROM @table
WHERE
@id BETWEEN @start AND @end
ORDER BY @id

seantunwin

<?php
// Multi-dimensional Array to search through
$a = [
    [
        'item' => 1,
        'code' => 100
    ],
    [
        'item' => 2,
        'code' => 200