Tag: sp_configure

SQL Server insights from 25+ years in the field

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

15 May 2018 · 6 min read

How to Resolve an Agent XPs Disabled Error

Seeing an Agent XPs disabled error in SQL Server Management Studio? Learn how to enable Agent XPs using sp_configure and get SQL Server Agent running again.

Read article →
15 May 2018 · 5 min read

How to Enable xp_cmdshell Using sp_configure and Run Batch File from xp_cmdshell

Enable xp_cmdshell in SQL Server using sp_configure in four T-SQL statements, plus the security controls you need before you run a single line of code.

Read article →

SQL Server insights, monthly.

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