IIRC the SUCCESSFUL_LOGIN_GROUP action type has an additional information XML field, this contains the XML element <address> which is the IP of where the connection came from, so you would...

+1 for what John said, formatting like that should be done in the application layer.

Let SQL store it and present it as a native SQL datatype, dates should be handled...

Something like the below?

DECLARE @TestTable TABLE (YearID INT, PeriodIDValue VARCHAR(3), PeriodID VARCHAR(10))
INSERT INTO @TestTable VALUES 
(2019,'P12','December'),
(2019,'P5','May'),
(2020,'P1','January')

SELECT *,
--THIS DATE ADD GOES BACK TO THE LAST DAY OF THE...

Yes once initialised by the first full/diff, then any subsequent fulls/diffs are not required, only the rolling log chain.

As for the table not being present, I take it you took...

There are ways and means to sync your local AD domain credentials up to Azure AD and allow a fully bridged authentication route.

If that's something that's not in place, the...

Do you have enough space on one of the AG nodes to restore a copy of the database?  You don't want to break the AG if you can help it...

The option of copy_only on the log backup wont mark the log as re-usable.

So your 20 minute log backup regularly is marking the log as reusable to which your http://ftp...

Your group by is to specific to perform the SUM you need.  Looking at the output you need to do away with START_REG_READ_ID and remove that and the MSR_QTY from...

If it's a vendor database, you may also not...

This is down to logical query processing order.

SQL doesn't process the query from top to bottom, instead it breaks it up and starts with the FROM clause.

The WHERE clause is...

• This reply was modified 5 years, 10 months ago by Ant-Green. Reason: Additional solution

2 ways, store the contents of sys.databases and compare on each iteration any state changes, if the state changes, send an email saying that something has changed.

Use the built in...

You would need to look into the fn_hadr_is_primary_replica function, then based on the output from that either 1 or 0 run what you need to run.

For backing up on the...

Don't believe "servicing update" is going to be the new term.  The URL for that particular KB still references the ability to install the next CU.

My guess is that this...

This sounds like a case for row-level security.

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

Shrinking the log is not always wise to do.

I'd suggest going back to the managing transaction log topics and re-reading through that.

The log has grown to that size for a...