This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - FIX - Agent XPs Component is Turned Off as Part of the Security Configuration for this Server

SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server

June 13, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent, SQL Server Security

New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.

Read More
A garden rain gauge on a post beside a board of pebbles, one red pebble for today

A Performance Counter Baseline Saved to a Table Every 15 Minutes

January 7, 2016
Pinal Dave
SQL Performance
DBA, SQL Counter, SQL DMV, SQL Monitoring, SQL Server Agent

Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.

Read More
A red windsock stretched straight in a strong wind as a dark storm builds over sunny hills

SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825

January 20, 2015
Pinal Dave
SQL Tips and Tricks
Database Corruption, Database Mail, DBA, SQL Error Messages, SQL Server Agent

Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.

Read More
A hand turning a brass tuning pin at the top of a wooden harp with a small key, one red string among the rest.

mssql-conf: Configuring SQL Server on Linux Without a GUI

July 29, 2014
Pinal Dave
SQL Tips and Tricks
Linux, SQL Server, SQL Server Agent, SQL Server Configuration, TraceFlags

Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.

Read More
SQL SERVER - Fix - Agent Starting Error 15281 - SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server

SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server

May 27, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Agent

SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.

Read More
A red-based receipt spike with a few recent slips, a thick bundle of old yellowed slips tied up beside it

Keeping msdb Small With sp_delete_backuphistory

May 21, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Agent, System Database

Use sp_delete_backuphistory to control msdb growth, choose a retention window, and schedule weekly SQL Server Agent cleanup.

Read More
A small one-person tent and a large family tent side by side at a campsite

Azure SQL Database or Managed Instance

February 23, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Migration, SQL Server Agent

Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.

Read More
Previous 1 … 4 5 6 7 8 9 10 … 12 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com