UPN Suffix Filtering in Azure AD Connect
Filtering what objects are synced to Azure AD is a common request and there are many instances where filtering by OU just doesn't cut it. One option is to filter users by their UPN suffix so that only users with the public FQDN as their UPN suffix are synced to Azure AD.
Manually Run an Azure AD Connect Synchronization Using PowerShell
Sometimes you need to replicate changes between your on-premise Active Directory and Azure, but don't want to wait for the next scheduled sync. In these cases, the ADSync PowerShell module provides a very easy way to force synchronization.
Query Troubleshooting using SQL Server Profiler
Ever find yourself troubleshooting performance issues with a 3rd party application or wondering why your database server seems to be working way too hard during certain times of the day? SQL Management Studio has a tool that lets you quickly see exactly what queries are running on your DB server in real-time.