#Automation

2 articles about automation in SQL optimization and database performance.

SQL Server Automation7 min

How I Built an AI-Driven SQL Server Audit Solution with Just Copilot and PowerShell

A two-session workflow for building automated SQL Server health audits using Copilot Basic, Glenn Berry's diagnostic scripts, and dbatools — no Pro subscription required.

SQL Server PowerShell dbatools

June 27, 2026Read More →

Index Optimization10 min read

Index Fragmentation in SQL Server: Detection, Impact, and Automated Management

Learn how index fragmentation impacts performance, when to rebuild vs. reorganize, and how to automate index maintenance using industry-proven solutions.

SQL Server Indexes Fragmentation

October 12, 2024Read More →