| Name | Description |
|---|---|
| Critical Hit | Unmodified 6 to hit |
| Critical Wound | Unmodified 6 to wound |
| Name | Description |
|---|---|
| Heavy | +1 to hit if remained stationary |
Matt Smith matt40k
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 = '{' + |
matt40k
/ Get-LocalAdmins.ps1
Last active
February 5, 2025 13:05
Get the members of the Local Administrators group
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Get-LocalGroupMembers | |
| { | |
| param( | |
| [Parameter(ValuefromPipeline=$true)][array]$server = $env:computername, | |
| $GroupName = $null | |
| ) | |
| PROCESS { | |
| $finalresult = @() | |
| $computer = [ADSI]"WinNT://$server" |
matt40k
/ googlepbi.ps1
Created
March 23, 2021 23:03
Simple PowerShell script to use the Google Search API to search for public Power BI reports
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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 |
matt40k
/ Enable_CDC_On_All_Tables.sql
Created
September 25, 2015 10:15
Enable CDC on all tables - Author: Rasmus Reinholdt Nielsen
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <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"/> |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
matt40k
/ mergeCSVFiles.ps1
Created
November 17, 2016 18:58
— forked from conrjac/mergeCSVFiles.ps1
Powershell Script to merge multiple CSV files into one (by appending each file to the end)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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 |
matt40k
/ CloudFlareDNSLookupApi.ps1
Last active
November 23, 2022 10:28
Uses DNS over HTTPS endpoint to lookup A records - PowerShell
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exec sims.db_p_reset_sysman_password |
NewerOlder