MS-SQL Server - Import Export, OEM & CREAM Alerts

Import Export, OEM & CREAM Alerts...

https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard?view=sql-server-ver16

OEM (Original Equipment Manufacturer)

https://social.msdn.microsoft.com/Forums/aspnet/en-US/efbf3cb7-f2a2-44d3-88ac-fc616051411c/sql-server-oem-installation-and-version?forum=sqlgetstarted

C - Critical Events

R - Reporting Services https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-data-alerts?view=sql-server-2016

E - Events and Errors

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver16

A - Agent Alerts

https://learn.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver16

M - MemoryStatus Alert

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/dbcc-memorystatus-monitor-memory-usage?source=recommendations

Additionally,

Degree

https://learn.microsoft.com/en-us/sql/t-sql/functions/degrees-transact-sql?view=sql-server-ver16

Books ONLINE

https://learn.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver16

Detach and Attach

https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-detach-and-attach-sql-server?view=sql-server-ver16

Important Features

- System page latch concurrency enhancements 

- Row-level security

- Transparent Database Encryption (TDE)

- Query Store

- Query Store: on by default for new databases

- Query Store: hint support

- Query Store: read-replica support

Authentication Mode

- Windows

- MIX Mode

Wait Type

- CXPACKET

- OLE DB

- BROKER_TRANSMITTER

- LCK_M_IX_ABORT_BLOCKERS

Event 1073: CS_EVENT_INCONSISTENCY_HALT

https://learn.microsoft.com/en-us/windows-server/failover-clustering/system-events

Best Regards

T. Amit Vaid S.