Name | Description |
---|---|
Critical Hit | Unmodified 6 to hit |
Critical Wound | Unmodified 6 to wound |
Name | Description |
---|---|
Heavy | +1 to hit if remained stationary |
Function Get-LocalGroupMembers | |
{ | |
param( | |
[Parameter(ValuefromPipeline=$true)][array]$server = $env:computername, | |
$GroupName = $null | |
) | |
PROCESS { | |
$finalresult = @() | |
$computer = [ADSI]"WinNT://$server" |
$apikey = "" | |
$baseUri = "https://www.googleapis.com/customsearch/v1" | |
$cx = "" | |
$query = "site:https://app.powerbi.com" | |
function GetSearchResults([string]$start) | |
{ | |
$uri = "$($baseUri)?key=$($apikey)&cx=$($cx)&q=$($query)&start=$($start)" | |
$c = Invoke-WebRequest -Uri $uri -UseBasicParsing -Method Get |
USE [master] | |
GO | |
ALTER DATABASE [{{DATABASE-NAME}}] | |
ADD FILEGROUP CDC; | |
GO | |
ALTER DATABASE [{{DATABASE-NAME}}] ADD FILE | |
( NAME = N'{{DATABASE-NAME}}_CDC' | |
, FILENAME = N'{{SQL-DATA}}\MSSQL\DATA\{{DATABASE-NAME}}_cdc.MDF' |
<Biml xmlns="http://schemas.varigence.com/biml.xsd"> | |
<#=CallBimlScript("Connections.biml")#> | |
<Packages> | |
<Package Name="{{PACKAGE-NAME}}" ProtectionLevel="DontSaveSensitive" ConstraintMode="Linear"> | |
<Annotations> | |
<Annotation AnnotationType ="Description">{{PACKAGE-NAME}}</Annotation> | |
</Annotations> | |
<Connections> | |
<!-- BI connections --> | |
<Connection ConnectionName="Staging"/> |
gmai.com|gmail.com | |
gmail.colm|gmail.com | |
gmail.coml.com|gmail.com | |
gmail.on|gmail.com | |
gmal.com|gmail.com | |
goglemail.com|googlemail.com | |
homail.com|hotmail.com | |
htmail.com|hotmail.com |
$folder = 'C:\Data' #INPUT FOLDER PATH - e.g C:\Data | |
$files = Get-ChildItem $folder\*.csv -Exclude $folder\MergedCsvFile.csv | |
Get-Content $files | Set-Content $folder\MergedCsvFile.csv |
CREATE FUNCTION GetGeoJSON (@geo geography) | |
RETURNS varchar(max) | |
WITH SCHEMABINDING | |
/* | |
* Reference: http://stackoverflow.com/questions/6506720/reformat-sqlgeography-polygons-to-json | |
*/ | |
AS | |
BEGIN | |
DECLARE @Result varchar(max) | |
SELECT @Result = '{' + |
$domain = 'cloudflare.com' | |
$url = 'https://cloudflare-dns.com/dns-query?name='+$domain+'&type=A'; | |
$header = @{"accept"="application/dns-json"} | |
$response = (Invoke-WebRequest -Uri $url -Headers $header -UseBasicParsing).Content | |
$r = [System.Text.Encoding]::UTF8.GetString($response) | ConvertFrom-Json | |
$r | |
foreach ($item in $r.Answer) | |
{ | |
Write-Host $item |
exec sims.db_p_reset_sysman_password |