SQLcl connect to Oracle

EZconnect syntax

sql user/password@//hostname/service_name

OCI syntax

sql user/password@jdbc:oracle:oci:@(description=(address_list=(address=.......ODS)))

TNS definition syntax

sql user/password@(description=(address_list=(address=.......ODS)))

Export AD Users in json format

Get-ADUser -Filter {(ObjectClass -eq "user") -and (Enabled -eq $true)} -property name,objectGUID,accountExpires,c,co,company,department,displayName,givenName,homePhone,l,mail,mailNickname,manager,physicalDeliveryOfficeName,postalCode,sAMAccountName,sn,st,streetAddress,telephoneNumber,title,userPrincipalName,facsimileTelephoneNumber,whenChanged,whenCreated,mobile,distinguishedName -SearchBase "DC=leavemealone,DC=local" | Select-object name,objectGUID,accountExpires,c,co,company,department,displayName,givenName,homePhone,l,mail,mailNickname,manager,physicalDeliveryOfficeName,postalCode,sAMAccountName,sn,st,streetAddress,telephoneNumber,title,userPrincipalName,facsimileTelephoneNumber,whenChanged,whenCreated,mobile,distinguishedName | ConvertTo-Json | Out-File $ad_user_json -encoding UTF8

FreeBSD Ports Management

Refresh Ports Collection

# rm -rf /usr/ports/.* /usr/ports/*
# svnlite co svn://svn.freebsd.org/ports/tags/RELEASE_11_3_0 /usr/ports

List all outdated Ports

# pkg version -l "<"

Update one Port

# portmaster -G devel/pkgconf