This file contains 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
$vms.ForEach{ | |
Write-Output "Looking at VM $psitem" | |
# Get the Engine Services | |
$EngineServices = Get-DbaService -ComputerName $psitem -Type Engine | |
# Loop through the engine services | |
$EngineServices.ForEach{ | |
$ComputerName = $psitem.ComputerName | |
$Name = $Psitem.ServiceName | |
$InstanceName = $psitem.InstanceName |
This file contains 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-DbcCheck' | |
Describe "$Function" { | |
Context "Checking $Function Examples" { | |
$Examples = Get-Help $Function -Examples | |
foreach ($examplecode in $Examples.examples.example.Code) { | |
It "Example Code $examplecode should not throw" { | |
{$examplecode} | Should -Not -Throw | |
} |
This file contains 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
<# | |
.SYNOPSIS | |
Downloads the Failover Detection Utility from the Tiger Team GitHub repo | |
https://github.com/Microsoft/tigertoolbox/tree/master/Always-On/FailoverDetection, | |
creates the configuration json and gathers all the required data | |
.DESCRIPTION | |
Downloads the Failover Detection Utility from the tiger teams GitHub Repo, | |
https://github.com/Microsoft/tigertoolbox/tree/master/Always-On/FailoverDetection | |
creates the configuration json dynamically depending on the SQL Instance |
This file contains 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
version: '3.7' | |
services: | |
sql2012: | |
image: dbafromthecold/sqlserver2012dev:sp4 | |
ports: | |
- "15589:1433" | |
environment: | |
SA_PASSWORD: "Password0!" | |
ACCEPT_EULA: "Y" |
This file contains 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
[System.Console]::OutputEncoding = [System.Text.Encoding]::ASCII | |
# borrowing heavily from https://dbatools.io/prompt but formatting the execution time without using the DbaTimeSpanPretty C# type | |
function Prompt { | |
if($PSVersionTable.PSVersion.Major -eq 6){ | |
Write-Host (Get-Date -Format "PS 6 ") -ForegroundColor Yellow -NoNewline | |
} | |
elseif($PSVersionTable.PSVersion.Major -eq 5){ | |
Write-Host (Get-Date -Format "PS 5 ") -ForegroundColor Yellow -NoNewline | |
} | |
elseif($PSVersionTable.PSVersion.Major -eq 7){ |
This file contains 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
# | |
# from https://raw.githubusercontent.com/Microsoft/vsts-tasks/master/Tasks/SqlAzureDacpacDeploymentV1/FindSqlPackagePath.ps1 | |
# | |
function Get-SqlPackageOnTargetMachine | |
{ | |
try | |
{ | |
$sqlDacPath, $sqlVersion = Locate-HighestVersionSqlPackageWithSql | |
$sqlVersionNumber = [decimal] $sqlVersion |
This file contains 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
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 | |
Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1')) | |
choco install chocolatey -y | |
choco install 1password -y | |
choco install azure-data-studio -y | |
choco install azure-functions-core-tools-3 -y | |
choco install azure-cli -y | |
choco install bicep -y | |
choco install chocolatey-core.extension -y |
This file contains 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
# Import the dbatools module | |
Import-Module dbatools | |
# Set the global values | |
$instance = 'localhost,15789' | |
$db = 'WideWorldImporters' | |
$date = (Get-Date).ToString('yyyy-MM-dd') | |
$creatorName = 'Beardy McBeardFace' | |
$cred = Import-Clixml -Path D:\Creds\containersa.xml | |
$TestClass = 'TestExistence' |
This file contains 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
$instance = '' | |
$Databases = '' | |
$CompressedSize = @{Name='Compressed';Exp={[math]::round($_.CompressedBackupSize/1Tb,3)}} | |
$Size = @{Name = 'Size';Exp={[math]::Round($_.TotalSize/1Tb,3)}} | |
## Get the info | |
Get-DbaBackupHistory -SqlInstance $instance -Database $databases -Last -Raw | Select Database, Path, $CompressedSize , $Size | |
#get the total size of files | |
(Get-DbaBackupHistory -SqlInstance $instance -Database $databases -Last -Raw | Select Database, Path, $CompressedSize | Measure-Object Compressed -Sum).Sum |
This file contains 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
######## POSH-GIT | |
# with props to https://bradwilson.io/blog/prompt/powershell | |
# | |
# | |
# Now for this to work most beautifully - you will need to have the latest posh-git module | |
# | |
# You will also need the MesloLGM Nerd Font Mono font | |
# from here https://github.com/ryanoasis/nerd-fonts/blob/master/patched-fonts/Meslo/M/Regular/complete/Meslo%20LG%20M%20Regular%20Nerd%20Font%20Complete.ttf | |
# if you are super nerdy | |
# or |