You don't declare your parameters as datetime2, you declare them as strings.

TableName, ColumnName, DataType etc from information schema are strings not datetime2, so you cannot put the value 'TableABC' into...

To drop the trigger you need to use the "ON DATABASE" or "ON ALL SERVER" depending if its a database or server scoped DDL trigger

USE [master]

GO

DROP TRIGGER...

You can't scale out in standard edition.

The link you refer to has enterprise SQL as they are adding 2 databases to 1 AG which is an Enterprise only feature.

With Standard...

One that bites a few people is ensuring that the power plan is set in performance mode and not balanced, I have seen that affect alot of things over the...

INSERT BULK is from .Net SqlBulkCopy class, so someone has coded an application which is using that class to load in some data

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlbulkcopy?redirectedfrom=MSDN&view=dotnet-plat-ext-3.1

Edition is different, so standard vs enterprise.

please post the output of SELECT @@VERSION, so that can be ruled out.

You talking about the 2TB limit?  Thats for logs in general, so even though there is a limit set at 2TB even those databases which dont have the limit set...

Jobs, logins, linked servers, audits, server triggers anything at the server level which is not done as part of backup restore of the user dbs.

Take a look at dbatools and...

As it's multi subnet DNS will have two or more entries depending how many subnets you span, so it's essentially picking the wrong DNS entry to ping as it will...

Google or your favourite search engine is your friend.

20598 - row not found at subscriber,

0x07.... means if your running SQL7 or above

Nothing that is 100% certain.

You would be best setting up some sort of extended event trace to capture all incoming queries then shredding the sql_text value to find the objects...

You will need to have a process to sync your on-prem ADFS to AAD with something like "Azure AD Connect Sync", then you would create the AAD account using the...

I would check the index usage stats to confirm if its getting any use and if it is scrape the query plan cache for anything which uses that index to...

Because your using string literals to represent a datetime format.

CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112)

The above is taking a string and converting it into a 6 character string.

Datetimes are...

The command is somewhat incomplete, it is missing the correct syntax near move for the log file.

It should be something more like this

USE [master]
RESTORE DATABASE [MyDB]
FROM DISK...