I'd save the logs and scripts for the jobs and recheck when the clocks go back. There I'd expect perhaps a double run. Here, going from 1->2 (or 2-> 3)...

There shouldn't be patching issues. You won't have HA, so patching this is the same as other systems. There are people that always install SQL as a single node cluster,...

You can remove the availability groups - https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-an-availability-group-sql-server?view=sql-server-ver15

You can just also remove the other node and let it run single node.

I'm not quite clear what you mean. The ID is 1 for every row? Or do you mean there should be a row for every week of the year, regardless...

Any chance this is malicious activity? No one kicked things off accidentally? Can you post the schedule code for these? Any similarities in them?

That's really strange. I wouldn't expect the time change to reset the time to 2:00, unless the job somehow thought it had missed 2:02 and then ran with the time...

It's safe, but there are two things to note here.

1. you can cause slowdown in the activity for the database, as this is moving things around.
2. you break the recovery...

Should be fixed

There are different paths here, but as Anthony noted, what are you attempting to do?

https://docs.microsoft.com/en-us/learn/certifications/browse/

You can filter by role, so maybe the Developer role and Certification. You can then...

Or just use a testing framework and write a test: https://www.sqlservercentral.com/articles/using-tsqlt-tests-to-practice-queries

Glad you enjoyed it. Coming up with something plausible is a fun challenge each year.

SQL Server on Linux (2005) - https://www.sqlservercentral.com/articles/sql-server-on-linux

I would hope we'd see native Python someday, but...

Glad you enjoyed it. Trying to come up with something to "get" you is always a fun challenge.

You should not have sa being used for SSRS, ETL, etc. It's a recipe for problems, and it's a security risk. Create separate, non-sysadmin, accounts for each access.

If you're struggling...

🙂

OK, this is a blown question. I meant to specify Azure SQL Database and did so in the tag, but not the question. I have altered that to be clear.

In...