14 articles about sql server in SQL optimization and database performance.
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.
I led a complete end-to-end data pipeline migration to Microsoft Fabric in 2025. Seven months, production environment, real consequences. Here's what I wish I'd known going in.
Index problems are responsible for the majority of SQL Server performance issues. These are the eight index changes that consistently deliver the fastest, most measurable improvements — with the queries to find them.
Most SQL Server performance problems trace back to indexing. These eight targeted changes address the most common and highest-impact index issues — delivering measurable improvements without application rewrites or hardware upgrades.
A mid-sized NHS Trust was spending heavily on SQL Server licensing for workloads that did not justify the cost. A structured health check identified the gaps — and a prioritised remediation plan delivered 40% cost reduction without disrupting a single clinical system.
Your SQL Server might look stable on the surface. But beneath every slow query, every timeout, every frustrated user is a cost your business is quietly absorbing — and it is almost certainly higher than you think.
Most businesses manage their SQL Server the same way — fix it when it breaks. Here's how to shift from reactive firefighting to a proactive strategy that reduces risk, cuts costs, and gives your business a genuine competitive advantage.
An unmanaged SQL Server estate isn't just a performance problem — it's a compliance liability, a security vulnerability, and a business continuity risk waiting to materialise. Here's what you're actually sitting on.
Hidden performance bottlenecks, over-provisioned hardware, and unchecked query bloat are silently draining your SQL Server budget. Here's how to find the leaks and fix them.
Learn how parameter sniffing affects SQL Server performance, how to detect it, and proven strategies to resolve it - including automated monitoring with modern DBA tools.
Master wait statistics to quickly diagnose SQL Server performance bottlenecks. Learn what the top waits mean and how to resolve them with expert insights from Paul Randal, Glenn Berry, and others.
Learn how index fragmentation impacts performance, when to rebuild vs. reorganize, and how to automate index maintenance using industry-proven solutions.
Master deadlock detection, analysis, and prevention in SQL Server. Learn from expert insights and discover automated solutions that catch deadlocks before they impact users.
Discover the most effective techniques for optimizing SQL Server performance and reducing query response times.