SQLvariant

Quick Blog: Clone Power BI Workspace Permissions

• by Aaron Nelson

• SQLvariant

However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...

2019-09-04

Quick Blog: Clone Power BI Workspace Permissions

• by Aaron Nelson

• SQLvariant

However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...

2019-09-13 (first published: 2019-09-03)

225 reads

Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets

• by Aaron Nelson

• SQLvariant

Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.

2019-07-30

167 reads

Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets

• by Aaron Nelson

• SQLvariant

Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
The post Make Sure Your SQL Servers...

2019-07-30

Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider

• by Aaron Nelson

• SQLvariant

In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...

2019-05-21 (first published: 2019-05-06)

386 reads

Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider

• by Aaron Nelson

• SQLvariant

In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...

2019-05-06

Deploy SSIS Packages with PowerShell .ISPAC Deployment, using the SSIS Provider

• by Aaron Nelson

• SQLvariant

In today's world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell...

2019-05-10 (first published: 2019-05-01)

706 reads

Deploy SSIS Packages with PowerShell .ISPAC Deployment, using the SSIS Provider

• by Aaron Nelson

• SQLvariant

In today's world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell...

2019-05-01

Execute SSIS Package from PowerShell

• by Aaron Nelson

• SQLvariant

My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container.  I would never have even tried to go down...

2019-05-09 (first published: 2019-04-30)

2,732 reads

Execute SSIS Package from PowerShell

• by Aaron Nelson

• SQLvariant

My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container.  I would never have even tried to go down...

2019-04-30

4 reads