Do you mean DT_BYTES (byte array), or byte type (single-byte equivalent of a tinyint)?

Eight bytes definitely won't fit in a one-byte type (Byte).

Do a select using CAST(rowversion AS BIGINT)...

https://github.com/GuerrillaAnalytics/similarity is an updated version of the SimMetrics CLR assembly I've used for years.

You got feedback (and a little sass) from some very experienced and talented database experts who have a lot of wisdom to impart. But occasionally the experts vent a little...

AT TIME ZONE returns datetimeoffset. Take off the cast and it will show you that it is treating it as UTC.

"When inputdate is provided without offset information, the function applies...

You need two other "tables":

• A Calendar table, as you've suggested, or the equivalent generated set of dates (e.g., using a Tally function and DATEADD). Search should provide plenty of...

It doesn't just happen -- Somebody (e.g., editing table in SSMS or applying changes via a compare tool) or some process (e.g., SQL Agent job) is doing it.

You can track...

Check the auto-close property on the relevant databases -- it defaults to on with SQL Server Express.

SELECT name,is_auto_close_on FROM sys.databases 
WHERE is_auto_close_on = 1 AND name =...

The 4000 series Ryzen CPUs seem to be great value in terms of performance/power.  H-series are competitive with desktop chips for performance. U-series have more moderate performance, and are geared...

So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been from...

You have a nested array.

SELECT JSON_VALUE(@JsonValue, '$.CoordSets[0][0].Lat');--returns 51.9642514

Are the double square brackets intentional?

With SQL Server 2019, you can enable trace flag 460 to get detailed messages that identify the column and even offending value.

https://techcommunity.microsoft.com/t5/sql-server/string-or-binary-data-would-be-truncated-replacing-the-infamous/ba-p/386014

https://www.brentozar.com/archive/2019/03/how-to-fix-the-error-string-or-binary-data-would-be-truncated/

More or less, eventually, depending on whether you're looking at raw or compressed data size... And assuming your client doesn't time out or crash from an out-of-memory condition.

Once client-side, the...

Thanks to TSQL's support of updates with from clauses, I frequently write new or ad-hoc updates in this format (at least in development) to make testing easy:

update...

Sequence?

No.

How were DDColumnObject and DDErrorLog modified?  via SSMS GUI? Or with TSQL alter table statements?

If you used the GUI, it may have re-created the tables rather than simply altering.