Pinned Loading

1. Demos Demos Public

   Collection of demo scripts from presentations, articles, and even tweets

   Jupyter Notebook 38 14

2. Extract an .ISPAC from an SSIS Catal... Extract an .ISPAC from an SSIS Catalog and write to disk via SSIS PowerShell Provider

   1

   <# This is the SSIS Project once it's deployed #>

   2

   $Proj = Get-Item 'SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\Folders\ProviderSolution\Projects\TestSSISProject'

   3

   $Proj | Get-Member -MemberType Methods

   4

   5

   <# This is the theory I have #>

3. Promote a Power BI Report from a QA ... Promote a Power BI Report from a QA Workspace to a Prod Workspace, while preserving the connection to the Prod database when the updated report lands in the Prod Workspace.

   1

   $source_workspace_ID = (Get-PowerBIWorkspace -Name 'QA-Workspace').Id

   2

   $report = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $source_workspace_ID

   3

   $target_workspace_ID = (Get-PowerBIWorkspace -Name 'Prod-Workspace').Id

   4

   $targetReport = Get-PowerBIReport -Name 'Regional Sales' -WorkspaceId $target_workspace_ID

   5

   Copy-PowerBIReport -Report $report -WorkspaceId $source_workspace_ID -TargetWorkspaceId $target_workspace_ID -TargetDatasetId ($targetReport).DatasetId -OutVariable NewReport

4. Get-DisksSpace.PS1 Get-DisksSpace.PS1

   1

   Function Get-DisksSpace

   2

   {

   3

       <#

   4

       .SYNOPSIS

   5

           Grabs Hard Drive & Mount Point space information.

5. Create a SQL-on-Linux Docker Contain... Create a SQL-on-Linux Docker Container with a Host Mount and Restore the AdventureWorks2016 Database

   1

   {

   2

       "metadata": {

   3

           "kernelspec": {

   4

               "name": "powershell",

   5

               "display_name": "PowerShell"

6. Install SQL / Data Developer Desktop... Install SQL / Data Developer Desktop Tools from Chocolatey

   1

   Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

   2

   3

   choco install chocolatey -y

   4

   choco install sql-server-management-studio -y

   5

   choco install azure-data-studio -y