MS-SQL Server - SQL Advanced Threat Protection

SQL Advanced Threat Protection

https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql

Additionally,

This is Azure Managed Service

https://azure.microsoft.com/en-us/products/azure-sql/database

Working with Query Notifications from Native Client

Troubleshoot connectivity to the data processing service and telemetry endpoints

https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/troubleshoot-telemetry-endpoint?view=sql-server-ver16

How to search text with regular expressions

https://learn.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16

CLR_MEMORY_SPY

NT AUTHORITY\SYSTEM

https://learn.microsoft.com/en-us/answers/questions/106173/nt-authoritysystem-account

Differential Backups

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sql-server?view=sql-server-ver16

SOS_SCHEDULER_YIELD

 

To the restore

KB2487231 - "RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2

https://support.microsoft.com/en-us/topic/kb2487231-restore-database-is-terminating-abnormally-error-message-when-you-perform-a-full-backup-of-a-database-in-sql-server-2008-r2-31600a51-1eb9-8200-b338-21db2b939538

Your Database needs maintenance

varchar(25) is good for phone number data type

Your SQL services will be restarted when follow this article.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services?view=sql-server-ver16

Database in suspect mode

https://techcommunity.microsoft.com/t5/sql-server/database-in-suspect-mode/m-p/1479514

Rollback Transactions

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/rollback-transaction-transact-sql?view=sql-server-ver16

Getting this error: Msg 3609, Level 16, State 1, Line 88 The transaction ended in the trigger. The batch has been aborted.

https://learn.microsoft.com/en-us/answers/questions/660133/getting-this-error-msg-3609-level-16-state-1-line

SCAN_CHAR_HASH_ARRAY_INITIALIZATION

Any query will be considered.

T. Amit Vaid S.