A director stops by your desk and asks a simple question: which of your two hundred SQL Servers is closest to running out of disk space this...
Knowledge Base
Categories
- Free Tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Why SQL DBAs Are Moving Monitoring to the Browser
Pull up your last five SQL Server incidents and count how many started the same way: a VPN client, a jump box, a Remote Desktop prompt, and a login...
SQL Server Change Data Capture, Explained and Configured
SQL Server Change Data Capture, Explained and Configured SQL Server change data capture (CDC) records the inserts, updates, and deletes made to the...
How AI Optimization Works
You already know the drill. A query shows up in Query Monitor running long, you pull the execution plan, you try an index, you check whether it...
SQL Server Row-Level Security: Setup and Audit Guide
How to Set Up and Audit Row-Level Security in SQL Server SQL Server row-level security (RLS) controls which rows a database user can read or change....
AI and SQL Server Capacity Planning at Scale
Can AI Handle Capacity Planning for a Large SQL Server Environment? Partly. AI can read months of storage growth history across hundreds of SQL...
SQL Server MCP Server: 5 Checks Before an AI Agent Connects
SQL Server MCP: What DBAs Must Verify Before Agents Connect Sooner or later, someone will ask to connect an AI agent to your production SQL Server....
Can AI Replace a SQL Server Monitoring Tool for a DBA Team?
No. AI cannot replace a SQL Server monitoring tool for a DBA team. AI query and index recommendations depend on data that DBAs collect with a...
SQL Server Change Tracking: How It Works and Its Limits
Many DBAs turn on SQL Server Change Tracking expecting to see what changed on a row. The feature records that a row changed and, optionally, which...
Session Monitoring: A Practical Setup Guide
See who is connected, what is running, and what is blocking what; live, instead of reconstructing it from logs afterward. If you use SQL Diagnostic...
SQL Server Index Fragmentation: Detection to Fix
SQL Server index fragmentation is a page-ordering mismatch. The physical order of pages on disk stops matching the logical key order of the index,...
SQL Server Capacity Planning: A DBA’s Guide
Capacity problems in SQL Server rarely arrive without warning. A volume that fills up this month was trending that way for weeks, and the data to...