Automating Azure SQL Maintenance with Azure Automation

Keeping Your Azure SQL Databases Healthy: The Power of Automation In the realm of database management, maintaining optimal performance and storage efficiency for your Azure SQL Elastic pool and databases is critical. SQL databases are the backbone of countless business applications, supporting everything from transaction processing to analytics. However, as they grow over time, they … Read more

[PS SCRIPT]: OneDrive Documents Redirection and Status check

How do you ensure each endpoint is properly synced and redirected? What if important data is lost due to a misconfiguration? Run this script from RMM or Intune Proactive Remediations in the user context. Exit 1 and output are generated when issues occur. Do you need help with your Modern Workplace? Check out our service … Read more

[PS SCRIPT]: Detecting Unlinked OneDrive SharePoint Document Libraries on Endpoints

What happens with data that exists only locally on a Device? When users manually create a folder on their device, within the root directory of the SharePoint OneDrive Folder, it exists only locally, it’s un-synced and lacks the cloud functionality and benefits of SharePoint including file versioning and backups. I was unable to prevent users … Read more

Automate Azure SQL Backup with Private Links leveraging PowerShell and Automation Accounts

Azure SQL Services work great, have high availability options, built-in backup functionality, but what if someone breaks into your Azure Tenants and deletes everything!? There are (expensive) SQL backup solutions that use various CPU-intensive techniques to backup databases, but there are Azure native techniques as well by using Az.SQL. The downside is that it’s difficult … Read more