GroupBy is Back – Spring 2021 Edition
GroupBy Conference is coming back May 25-26 for it’s Spring 2021 Edition. There will be 20+ FREE data sessions spread across the two days. Sessions for Americas’ time zones...
2021-05-19
79 reads
SQLvariant
Create a Polling Loop in PowerShell
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-04-19 (first published: 2021-02-16)
849 reads
Grant or Revoke Permission on Power BI Report Server
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)
313 reads
Query DB2 From PowerShell
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)
321 reads
Added another 3 new PowerShell functions for reports on Power BI Report Server
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)
375 reads
3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server
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)
445 reads
I’ll be speaking at SQL Server Virtual Conference from C# Corner
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
21 reads
Deploy SSRS Projects with Two New PowerShell Commands
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)
457 reads
Group By 2020 Fall Edition – Call For Speakers
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
16 reads
PowerShell Notebooks are Available in Azure Data Studio
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,067 reads
Blogs
Using Framing for a Running Total–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Accessibility in your PowerPoint slide deck
This post is part of the series I kicked off here. You can read...
Daily Coping 28 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Are Powerplans still relevant for VM servers?
Hello, I am rolling out a new monitoring environment. While in testing, it is...
SELECT records from table 1 that does not exist in table 2 via UNION
Sorry if this seems too beginner; I have been stuck at this for days...
Conditional Update of Column
I can't remember ever trying this before, but I have need to do it...
Ask SSC