SQLDBAWithABeard

# Description: Boxstarter Script
# Author: Jess Frazelle <jess@linux.com>
# Last Updated: 2017-09-11
#
# Install boxstarter:
# 	. { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:

SQLDBAWithABeard

// this is for a raw K8s installation
param name string
param customLocationName string
param tags object

param datacontrollerUserName string

@secure()
param datacontrollerPassword string
@secure()

SQLDBAWithABeard

# Focus Assist Off
Add-Type -AssemblyName System.Windows.Forms
[System.Windows.Forms.SendKeys]::SendWait("(^{ESC})")   
Start-Sleep -Milliseconds 500   
[System.Windows.Forms.SendKeys]::SendWait("(Focus Assist)")   
Start-Sleep -Milliseconds 200   
[System.Windows.Forms.SendKeys]::SendWait("{ENTER}")   
Start-Sleep -Milliseconds 700   
[System.Windows.Forms.SendKeys]::SendWait("{TAB}{TAB} ")  
Start-Sleep -Milliseconds 500     

SQLDBAWithABeard

IF( SERVERPROPERTY('EngineEdition') = 8 )
BEGIN
/*
Description:
Script based on Dimitri Furman's  dbo.sp_readmierrorlog procedure.
dbo.sp_readmierrorlog is a stored procedure that returns the contents of SQL Server and SQL Agent error logs on an MI instance.
The procedure filters out debug-level messages logged for service operation and troubleshooting purposes,
in order to make the error log more readable and actionable for MI users.
The procedure can be customized to add/remove specific filter strings.

SQLDBAWithABeard

#https://twitter.com/guyrleech/status/1322118170002468864
Start-Job -Name "Logoff when done" { sleep (("23:59 30/10/2020" -as [datetime]) - (date)).TotalSeconds ; logoff }

SQLDBAWithABeard

$SQLInstances =  
$webhookurl = ""
$startdate = (Get-Date).AddHours(-1)

Import-Module 'C:\Program Files\WindowsPowerShell\Modules\dbatools\1.0.107\dbatools.psd1'

$AllFailedJobs = foreach ($Instance in $SQLInstances) {
    Write-Host "Connecting to $instance"
    try{

SQLDBAWithABeard

$SQLInstances =
$startdate = (Get-Date).AddHours(-12)
$TeamsWebHook = ""

# Import-Module 'C:\Program Files\WindowsPowerShell\Modules\dbatools\1.0.107\dbatools.psd1'
$AllJobs = "
SqlInstance...|...Total...|...Successful...|...FailedJobs...|...FailedSteps...|...Canceled...     
---------------------------------------------  
"
foreach ($Instance in $SQLInstances) {

SQLDBAWithABeard

# based on https://github.com/guillermo-musumeci/terraform-update-version/blob/master/update-terraform.ps1
# Adding version so we dont get a beta version!
# download the page of Terraform releases
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$WebResponse = Invoke-WebRequest "https://releases.hashicorp.com/terraform"

# Version =

$Version = '0.12.28'

SQLDBAWithABeard

## DO NOT SAVE THE tfvars file with values in it

## I have added them to a local key vault following this blog post https://sqldbawithabeard.com/2020/07/18/good-bye-import-clixml-use-the-secrets-management-module-for-your-labs-and-demos/

# This file will enable you to run terraform plan or import resources into terraform state locally

# You will need to create a directory called ignorevariables and copy the dev-backend-config.tfvars into it

<#
The dev-backend-config.tfvars file should look like this with the required values set for the environment you are using

SQLDBAWithABeard

1..100 | ForEach-Object {
    $number = $Psitem
    switch (($number % 5) -eq 0 -and ($number % 3 -eq 0)) {
        $true { 'FizzBuzz' }
        Default {
            switch ($number % 3) {
                0 { 'Fizz' }
                Default {
                    switch ($number % 5) {
                        0 { 'Buzz' }