Azure

Invoke-DbaDbAzSqlTip

Jess Pomfret (@jpomfret), jesspomfret.com

Invoke-DbaDbAzSqlTip View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Executes Microsoft’s Azure SQL performance recommendations script against Azure SQL Database instances. Description Executes Microsoft’s Azure SQL Tips script against Azure SQL Database instances to identify performance optimization opportunities and design recommendations. This function runs the get-sqldb-tips.sql script developed by the Azure SQL Product Management team, which analyzes your database configuration, query patterns, and resource utilization to provide actionable improvement suggestions.

New-DbaAzAccessToken

Chrissy LeMaire (@cl), netnerds.net

New-DbaAzAccessToken View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Generates OAuth2 access tokens for Azure SQL Database and other Azure services authentication. Description Creates OAuth2 access tokens for connecting to Azure SQL Database and other Azure services without storing passwords in scripts. Supports Managed Identity authentication from Azure VMs, Service Principal authentication for applications, and renewable tokens for long-running connections. The generated tokens can be used directly with Connect-DbaInstance and other dbatools commands to establish secure, modern authentication to Azure resources.