SQLvariant

<# Make sure you have the modules installed.
     You only need the ImportExcel module if you want to export the results to Excel files. #>
Install-Module DataGateway
Install-Module ImportExcel

<# Discovery #>
# All Gateway Clusters in your tenant.
Get-DataGatewayCluster -Scope Organization

# All nodes of all Gateway Clusters in your tenant.

SQLvariant

Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

choco install chocolatey -y
choco install sql-server-management-studio -y
choco install azure-data-studio -y
choco install azuredatastudio-powershell -y
choco install git.install -y
choco install vscode -y
choco install vscode-powershell -y
choco install powerbi -y

SQLvariant

function Invoke-KqlQuery
{    <#
    .SYNOPSIS
        This command runs a KQL Query against an Azure Data Explorer cluster.

    .DESCRIPTION
        This command runs a KQL Query against an Azure Data Explorer cluster using the Azure AD User 
        Authentication method, unless an access token is passed in with the -AccessToken parameter.

    .PARAMETER ClusterUrl

SQLvariant

function Test-Example {
    <#
    .SYNOPSIS
        A function to test the Examples inside the Help of a PowerShell command.
    .DESCRIPTION
        A function to test the Examples inside the Help of a PowerShell command to see if they can be successfully executed or not.
    .NOTES
        Currently, this command only supports testing one example at a time.
    .LINK
        https://gist.github.com/SQLvariant/683b6b16212c7e665d1bffb7fbed98c4

SQLvariant

Invoke-ExecuteNotebook -InputNotebook .\SQL-on-Docker-with-PowerShell.ipynb -Parameters @{sa_password = 'Test9999'; SQLNumber = 97}

SQLvariant

using System;
using System.Collections.Generic;
using System.Management.Automation.Language;

public class ScriptExtent : IScriptExtent
{
    private readonly IScriptPosition _start;

    private readonly IScriptPosition _end;

SQLvariant

# Go to wherever the pipelines are.
$DownloadLocation = 'C:\temp\ADF\pipeline'
cd $DownloadLocation

# Just have a quick look.
$PipelinesContents = @()
foreach($PipelineFile in dir $DownloadLocation){
    $PipelineContents = Get-Content -Path $PipelineFile | ConvertFrom-Json -Depth 20
    $PipelinesContents += $PipelineContents
    $PipelineFile = $null

SQLvariant

SQLvariant

<#  Search for something inside an ADF file and replace it. #>
$Datasets = dir 'C:\temp\MDD-ADF-Test-Repo\dataset' -Recurse
foreach($Dataset in $Datasets.Where({$_.Mode -ne 'd----'})){
    $Dataset.Name

    if((Get-Content $Dataset.FullName | foreach{ $_ -match 'AzureSqlDatabase1' }) -eq $true ){"Fix it"
        (Get-Content $Dataset.FullName).Replace('Azure_SqlDatabase1', 'MDD_SampleSQL_LS') | Set-Content -Path $Dataset.FullName }
    else{"Nothing to do"}
}

SQLvariant