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
11 reads
SQLvariant
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,021 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-05
Get the Governance Data You Need Out of Your Power BI Gateways with PowerShell
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)
454 reads
Get the Governance Data You Need Out of Your Power BI Gateways with PowerShell
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
Download Power BI Audit Logs with the New Get-PowerBIActivityEvent cmdlet
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-PowerBIActivityEvent. The...
2019-09-30
1 reads
Download Power BI Audit Logs with the New Get-PowerBIActivityEvents cmdlet
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)
532 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
97 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
Automate Your SQL Notebooks with Two New Options
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)
715 reads
Blogs
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Top Azure Synapse Analytics and Power BI questions
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Forums
Index scan
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
why cannot use ClientProcessID to trace data in SQL Server Profile.
A C/S system is running on a SQL Server database, and I get its...
Copying an Azure SQL Database with PowerShell
Comments posted to this topic are about the item Copying an Azure SQL Database...
Ask SSC