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)
912 reads
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-24 (first published: 2019-10-15)
437 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)
497 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)
693 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)
604 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
91 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)
204 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
143 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)
352 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)
678 reads
By Angela-Henry
This year I created a new presentation for introducing Azure Data Catalog. I love...
By kleegeek
I am thrilled to have recently recorded a podcast with our friends over at...
By Arun Sirpal
Recently I got to a stage where I leveraged Databricks to the best of...
I need to shrink a data file on the primary replica of an availability...
Hi everyone, Really really need help on this one. You would think that page...
Greetings, I am having issues parsing the following Json string using openjson. I am...
Ask SSC