Gino Ungureanu g-un--

## UseNetshInterfaceForPortForwarding.txt
netsh interface portproxy add v4tov4 listenport=port1 listenaddress=* connectport=port2 connectaddress=address

## GroupRegexReplace.ps1
"Test 1.1.1.1" -replace "(?<first>\d+\.\d+\.\d+\.)\d+", '${1}2'

## GitBook.txt
http://git-scm.com

## InsertGeometryGeographyFromLinkedServer.sql
SELECT * INTO newschema.MyNewTableName
FROM OPENQUERY([MY_SOURCE_SERVER_NAME],
	'SELECT * from [source_database_name].[schema_name].[TableName]');

## QueryWithoutLinkedServer.sql
select columns from openrowset ('sqloledb', 'machineIP';'userName';'password',
				'SELECT columns from table')

## Splatting.ps1
# Demo - Sending hash argument as function parameters

$hash = @{ "param1"=1; "param2"=2 };
$hash;

function testHash($param1=$null, $param2=$null)
{
  return $($param1 + $param2);
}
	SELECT * INTO newschema.MyNewTableName
	FROM OPENQUERY([MY_SOURCE_SERVER_NAME],
	'SELECT * from [source_database_name].[schema_name].[TableName]');
	select columns from openrowset ('sqloledb', 'machineIP';'userName';'password',
	'SELECT columns from table')
	# Demo - Sending hash argument as function parameters

	$hash = @{ "param1"=1; "param2"=2 };
	$hash;

	function testHash($param1=$null, $param2=$null)
	{
	return $($param1 + $param2);
	}