Quick Blog: Making the Power BI PowerShell cmdlets easier to use

• by Aaron Nelson

• SQLvariant

One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...

2019-09-19

64 reads

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)

133 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

65 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-21 (first published: 2019-05-06)

312 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-10 (first published: 2019-05-01)

590 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-05-09 (first published: 2019-04-30)

1,025 reads

My Ignite 2018 SQL PowerShell Scripts now available in GitHub

• by Aaron Nelson

• SQLvariant

It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...

2019-04-27

30 reads

What Chocolatey Packages Does a Business Intelligence Developer Need?

• by Aaron Nelson

• SQLvariant

I’m getting a new work laptop next week: Hooray!! I’m going to have to install A LOT of software: Opportunity! Problem: I have a lot of meetings next week,...

2019-04-18 (first published: 2019-04-05)

706 reads

Group By Conference is Back April 11th!

• by Aaron Nelson

• SQLvariant

I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going.  We’re aiming to host the conference at least twice this year, and...

2019-04-02

86 reads

Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel

• by Aaron Nelson

• SQLvariant

Have you ever wanted to export an entire SQL Server database to Excel file?  Yeah, me neither.  Until yesterday, when...

2019-03-28 (first published: 2019-03-14)

467 reads