MS-SQL Server - UJAJWA & Logs

UJAJWA & Logs..

UJAJWA

- User Defined Roles & Functions.
- Junction Table.
- Analysis Services.
- Joins.
- Wait Type Analysis.
- Aggregate Functions.

https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/map-many-to-many-relationships-visual-database-tools?view=sql-server-ver16

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

Logs Type

- Error Logs
- Windows Event Logs
- SQL Agent Logs
- Maintenance Logs
- Backup Logs
- Database Transaction Logs

Additionally,

Please also learn yourself below topics.

1. Equal

2. Severity and Priority

3. Utility Sqlserver.Exe

4. Training

5. PSP (Powershell Points)

6. eBook

It's Preferred to use Native Backup Interface.

Best Regards

T. Amit Vaid S.