Have you copied the sql based logins to all replicas and ensured they have the same SID etc using something like sp_help_revlogin or DBATools powershell module?

Can you post the fill...

Then you would want to do some PowerShell magic and automate it.

Use Get-AdGroupMember and pull the information down from the 3 groups.

Use a filter to get who is in Devs,...

Well then you need a 3rd security group

Devs - Cleared or not

Cleared - Users who are cleared

DevsCleared - Devs who are cleared

You will then need something in your JML(joiners movers...

Please explain clearly what is not working

ALTER ROLE [DEVS] ADD MEMBER [DOMAIN\SQLDevs]

ALTER ROLE [CLEARED] ADD MEMBER [DOMAIN\SecurityCleared]

ALTER ROLE [DEVS_CLEARED] ADD MEMBER [DOMAIN\SQLDevs]

ALTER ROLE [DEVS_CLEARED] ADD MEMBER [DOMAIN\SecurityCleared]

GRANT [permission (SELECT/INSERT/UPDATE/DELETE/VIEW/ALTER etc)]...

Probably need a bit more information like where the outputs are stored, but you could look at multi server jobs or things like powershell and the dbatools module and get...

DNS is the attributing factor here, you need to ask your domain/network admins what the sync time is for your environment.

So take that time, plus up to around 40 minutes...

I missed a bracket which I have updated

also just don’t copy and paste from the internet try and work out what has gone wrong and feed in the solution and...

Sounds like a case for row number and = 2

;with cte as (

Select row_number() over (partition by id order by datetime desc) as rownum,

id, datetime, checkpoint

from rawdata )

select * from...

TempDB is a critical resource without it the system cannot operate, as such any failure in TempDB will cause a service stop and thus a failover.

Are you comfortable with all the different pieces in Azure like network security groups, vnets, subnetting, allowing access to backend Microsoft services etc?

If you are great, you can skip AZ-900

If...

You need to manually install pester, it is in the documentation for this to be done as it was removed from Auto-Install due to incompatabilities with Pester 5

As such please...

If your using physical tin servers then you would want everything as close to the server as possible, local disk would be better if its the right type of local...

I would highly recommend...

I would highly recommend before doing any Azure certification to do AZ-900 before any others.

This is the Azure Fundamentals course/exam and touches on the basics of most of the Azure...

You will need to disable register all IP addresses at the cluster level, this will then only register the primary IP that is in use (note you may have to...