SQLDBAWithABeard

Houston, we have a problem.

You will need to add the link to the 2022 container when it is available to the docker compose file

SQLDBAWithABeard

function Get-MicrosoftTags {
    $AllRepos = (iwr https://mcr.microsoft.com/v2/_catalog).content | ConvertFrom-Json
    # $AllRepos.Repositories | where{ $_ -like '*sql*'}
    if ($IsCoreCLR) {
        $repo = $AllRepos.Repositories | Out-ConsoleGridView -OutputMode Single
    }
    else {
        $repo = $AllRepos.Repositories | Out-GridView -Passthru
    }
    $Url = "https://mcr.microsoft.com/v2/{0}/tags/list" -f $repo

SQLDBAWithABeard

{
    /*
	These are PowerShell snippets which you can use in Visual Studio Code
	To use them click File --> Preferences --> User Snippets and type PowerShell
	or edit $env:\appdata\code\user\snippets\powershell.json
	In general and in order I converted exisitng snippets like this
		Replace `$ with $$
		Replace \ with \\
		Replace " with \"
		\r for new line

SQLDBAWithABeard

    - task: AzurePowerShell@5
      displayName: Deploy Changes
      inputs:
        azureSubscription: ''
        ScriptType: 'InlineScript'
        Inline: |
          # Get the changes for the current build
          $webClient = New-Object Net.WebClient
          $token = "Bearer $env:SYSTEM_ACCESSTOKEN"
          $headers = @{ Authorization = $token }

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{