Comprehensive Database Performance Health Check. Recently I had a very interesting experience where SQL SERVER Agent was Missing from SSMS.
SQL SERVER – Query to List All Jobs with Owners
During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
SQL SERVER – Enable Additional Logging for SQL Server Agent
When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs.
SQL SERVER – SQL Server Agent Missing in SQL Server Configuration Manager
In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.
SQL SERVER – Event ID 7000 – The System Cannot Find the File Specified
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.
SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle
Recently I was asked by the customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.