Tag: dba scripts

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

16 May 2018 · 6 min read

SQL Server 2000 Health Check Script in CVS

Monitor legacy SQL Server 2000 instances with this stored procedure that collects key diagnostic data and outputs it as CSV for automated daily email reporting.

Read article →

15 May 2018 · 5 min read

Find the SQL Server Product Key with the Right Script

Retrieve your SQL Server product key directly from the Windows registry using xp_regread. A reliable method for licence audits, migrations and disaster recovery.

Read article →

15 May 2018 · 8 min read

How to Find SQL Agent Tasks and Schedules

Query SQL Server Agent jobs and schedules directly from msdb using a single T-SQL script. Identify overlapping jobs, disabled tasks and performance issues fast.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.