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
Aaron Nelson
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-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
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)
714 reads
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
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
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)
629 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
Blogs
Adding a Check Constraint to a Table–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Azure SQL Database Elasticity – Presentation Notes
By DataOnWheels
This blog covers the content and points to the code used to create the...
How To: Create Schema Only Database Copies
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Forums
Slicing a String in Python
Comments posted to this topic are about the item Slicing a String in Python
SSRS 2016 giving 500 error
Hello! I am getting this intermittent issue when browsing the report, this error goes...
Alwayson Availbility group extended to Azure?..
Hello, Can databases on-Premise Alwayson Availability group of SQL server 2017 failover to Microsoft Azure...
Ask SSC