⭐ FEATURED6 min read
SQL Server 2016 End of Support: What You Need to Do Before July 14, 2026
SQL Server 2016 reaches end of extended support on 14 July 2026. No more security updates, no more patches. Here is exac...
SQL Server Performance Insights
Expert insights, proven techniques, and best practices from industry leaders and real-world experience.
Drawing from the wisdom of Glenn Berry, Brent Ozar, Paul Randal, Kendra Little, Erik Darling, and other SQL Server experts.
Featured Articles
In-depth guides on the most critical SQL Server performance topics
⭐ FEATURED8 min read
What Nobody Tells You Before You Migrate to Microsoft Fabric
I led a complete end-to-end data pipeline migration to Microsoft Fabric in 2025. Seven months, production environment, r...
⭐ FEATURED7 min read
The Hidden Cost of a Slow SQL Server
Your SQL Server might look stable on the surface. But beneath every slow query, every timeout, every frustrated user is ...
Latest Articles
Practical SQL Server optimization guides and tutorials
SQL Server Migration6 min read
SQL Server 2016 End of Support: What You Need to Do Before July 14, 2026
SQL Server 2016 reaches end of extended support on 14 July 2026. No more security updates, no more patches. Here is exactly what you need to do — and ...
Data Platform8 min read
What Nobody Tells You Before You Migrate to Microsoft Fabric
I led a complete end-to-end data pipeline migration to Microsoft Fabric in 2025. Seven months, production environment, real consequences. Here's what ...
Performance Tuning9 min read
SQL Server Index Tuning: The 8 Changes That Deliver Immediate Results
Index problems are responsible for the majority of SQL Server performance issues. These are the eight index changes that consistently deliver the fast...
Performance Tuning10 min read
SQL Server Index Tuning: The 8 Changes That Deliver Immediate Results
Most SQL Server performance problems trace back to indexing. These eight targeted changes address the most common and highest-impact index issues — de...
Case Study6 min read
How a Health Check Saved an NHS Trust 40% in Licensing Costs
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 t...
Case Study8 min read
How a Health Check Saved an NHS Trust 40% in Licensing Costs
When an NHS Trust faced spiralling SQL Server licensing costs and an unmanaged estate, a structured health check uncovered the root cause — and delive...
Performance Tuning7 min read
The Hidden Cost of a Slow SQL Server
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 quietl...
Strategy7 min read
From Reactive to Proactive: Building a SQL Server Strategy
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 t...
Risk & Compliance7 min read
The Hidden Risks of an Unmanaged SQL Estate
An unmanaged SQL Server estate isn't just a performance problem — it's a compliance liability, a security vulnerability, and a business continuity ris...
Browse by Topic
#Automation#Azure#Azure SQL#Backup#Best Practices#Business Impact#Case Study#Cloud#Compliance#Consulting#Cost#Cost Optimisation#Cost Optimization#DBA#Data Platform#Database Health#Deadlocks#Diagnostics#ETL#End of Support#Execution Plans#Fragmentation#Health Check#Indexes#Indexing#Large Databases#Licensing#Locking#Maintenance#Medallion Architecture#Microsoft Fabric#Migration#NHS#Optimization#Parameter Sniffing#Performance#Performance Tuning#Query Optimization#Query Performance#Quick Wins#Risk#Roadmap#SQL Server#SQL Server 2016#SQL Server 2025#Security#Strategy#Troubleshooting#Tuning#Wait Stats
Need Expert SQL Optimization?
Don't just read about it - let our experts optimize your database for guaranteed performance improvements with automated monitoring through aDBA.