Open the /etc/pf.conf
file in your favourite text editor in the Terminal:
sudo vim /etc/pf.conf
Add the following to the bottom of the /etc/pf.conf
file:
pass in proto tcp from any to any port 1433
Open the /etc/pf.conf
file in your favourite text editor in the Terminal:
sudo vim /etc/pf.conf
Add the following to the bottom of the /etc/pf.conf
file:
pass in proto tcp from any to any port 1433
$proxy='http://bradb:password@wmn4:8080' | |
$ENV:HTTP_PROXY=$proxy | |
$ENV:HTTPS_PROXY=$proxy | |
cd ~\Downloads | |
.\rustup-init.exe |
Get-Process -computername COMPUTERNAME | Sort-Object -Descending WS | select -first 5 | select name, description, @{l="Private Memory (GB)"; e={$_.privatememorysize / 1gb}} |
ogr2ogr -f "MSSQL" -overwrite "MSSQL:server=.;database=Flux;trusted_connection=yes;" "MSSQL:server=.;database=Flux;trusted_connection=yes;tables=vmadmin.parish_polygon" -s_srs EPSG:28355 -t_srs EPSG:4326 -nlt POLYGON -nln mapdojo.parish_polygon -lco "FID=pfi" -sql "SELECT [ogr_geometry],CAST([pfi] AS INTEGER) AS pfi,[parishc],[parish],[pfi_cr],[ufi],[ufi_cr],[ufi_old] FROM [vmadmin].[parish_polygon]" |
ogr2ogr -limit 1 -f "MSSQL" -overwrite "MSSQL:server=.;database=Flux;trusted_connection=yes;" "MSSQL:server=.;database=Flux;trusted_connection=yes;tables=vmadmin.parish_polygon" -s_srs EPSG:28355 -t_srs EPSG:4326 -nln mapdojo.parish_polygon -lco "FID=pfi" -sql "SELECT [ogr_geometry],CAST([pfi] AS INTEGER) AS pfi,[parishc],[parish],[pfi_cr],[ufi],[ufi_cr],[ufi_old] FROM [vmadmin].[parish_polygon]" |
SELECT | |
mview_name, | |
last_refresh_date "START_TIME", | |
CASE | |
WHEN fullrefreshtim <> 0 THEN | |
LAST_REFRESH_DATE + fullrefreshtim/60/60/24 | |
WHEN increfreshtim <> 0 THEN | |
LAST_REFRESH_DATE + increfreshtim/60/60/24 | |
ELSE | |
LAST_REFRESH_DATE |
declare @epochMilliseconds bigint | |
set @epochMilliseconds = 1530769196903 | |
declare @utcDateTime datetime | |
select @utcDateTime = DATEADD(MS, @epochMilliseconds%(3600*24*1000), DATEADD(DAY, @epochMilliseconds/(3600*24*1000), '1970-01-01 00:00:00.000')) | |
--The result is 2018-07-05 05:39:56.903 | |
select CONVERT(datetime, SWITCHOFFSET(@utcDateTime, DATEPART(TZOFFSET, @utcDateTime AT TIME ZONE 'AUS Eastern Standard Time'))) AS [AUS Eastern Standard Time] | |
--The result is 2018-07-05 15:39:56.903 |
Get-ItemProperty Registry::HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\Shell\Associations\URLAssociations\http\UserChoice |
gc example.txt | % { robocopy $([System.IO.Path]::GetDirectoryName($_)) .\dst $([System.IO.Path]::GetFileName($_)) /z /w:20 /r:20 /j} |
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Web.Administration") | |
$iis = New-Object Microsoft.Web.Administration.ServerManager | |
$iis.Sites |