SQLvariant

<# We need an argument completer for -Workspace #>
Register-ArgumentCompleter -ParameterName Workspace -ScriptBlock {
    Get-PowerBIWorkspace | ForEach-Object {
    $CompletionText = $_.Name
    New-Object System.Management.Automation.CompletionResult (
              "(Get-PowerBIWorkspace -Name '$($CompletionText)')",
              $_.Name,
              'ParameterValue',
              "$_ (PowerBIWorkspace)"
                )

SQLvariant

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

SQLvariant

$source_workspace_ID = (Get-PowerBIWorkspace -Name 'QA-Workspace').Id
$report = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $source_workspace_ID
$target_workspace_ID = (Get-PowerBIWorkspace -Name 'Prod-Workspace').Id
$targetReport = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $target_workspace_ID
Copy-PowerBIReport -Report $report -WorkspaceId $source_workspace_ID -TargetWorkspaceId $target_workspace_ID -TargetDatasetId ($targetReport).DatasetId -OutVariable NewReport

<# Now to remove the old version of the report in the Prod workspace #>
#$url = 'https://api.powerbi.com/v1.0/myorg/groups/' + $target_workspace_ID + '/reports/' + $targetReport.Id

#Invoke-PowerBIRestMethod -Method Delete -Url $url

SQLvariant

Import-Module SqlServer;
cd $home\Documents\PoSh\Load\
. .\Get-History2.ps1;
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 = $_

SQLvariant

SQLvariant

SQLvariant

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

SQLvariant

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

SQLvariant

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

SQLvariant

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