SQLvariant

Create a Polling Loop in PowerShell

• by Aaron Nelson

• SQLvariant

This is one way to create a polling loop in PowerShell. I’m sure there are several options, but this one works well for the use case. Backstory I needed...

2021-02-16

364 reads

Grant or Revoke Permission on Power BI Report Server

• by Aaron Nelson

• SQLvariant

I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last...

2021-02-22 (first published: 2021-02-10)

301 reads

Query DB2 From PowerShell

• by Aaron Nelson

• SQLvariant

Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they...

2021-02-17 (first published: 2021-02-09)

289 reads

Added another 3 new PowerShell functions for reports on Power BI Report Server

• by Aaron Nelson

• SQLvariant

I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve...

2021-02-11 (first published: 2021-02-03)

362 reads

3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server

• by Aaron Nelson

• SQLvariant

I just wanted to give everyone a heads-up that a new version of the ReportingServicesTools module went out last week, and it includes 3 new PowerShell functions for working...

2021-02-08 (first published: 2021-01-28)

384 reads

I’ll be speaking at SQL Server Virtual Conference from C# Corner

• by Aaron Nelson

• SQLvariant

I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan 29, 2021, with my friend Julie Koesmarno ( b | t ). I’ll be showing...

2021-01-27

17 reads

Deploy SSRS Projects with Two New PowerShell Commands

• by Aaron Nelson

• SQLvariant

I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...

2020-11-16 (first published: 2020-11-11)

442 reads

Group By 2020 Fall Edition – Call For Speakers

• by Aaron Nelson

• SQLvariant

The Call for Speakers for the 2020 Fall edition of GroupBy is open, but it closes in just 3 days! We’re currently using Sessionize to help us organize this...

2020-09-02

14 reads

PowerShell Notebooks are Available in Azure Data Studio

• by Aaron Nelson

• SQLvariant

PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...

2019-11-12 (first published: 2019-11-05)

1,054 reads

PowerShell Notebooks are Available in Azure Data Studio

• by Aaron Nelson

• SQLvariant

PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...

2019-11-05

1 reads