You need select on that table.

The SQLAgent roles are made to support SSMS SQLAgent usage.

the builtin Query Store will be of great help

A great starting ref can be found here: SQLSkills Blogs Erin

STEP1:

if sys.fn_hadr_is_primary_replica ( dbname ) = 1
begin
     print 'OK'
end
else
begin
RAISERROR('DB dbname is not primary', 16, -1);
end

Set step one to "quit job reporting success" as...

This is indeed a feature that's been requested for some time in SQL Server.

We have created a "jobadmin" SQL account on some servers.

That account owns all user jobs and has...

No need to launch "EXEC msdb.dbo.sp_stop_job @job_name = @name;"  if you just fail the step "fail with success"

Why don't you just perform this check in the first step of the job? ( and "fail reporting success" )

FWIW: I've read on multiple threads regarding "backup database", providing parameters , BUFFERCOUNT = 17 , MAXTRANSFERSIZE = 1048576  have better results regarding performance of the command in...

If the auto-growth cannot respond before its timeout has passed, you'll receive this error message.

The extent will happen eventually.

Please double check.

I fear not .... at this time

did you also read the "For additional details about the Kerberos and MaxTokenSize, see KB327825" link? ( https://learn.microsoft.com/en-US/troubleshoot/windows-server/windows-security/kerberos-authentication-problems-if-user-belongs-to-groups )

Open the deadlock graph using Solarwinds/SQLSentry Planexplorer (free tool) and you can see how locking evolves playing the graph.

We keep a DBA inventory database. function get-ActiveSQLInstances reads the active instances information.

This is where you read your server list.

The sets attributs are:

ServerNaam : servername\inctance
Instance : instance
FQServernaam...

just put it in a "temp" csv file and upload that to sqlserver.

This is how we create such an inventory:

Trap {
    # Handle the...

I would rather like to know the current version of my Azure Managed Instance, which has been on 12.0.2000.8 for the last 5 years.

I can see the date change e.g...

I'm glad you like it 🙂