Staggerlee011

## Format PowerShell Code in VSCode
SHIFT+ALT+F (or press F1 and type Format and select Format Document).

## InSpec commands by Example
# Create a profile (cookbook)
inspec init profile SQLServerSecurity

# check profile is valid
insec check SQLServerSecurity

# Run single inspec.rb file
inspec exec mytest.rb

# Run a profile

## Markdown-By-Example
# Markdown By Example

> - [Block-Elements](#block-elements)
> Block elements are standard text blocks
>	- [Headers](#headers)
>	- [Links](#links)
>	- [Text](#text)
>	- [Lists](#lists)
>	- [Tables](#tables)
>	- [Quotes](#quotes)

## Choco Software Install
#Requires -RunAsAdministrator

<#

    Workstation Configuration

    Uses chocolately to install a standard set of software used regularly

    view log: C:\ProgramData\chocolatey\logs\chocolatey.log


## pre-commit PowerShell git Hook
write-output "This is a pre-commit powershell call"
write-output "======================================="

Import-Module -Name PSScriptAnalyzer

$changes = git diff --name-only
$output = @()

foreach ($change in $changes)
{

## Finding Registered Event Log Source Names
Get-WmiObject -Class Win32_NTEventLOgFile | Select-Object FileName, Sources

## gist:6633927c3b3a53b246c08ff281461428
## SQL Server Linux
docker run --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pa$$w0rd' -p 1433:1433 -d microsoft/mssql-server-linux

## SQL Server Windows
docker run --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pa$$w0rd' -p 1433:1433 -d microsoft/mssql-server-windows-developer

## Postgres
docker run --name postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgres

## Neo4j (connect via http://localhost:7474 with U/P neo4j/neo4j

## FindAzureimageName.ps1
# Connect-AzureRmAccount

$location = "West Europe"
$publisher = "MicrosoftSQLServer"
$offer = "SQL2014SP2-WS2012R2"
$sku = "Standard"
Get-AzureRmVMImagePublisher -Location $location | where-object {$_.PublisherName.Contains("SQLServer")}
#Get-AzureRmVMImageOffer -Location $location -PublisherName $publisher
#Get-AzureRmVMImageSku -Location $location -PublisherName $publisher -Offer $offer
#Get-AzureRmVMImage -Location $location -PublisherName $publisher -Offer $offer -Skus $sku

## example_download_storage_file
$container_name = 'sqlbackups'
$blob_name = 'mydb-2018-9-19-7-32.bacpac'
$destination_file = 'c:\temp\mybackup.bacpac'
$storage_account = ''
$storage_key = ''

az storage blob download `
        --container-name $container_name `
        --name $blob_name `
        --file $destination_file `

## Azure-DevOps-BuildTemplate-Folder-Example
resources:
  repositories:
    - repository: templates #Name of repo
      type: git
      name: templates

jobs:
- template: terraform/azureterraform.yml@templates # Name of folder (Terraform in the example) and name of file (azureterraform.yml in the example)
	# Create a profile (cookbook)
	inspec init profile SQLServerSecurity

	# check profile is valid
	insec check SQLServerSecurity

	# Run single inspec.rb file
	inspec exec mytest.rb

	# Run a profile
	# Markdown By Example

	> - [Block-Elements](#block-elements)
	> Block elements are standard text blocks
	> - [Headers](#headers)
	> - [Links](#links)
	> - [Text](#text)
	> - [Lists](#lists)
	> - [Tables](#tables)
	> - [Quotes](#quotes)
	#Requires -RunAsAdministrator

	<#

	Workstation Configuration

	Uses chocolately to install a standard set of software used regularly

	view log: C:\ProgramData\chocolatey\logs\chocolatey.log
	write-output "This is a pre-commit powershell call"
	write-output "======================================="

	Import-Module -Name PSScriptAnalyzer

	$changes = git diff --name-only
	$output = @()

	foreach ($change in $changes)
	{
	## SQL Server Linux
	docker run --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pa$$w0rd' -p 1433:1433 -d microsoft/mssql-server-linux

	## SQL Server Windows
	docker run --name sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Pa$$w0rd' -p 1433:1433 -d microsoft/mssql-server-windows-developer

	## Postgres
	docker run --name postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgres

	## Neo4j (connect via http://localhost:7474 with U/P neo4j/neo4j
	# Connect-AzureRmAccount

	$location = "West Europe"
	$publisher = "MicrosoftSQLServer"
	$offer = "SQL2014SP2-WS2012R2"
	$sku = "Standard"
	Get-AzureRmVMImagePublisher -Location $location \| where-object {$_.PublisherName.Contains("SQLServer")}
	#Get-AzureRmVMImageOffer -Location $location -PublisherName $publisher
	#Get-AzureRmVMImageSku -Location $location -PublisherName $publisher -Offer $offer
	#Get-AzureRmVMImage -Location $location -PublisherName $publisher -Offer $offer -Skus $sku
	$container_name = 'sqlbackups'
	$blob_name = 'mydb-2018-9-19-7-32.bacpac'
	$destination_file = 'c:\temp\mybackup.bacpac'
	$storage_account = ''
	$storage_key = ''

	az storage blob download `
	--container-name $container_name `
	--name $blob_name `
	--file $destination_file `
	resources:
	repositories:
	- repository: templates #Name of repo
	type: git
	name: templates

	jobs:
	- template: terraform/azureterraform.yml@templates # Name of folder (Terraform in the example) and name of file (azureterraform.yml in the example)