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)
551 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)
382 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)
348 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
72 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)
588 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)
540 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)
157 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
106 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)
327 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)
602 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA...
Every once in a while there is an extremely valuable tool that comes along....
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...
Comments posted to this topic are about the item Verify your SQL Server database...
Hi all, I´m not sure what I´m doing bad with this query: Situation: I...
HI Guys, can I use Stretch database to migrate the database to azure.?...
Ask SSC