Use PowerShell to remediate Non-Compliant Policy Definitions

Introduction
Azure Policy enables an organization to enforce standards and assess compliance against regulatory requirements. In general, there are four main Azure Policy objects.

A Policy Definition describes the conditions under which it is enforced… Continue reading Use PowerShell to remediate Non-Compliant Policy Definitions

Lesson Learned #416: Unveiling User Activity Insights in Azure SQL Databases

Today, I got an interested service request where our customer needs to know the user activity for a very dense elastic database pool. During the troubleshooting I wrote, as an example, this Powershell script that tracks useful information about connect… Continue reading Lesson Learned #416: Unveiling User Activity Insights in Azure SQL Databases

Enhancements to Microsoft Purview policies for Arc-enabled SQL Server

A recent change in Microsoft Purview extends and makes it easier to create data policies for Azure Arc-enabled SQL Servers. With this change:

Policies on Linux Arc-SQL are now supported. Prior to this, only policies on Windows Arc-SQL were supported.
Continue reading Enhancements to Microsoft Purview policies for Arc-enabled SQL Server

Goal Broadcasts for Leaders: Communicating Goals to Your Team Just Got Easier

If you manage an organization or team, you may have wondered…
 

 How do I give regular updates to my team on goal progress and context on the “why”—without adding even more work to my plate tracking down data points, gathering information … Continue reading Goal Broadcasts for Leaders: Communicating Goals to Your Team Just Got Easier