Aaron Nelson SQLvariant
-
Microsoft Corporation
- Atlanta, GA
- Sign in to view email
- http://SQLvariant.com
View ClonePowerBI_WorkspaceUsers.PS1
<# Clone Users from one Workspace to another | |
Start by specifying the Target Workspace | |
Then use the Out-GridView cmdlet to choose the Source Workspce to copy the users & roles from. | |
https://powerbi.microsoft.com/en-us/blog/announcing-apis-and-powershell-cmdlets-for-power-bi-administrators/ #> | |
$TargetWorkspace = Get-PowerBIWorkspace -Name 'New QA Workspace'; | |
(Get-PowerBIWorkspace | | |
Out-GridView -PassThru | | |
foreach { Get-PowerBIWorkspace -Id $_.Id -Scope Organization }).Users | | |
WHERE { $_.AccessRight -ne 'Viewer' } | |
View Profile.PS1
Import-Module SqlServer; | |
cd C:\temp; | |
<# First we need an argument completer for -ServerInstance #> | |
Register-ArgumentCompleter -ParameterName ServerInstance -ScriptBlock { | |
(dir -Recurse SQLSERVER:\SQLRegistration\'Database Engine Server Group'\ | | |
?{ $_.Mode -ne 'd'} | | |
Group-Object ServerName).Name | ForEach-Object { | |
$CompletionText = $_ | |
New-Object System.Management.Automation.CompletionResult ( | |
$CompletionText, |
View Docker-Creation-Notebook.ipynb

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View TestContainer64.ipynb

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View ExtractISPAC_fromSSISDB.ps1
<# This is the SSIS Project once it's deployed #> | |
$Proj = Get-Item 'SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\Folders\ProviderSolution\Projects\TestSSISProject' | |
$Proj | Get-Member -MemberType Methods | |
<# This is the theory I have #> | |
[byte[]] $ProjBytes = $Proj.GetProjectBytes() | |
[System.IO.File]::WriteAllBytes('C:\temp\ASSISPrj.ispac',$ProjBytes) | |
<# Dont run this piece of code, you will hate me. #> | |
$Proj.GetProjectBytes() |
View DeploySSIS_ISPac.ps1
# Variables | |
$TargetFolderName = "ProviderSolution" | |
$ProjectFilePath = "C:\temp\SSIS\TestSSISSolution\TestSSISProject\bin\Development\TestSSISProject.ispac" | |
$ProjectName = "TestSSISProject" | |
# Get the Integration Services catalog | |
$ProviderCatalog = Get-Item SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\ | |
# Create the target folder | |
New-Object "Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder" ($ProviderCatalog, |
View BuildContainer_FromImage.ps1
<# Step 0) | |
Put the dockerfile & AdventureWorks2016.bak into your c:\temp | |
#> | |
$dockerfileURL = "https://gist.githubusercontent.com/SQLvariant/ebe7fa49216badb6b53339818ca1eda9/raw/ded3e7f988309d311b6f389257e499cb66d5dd39/dockerfile"; | |
$dockerfile = c:\temp\BuildContainer_FromImage.ps1; | |
Invoke-WebRequest -Uri $dockerfileURL -OutFile $dockerfile; | |
Copy-Item -Path "$($Home)\Downloads\AdventureWorks2016.bak" -Destination C:\temp | |
<# First, build the image #> |
View Start-Pomodoro.ps1
<# PLEASE NOTE: I am not the original author of this function. | |
I found it online years ago, and have been using it ever since. | |
If you are the original author, please ping me and let me know, | |
so I can give you proper credit. | |
Based on another function in the PowerShell Gallery, the orginial author might be Nathan.Run() http://nathanhoneycutt.net/blog/a-pomodoro-timer-in-powershell/ | |
#> | |
Function Start-Pomodoro | |
{ | |
Param ( |
View DockerDesktop-with-SQL-PowerShell-2.ps1
<# 0A) Before any of this can work, you must have Docker Destop running. | |
You must also have the latest SqlServer module installed from the PowerShell Gallery.#> | |
Install-Module SqlServer | |
<# 0B) Use this code to download the AdventureWorks2016.bak file from GitHub: #> | |
$BakURL = "https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak"; | |
$BakFile = "$($Home)/Downloads/AdventureWorks2016.bak"; | |
Invoke-WebRequest -Uri $BakURL -OutFile $BakFile; | |
<# 1) Create a SQL-on-Linux Docker Container with just the code below. |
View DockerDesktop-with-SQL-PowerShell-1.ps1
<# 0A) Before any of this can work, you must have Docker Destop running. | |
You must also have the latest SqlServer module installed from the PowerShell Gallery.#> | |
Install-Module SqlServer | |
<# 0B) Use this code to download the AdventureWorks2016.bak file from GitHub: #> | |
$BakURL = "https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak"; | |
$BakFile = "$($Home)/Downloads/AdventureWorks2016.bak"; | |
Invoke-WebRequest -Uri $BakURL -OutFile $BakFile; | |
<# 1) Create a SQL-on-Linux Docker Container with just the code below. |