⭐ FEATURED8 min read
Building a Claude Code Skill That Reads Your Own Systems and Refuses to Invent
Watch the 49-second stage intro it made, then how I built it: a Claude Code skill that gathers evidence from a notes vau...
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
⭐ 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...
⭐ 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...
Latest Articles
Practical SQL Server optimization guides and tutorials
AI and Data8 min read
Building a Claude Code Skill That Reads Your Own Systems and Refuses to Invent
Watch the 49-second stage intro it made, then how I built it: a Claude Code skill that gathers evidence from a notes vault, GitHub and the public web,...
Data Platform6 min read
Agentic RAG in SQL Server: What Vectors, Chat Completion and Foundry Change for DBAs
Agentic RAG in SQL Server puts vectors, REST model calls and chat completion inside the engine. What changes for data movement, governance and DBA dut...
Risk & Compliance6 min read
SQL Server 2022 CU27 Known Issues: What to Check Before You Patch
SQL Server 2022 CU27 and 2025 CU9 landed on 15 September with a corruption fix and three known issues. Here is what to check before you patch anything...
SQL Server Automation7 min
Building a Practical SQL Server Audit Method for Constrained Estates
A practical two-session method for turning inherited, inconsistently managed SQL Server estates into repeatable audit evidence using Copilot Basic, Po...
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...
Browse by Topic
#AI Agents#AI Integration#Automation#Azure#Azure SQL#Backup#Best Practices#Business Impact#Case Study#Claude Code#Cloud#Compliance#Consulting#Copilot#Cost#Cost Optimisation#Cost Optimization#DBA#Data Lineage#Data Platform#Database Health#Deadlocks#Diagnostics#ETL#End of Support#Evidence#Execution Plans#Fragmentation#Health Check#Health Checks#Indexes#Indexing#Known Issues#Large Databases#Licensing#Locking#Maintenance#Medallion Architecture#Microsoft Fabric#Migration#NHS#Optimization#Parameter Sniffing#Patching#Performance#Performance Tuning#PowerShell#Query Optimization#Query Performance#Quick Wins#Risk#Roadmap#SQL Server#SQL Server 2016#SQL Server 2022#SQL Server 2025#Security#Strategy#T-SQL#Troubleshooting#Tuning#Wait Stats#dbatools
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.