View Invoke-KqlQuery.ps1
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 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. |
View Get-SqlChange.ps1
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-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. |
View Out-DataTable.ps1
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 | |
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 |
View Invoke-DB2Query.ps1
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 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 |
View CSharp_Corner.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Query_DB2.ps1
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
$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 |
View Invoke-DaxQuery.Test.ps1
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
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 | |
} | |
View RetrieveObject_Get-RsDeploymentConfig.ps1
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
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 |
View Build_SQLInstance_wStringCreds_andPortNumber.ps1
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
Invoke-ExecuteNotebook -InputNotebook .\SQL-on-Docker-with-PowerShell.ipynb -Parameters @{sa_password = 'Test9999'; SQLNumber = 97} |
View Build_SQLInstance_wStringCreds.ps1
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
Invoke-ExecuteNotebook -InputNotebook .\DockerDesktop-with-SQL-PowerShell-90.ipynb -Parameters @{sa_password = 'Test9999'} |
NewerOlder