Try this from cmd window:

NET GROUP MechanicLogUsers /DOMAIN

Does it show the user?

Check this sp sys.sp_xtp_checkpoint_force_garbage_collection - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-xtp-checkpoint-force-garbage-collection-transact-sql?view=sql-server-ver15

I think it is what you are looking for...

In the documentation it is:

Each substitution parameter can be a local variable or any of these data types: tinyint, smallint, int, char, varchar, nchar, nvarchar, binary, or varbinary. No other...

I think the question is not correct and the answer should be "datetime2 doesn't aware of time zone offset".

I have exactly the same problem. Performance is degrading on compatibility levels from 2014 to 2017 but it gets better on 2019. Jeff has provided a good explanation why that...

That's nice but it won't help solve the problem the OP posted.  Also, while OLA's good scripts are the "gold standard" for index maintenance, the supposed "Best Practice" settings...

I use this index maintenance solution - https://ola.hallengren.com/.

I am interested only in data platform exams so I will skip the AZ-900 for now.

I have MCM SQL Server 2008 😉

I am planning to do DP-900 next year and it looks pretty simple to do. And DP-300 after this one. DP-300 is not beta any more!

Luckily I have passed my last SQL Server 2016 exam last week so I have all the credentials for SQL Server 2016! I will start working on Azure certificates next...

Microsoft retiring SQL Server 2014/2016 exams as well:

70-461

70-462

70-463

70-761

70-762

70-764

70-765

70-767

70-768

You can use Query Store feature to get stats when the query plan switches. Also you can force a good plan using the Query Store.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

When you run these commands does it throw any errors or warning?

Hi guys,

That is a known issue. Please patch your SQL Server instance with the latest updates and  Database Mail will start working fine 😉

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server?view=sql-server-ver15