Pinned

1. Demos

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

   Jupyter Notebook 13 3

2. Extract an .ISPAC from an SSIS Catal...

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

   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

   1

   Function Get-DisksSpace

   2

   {

   3

       <#

   4

       .SYNOPSIS

   5

           Grabs Hard Drive & Mount Point space information.

5. Create a SQL-on-Linux Docker Contain...

   1

   {

   2

       "metadata": {

   3

           "kernelspec": {

   4

               "name": "powershell",

   5

               "display_name": "PowerShell"

6. Install SQL / Data Developer Desktop...

   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