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
85 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)
872 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)
319 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)
332 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)
382 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)
458 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
24 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)
492 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,072 reads
Blogs
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
You don’t need a blockchain
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
Daily Coping 27 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
How to get feature key and feature value separated $ based on part id ?
I work on sql server 2012 i need to get featurekey and feature value...
Setting Up SQL Server 2019 for Optimal Performance
Hi I have a very large database (600GB) that I am looking at creating. ...
Ask SSC