Monthly SQL DBA support
Ongoing help with backups, failed jobs, monitoring, performance problems, recovery checks, and planned changes.
SQL Server / guides and references
SQL Server guides
These SQL Server guides help you troubleshoot production problems, plan changes, and handle routine DBA work. They also include checklists, scripts, and Microsoft-sourced references for versions, updates, errors, and vulnerabilities.
Search SQL Server pages
Find guides, checklists, scripts, update references, error-code pages, and practical DBA articles.
Guide lookup
sql
SQL Server guides
Find practical pages for troubleshooting SQL Server problems, planning changes, checking routine DBA work, and looking up Microsoft version or security information. Filter the list by page type or topic.
Type
Topic
Latest
GuideOperationsRead
SQL Server tempdb guide
Tempdb setup, growth behavior, version-store pressure, and the workload clues that usually sit behind tempdb pain.
13 Aug 2026GuideRecoveryReadSQL Server backup RPO and RTO calculator
Interactive restore-time, recovery-point, throughput, and backup-retention estimate based on measured backup and restore data.
13 Aug 2026All pages
GuideOperationsRead
SQL Server sizing guide
Workload profiling, hardware fit, capacity pressure, and the platform questions that sit behind recurring SQL stress.
13 Aug 2026GuidePlanned changeReadSQL Server upgrade path and version checker
Interactive SQL Server 2012 to 2025 path, service-pack, edition, architecture, and Windows Server checks with direct, multi-hop, and migration routes.
13 Aug 2026ScriptOperationsReadSQL Server DBA scripts
Administration scripts grouped by DBA task, with permissions, expected load, test records, and versioned downloads.
23 Jul 2026ChecklistOperationsReadSQL Server weekly review checklist
Review repeat incidents, configuration drift, capacity trends, unfinished work, and next week's tasks.
15 Jul 2026GuideRecoveryReadSQL Server FCI and Always On AG licensing
When a passive FCI node or Always On Availability Group secondary is covered by failover rights and when it needs licensing.
12 Jul 2026ChecklistPlanned changeReadSQL Server upgrade checklist
Check support status, compatibility, the test run, rollback, and the work after the upgrade.
12 Jul 2026GuideRecoveryReadBest SQL Server backup tools
Ten SQL Server backup tools compared for free scripts, small setups, SMBs, enterprise recovery, cloud backup, encryption, and restore testing.
9 Jul 2026GuideOperationsReadBest SQL Server monitoring tools
Ten SQL Server monitoring tools compared for DBA alerts, query performance, backups, jobs, Azure SQL, APM, and lower-cost setups.
5 Jul 2026GuidePlanned changeReadBest SSMS alternatives
Ten SQL Server Management Studio alternatives compared by free and paid options, Windows, macOS, Linux, and daily SQL Server work.
5 Jul 2026GuidePerformanceFirst readReadDeadlock on SQL Server guide
Deadlock XML, error 1205, victim choice, transaction overlap, and how deadlocks differ from live blocking chains.
4 Jul 2026GuideOperationsFirst readReadSQL Server monitoring guide
Monitoring best practices for alerts, SQL Agent jobs, backups, waits, baselines, and low-cost setups that still need a response path.
4 Jul 2026GuideOperationsReadIs it cheaper to outsource SQL Server DBA work?
How to compare full-time SQL Server DBA staffing against outsourced or fractional DBA support when salary, hiring, tools, coverage, and operational costs all count.
4 Jul 2026GuideOperationsReadSQL Server health check guide
Instance review, health-check scope, configuration, backups, jobs, restore testing, monitoring, and the checklist behind a proper SQL review.
4 Jul 2026TopicPerformanceReadSQL Server slow performance
Use this when SQL Server is slow and you need to separate waits, blockers, plans, slow queries, jobs, tempdb, and resource pressure.
4 Jul 2026GuidePlanned changeReadSQL Server vs Azure SQL for small business
How to choose between on-premises SQL Server, Azure SQL Database, Managed Instance, and SQL Server on Azure VM when cost, compatibility, backups, and support all matter.
4 Jul 2026GuidePerformanceReadSQL Server waits guide
SQL Server wait stats analysis for cumulative waits, active waits, session waits, blocking context, query plans, jobs, and workload timing.
4 Jul 2026GuideOperationsReadWhat kind of ongoing SQL Server support do small companies need?
What small companies need for SQL Server backups, jobs, alerts, restore tests, patching, access, performance checks, ownership, and escalation.
4 Jul 2026GuideOperationsReadSQL Server Configuration Manager guide
How to open SQL Server Configuration Manager, choose the right MSC file, manage services, enable TCP/IP, and avoid common service-account or port mistakes.
12 Jun 2026GuidePlanned changeReadSSMS 22.7.0 feature guide
What changed in SSMS 22.7.0, including SQL formatting, schema compare, Copilot Agent Mode, Database DevOps updates, and update guidance.
12 Jun 2026GuideRecoveryReadSQL Server Always On setup prerequisites
Availability Group and FCI prerequisite planning for nodes, edition limits, NICs, FQDNs, IPs, DNS, witness, storage, ports, and listeners.
2 Jun 2026GuidePerformanceReadSQL Server joins guide
Join types, ON clauses, APPLY, duplicate-row traps, and the query-shape issues behind slow or wrong SQL Server reports.
2 Jun 2026ChecklistOperationsFirst readReadSQL Server health check checklist
Check ownership, backups, maintenance, monitoring, configuration drift, and the work that needs attention first.
30 May 2026GuideOperationsReadSQL Server ownership gap guide
How weak SQL Server ownership creates drift, and what a minimum workable model looks like.
24 May 2026GuidePlanned changeFirst readReadSQL Server update guide
CU vs GDR, build-number interpretation, and how to separate a patch decision from a real upgrade decision.
23 May 2026GuideOperationsReadSQL Server maintenance plan guide
What good SQL Server maintenance actually covers, what default maintenance plans miss, and how older environments drift into false comfort.
23 May 2026GuideOperationsReadSQL Server production readiness guide
How to judge whether a SQL Server environment is truly ready for production pressure, change, and recovery instead of merely quiet for now.
23 May 2026GuideOperationsReadSQL Server stability review guide
How to review recurring instability in a SQL Server environment, separate repeated patterns from noise, and decide what to fix first.
23 May 2026ReferenceReferenceFirst readReadSQL Server vulnerabilities
SQL Server CVEs, MSRC revisions, affected builds, known exploitation, and explicit matches from security research sources.
21 May 2026GuidePlanned changeReadPower BI Report Server versions
Latest PBIRS versions and build numbers, matching Desktop RS releases, older Microsoft downloads, and system requirements.
2 May 2026ReferenceReferenceReadSQL Server error codes
Single-page Microsoft-sourced Database Engine error lookup with severity, event logging, messages, and official source links.
22 Apr 2026ReferenceReferenceReadSQL Server latest updates
Live SQL Server supported-build and version-history reference built from Microsoft's update source.
21 Apr 2026ReferenceReferenceReadSSMS downloads
Latest SSMS downloads, fixed installers, release dates, build numbers, and Microsoft-sourced release history.
20 Apr 2026GuideRecoveryFirst readReadSQL Server backup guide
Backup strategy, retention, restore testing, and the gaps that only show up when recovery work becomes real.
19 Apr 2026GuideRecoveryFirst readReadSQL Server recovery guide
Restore readiness, recovery timing, dependency traps, and the runbook discipline that shortens incidents.
19 Apr 2026GuidePlanned changeFirst readReadSQL Server upgrade guide
Upgrade path, compatibility levels, dependencies, rollback testing, Query Store, and post-change validation.
19 Apr 2026GuideOperationsReadSQL Server environment assessment guide
How to assess versions, databases, backups, jobs, alerts, access, linked servers, dependencies, and HA/DR before cleanup or change work.
19 Apr 2026GuideRecoveryReadSQL Server failover guide
Failover testing, HA tradeoffs, and the operational load that still exists after redundancy is in place.
19 Apr 2026GuideOperationsReadSQL Server hardening guide
Permissions, exposure, patch posture, service accounts, and the security basics that should be checked without making production brittle.
19 Apr 2026GuidePerformanceReadSQL Server indexing guide
Access-path review, write tradeoffs, and workload-based indexing decisions instead of tuning folklore.
19 Apr 2026GuidePlanned changeReadSQL Server migration guide
Inventory, dependency mapping, test runs, rollback design, and cutover planning for real production moves.
19 Apr 2026ReferenceReferenceReadSSRS versions
SQL Server Reporting Services version history with SSRS versions, product versions, release dates, and Microsoft-sourced notes.
19 Apr 2026ChecklistOperationsReadSQL Server daily operations checklist
Review jobs, backups, alerts, capacity changes, handoff notes, and problems that keep coming back.
19 Apr 2026ChecklistPlanned changeReadSQL Server migration checklist
Prepare the scope, dependencies, test run, cutover, rollback, and checks after the move.
19 Apr 2026ChecklistRecoveryReadSQL Server recovery runbook checklist
Record the restore sequence, recovery time, dependencies, validation steps, and who owns each action.
19 Apr 2026GuidePerformanceFirst readReadSQL Server blocking guide
Blocking chains, head blockers, live lock waits, and how SQL Server blocking differs from deadlocks.
15 Apr 2026SQL Server services
I help with SQL Server performance, backups and recovery, patching, upgrades, and day-to-day DBA work. This can be ongoing monthly support or focused consulting for a specific problem or planned change.
SQL Server consulting
Focused help when performance, recovery, patching, supportability, or the overall setup needs a closer look.
Performance issues
For slow periods, blocking, waits, and workload behavior that still needs a clear diagnosis.
Backup or restore issues
For backups, restore tests, recovery timing, and runbooks that have not been properly tested.
Patching or upgrade planning
For version changes, compatibility checks, rollback planning, and patching risk that needs a safer plan.
Full environment review
For older or handed-over SQL Server setups where backups, jobs, monitoring, and ownership need checking.
SQL Server support
Need help with a SQL Server problem?
Choose monthly DBA support for ongoing work, or SQL Server consulting for a specific problem or planned change.