OK, before anyone yells at me: Yes, I know the On-Premises Data Gateways are now part of Power Platform, not just Power BI. I learned how to do everything...
2019-10-15
10 reads
Earlier this week a new version of the MicrosoftPowerBIMgmt module was made available on the PowerShell Gallery. Two new cmdlets were included in the module Remove-PowerBIReport and Get-PowerBIActivityEvents. The...
2019-10-07 (first published: 2019-09-30)
296 reads
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-10-02 (first published: 2019-09-23)
531 reads
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-27 (first published: 2019-09-19)
518 reads
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
65 reads
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)
142 reads
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
72 reads
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)
317 reads
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)
596 reads
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,191 reads
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
By damianwidera
This is the eight interview we have done. This time our guest is the...
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Need help to rewrite the query for faster result. use ABC_DB; SELECT c.otherID, a.shortname,...
Need help to rewrite the query for faster performance. use ABC_DB; SELECT c.otherID, a.shortname,...
In SQL Server 2016 SP2, we had a transaction log that had a truncation...
Ask SSC