SSAS cube performance diagnosis starts with the exact slow request. Follow storage, MDX calculations, cache, processing, and resource evidence before choosing a fix.
Too Many Indexes on One Table
Too many indexes on a SQL Server table can slow every write; learn how to identify overlapping indexes, measure their value, and remove them safely.
SQL SERVER – First Month as DBA Trainee – Disasters and Recovery
For T-SQL Tuesday on disaster and recovery, I share the lessons I learned in my first month as a DBA trainee, like never zipping native backups.
Data Quality Checks Worth Running After Every Load
Run data quality checks for missing values, duplicate keys, invalid ranges, and count reconciliation before promoting a loaded batch to production.
Designing a Load That Survives Failing Halfway
Build a restartable load with durable batch identity, transactional progress, repeatable input, and retries that do not duplicate business effects.
SQL Assessment API Findings: From Scan to Action
SQL Assessment API findings can guide a health review, provided the scan’s scope and evidence are clear. I separate collection problems from recommendations before deciding what to change. A short list is useful only when I know what was checked.
SQL Server Health Check: Six Checks to Prioritize
A SQL Server health check becomes useful when its findings lead to a clear, justified next step. I start with recovery and access risks before tuning preferences. A warning deserves investigation, but it does not automatically justify a server change.







