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.

    .PARAMETER ClusterUrl
        Specify the full URL of the Azure Data Explorer cluster being queried.

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

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

SQLvariant

function Invoke-DB2Query
{
    <#
        .SYNOPSIS
            This function runs a query against a DB2 database.

        .DESCRIPTION
            This function runs a query against a DB2 database using the account of the user executing the command.

        .PARAMETER Server

SQLvariant

SQLvariant

$dbName="SAMPLE"
$server="not.my.localhost"

#Define connection string for the database
$cn = new-object system.data.OleDb.OleDbConnection("server=$($server);Provider=IBMDADB2;DSN=$($dbName);trusted_connection=true;");
#Define data set for first query
$ds = new-object "System.Data.DataSet" "ds"
#Define query to run
$q = "select * from hello_world"
# Define data object given the specific query and connection string

SQLvariant

Describe "Invoke-DaxQuery" {
    Context "Invoke a DAX Query and test the result"{
        # Run queries and compare them
        $results = Invoke-DaxQuery -DAXQuery "EVALUATE ReportCatalogQuery"

        # Test if the config was retrieved
        It "Should verify the count is correct by comparing against a static number" {
            @($results).Count | Should -Be 36
        }
        

SQLvariant

Get-RsDeploymentConfig -RsProjectFile 'C:\Repos\GitHub\ReportingServicesTools\Tests\CatalogItems\testResources\TestProjects\SQLServerPerformanceDashboardReportingSolution\SQL Server Performance Dashboard\SQL Server Performance Dashboard.rptproj' -ConfigurationToUse Release

FullPath               : Release
OverwriteDatasets      : False
OverwriteDataSources   : False
TargetReportFolder     : SQL Server Performance Dashboard
TargetDatasetFolder    : /Datasets
TargetDatasourceFolder : /Data Sources
TargetReportPartFolder : Report Parts
TargetServerURL        : http://localhost/reportserver

SQLvariant

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

SQLvariant

Invoke-ExecuteNotebook -InputNotebook .\DockerDesktop-with-SQL-PowerShell-90.ipynb -Parameters @{sa_password = 'Test9999'}