Adding files to tempdb for that wait won’t elevate it.

Pagelatch_up is waiting for memory not disk.

also adding files to tempdb only solves contention on the GAM, SGAM, PFS pages in...

Your looking at writing LDAP queries for that which in this day and age is something I wouldn’t do.

I would advocate for you to use powershell and the get-ad* cmdlets...

Well your having to scan the whole table, so reading 345million rows is not going to be a trivial task, never mind what the data types are and what the...

Use something like a NOT EXISTS clause to filter out anything that has had a subsequent success

Pseudo code

SELECT
job_name
FROM
msdb.dbo.sysjobhistory
WHERE
date >= convert(date,getdate())
AND
date < convert(date,getdate()+1)
AND
status = 'failed'
AND NOT EXISTS
(SELECT
job_name
FROM
msdb.dbo.sysjobhistory
WHERE
date >=...

Nested groups also, as a group can contain a group

So using your data as an example (this may or may not be right you need to go check AD with...

What are you using to security scan?

nessus is giving us these false positives as it thinks the definition is that the build number that Nessus wants isn’t the latest build...

create table #longdelim (ID VARCHAR(50), DelimString VARCHAR(MAX))
insert into #longdelim values ('123','a;b;c;d;e;f;g;h;i;j;k;l;m;n;o;p;q;r;s;t;u;v;w;x;y;z')
select tab.id, spl.item from #longdelim tab
cross apply dbo.delimitedsplit8k(DelimString,';') spl

Thats where you need a tally table and to split an alternative method.

Take a look at delimitedsplit8k (https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function) and work that into the solution, it's a much more efficient delimited...

It will all depend what GPO's are tied to the new OU.  If they are exactly 1 and the same from the current OU then no impact.  If they are...

What is the maximum error count set to on the package?

If its set to 100 but only 99 errors are raised, its below the threshold so will report as a...

Use xp_logininfo and pass in the group name and the members option and it will list the members of the group.

Or if you have the ad powershell modules you can...

Yes possible, a simple google search came up with this from Microsoft

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server?view=sql-server-ver15#:~:text=%20Configure%20replication%20with%20Always%20On%20availability%20groups,Replication%20PublishersA%20secondary%20replica%20cannot%20act...%20More%20

You will need to set your default schema to be dbo on the user mapping screen, your DBA should be able to do this for you.

I would check out things like DBAChecks powershell module which has something like 136 different inbuilt checks to see things like max memory set, tempdb setup correctly, backups taken, duplicate/disabled...

Well it all depends what you want to do.

If you want to do it grant at the whole database level like you have already granted db_datareader etc, then you create...