Aaron Nelson SQLvariant
SQLvariant
/ Invoke-DB2Query.ps1
Last active
March 27, 2021 12:13
PowerShell function for running a query against a DB2 database.
This file contains hidden or 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 |
SQLvariant
/ CSharp_Corner.ipynb
Created
January 29, 2021 22:37
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains hidden or 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 |
SQLvariant
/ Invoke-DaxQuery.Test.ps1
Last active
April 19, 2022 07:47
PowerShell function to run a DAX query against a Power BI Repot / Analysis Services, and accompanying Pester test (which requires a separate .PBIX file that I haven't published yet)
This file contains hidden or 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 | |
| } | |
SQLvariant
/ RetrieveObject_Get-RsDeploymentConfig.ps1
Created
October 22, 2020 23:36
This file contains hidden or 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 |
SQLvariant
/ Build_SQLInstance_wStringCreds_andPortNumber.ps1
Last active
January 28, 2023 22:28
Use Invoke-ExecuteNotebook to build a SQL-on-Linux instance in a Docker container, by calling Invoke-ExecuteNotebook to execute the Notebook, and passing in the sa_password & digits for the name/port number to the Notebook as a parameter.
This file contains hidden or 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} |
SQLvariant
/ Build_SQLInstance_wStringCreds.ps1
Created
September 29, 2020 17:06
Use Invoke-ExecuteNotebook to build a SQL-on-Linux instance in a Docker container, by calling a Notebook to execute, and passing in the sa_password to the Notebook as a parameter.
This file contains hidden or 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'} |
SQLvariant
/ DockerDesktop-with-SQL-PowerShell-90.ipynb
Last active
March 27, 2021 12:14
Create a SQL-on-Linux Docker Container with a Host Mount and Restore the AdventureWorks2016 Database
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
SQLvariant
/ Download_Notebook.ps1
Last active
October 15, 2020 12:12
Example PowerShell Notebook to show you examples of what will happen when you use the ConvertTo-SQLNoteBook function.
This file contains hidden or 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
| irm https://gist.githubusercontent.com/SQLvariant/5cbad3dd52093fbd053ec46769a0fc22/raw/1ecf6c292a6c0b9419af01d7360d373a2adff3cd/Using_ConvertTo-SQLNoteBook.ipynb -OutFile Using_ConvertTo-SQLNoteBook.ipynb |
SQLvariant
/ SqlAssessment ChecksSQL.ipynb
Created
August 18, 2020 01:40
PowerShell Notebook for working with the Get-SqlAssessmentItem & Invoke-SqlAssessment cmdlets from the SqlServer module.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.