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

# 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

<#  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

SQLvariant

SQLvariant

# > Before you begin, navigate to a local directory containing the Linked Services files from your ADF
c:\temp\ADF\linkedService
# First, run through all of the ADF LinkedService files to extract all the pieces of the connection information we're loking for.
$LinkedServices =  @()
$LinkedServiceFiles = dir -Filter *.json
foreach($LinkedServiceFile in $LinkedServiceFiles){
    $LinkedServiceContents = Get-Content -Path $LinkedServiceFile | ConvertFrom-Json -Depth 20
    switch($LinkedServiceContents.properties.type){
        'AzureSqlDatabase' {$Connection = $LinkedServiceContents.properties.typeProperties.connectionString}
        'AzureSqlDW' {$Connection = $LinkedServiceContents.properties.typeProperties.connectionString}

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 Get-SqlChange
{    <#
    .SYNOPSIS
        This command runs SQLPackage.exe to compare a .DACPAC file to a database and generate a file.

    .DESCRIPTION
        This command runs SQLPackage.exe to compare a .DACPAC file to a database and generate a either a DeployReport or SQL change file.

    .PARAMETER Action
        Specify the action, currently only "DeployReport" and "Script" are supported.

SQLvariant

SQLvariant

#######################
<#
.SYNOPSIS
Creates a DataTable for an object
.DESCRIPTION
Creates a DataTable based on an objects properties.
.INPUTS
Object
    Any object can be piped to Out-DataTable
.OUTPUTS