Saturday, March 25, 2023

MS-SQL Server - First Well Key Role

First Well Key Role


In SQL Server there are certain roles at Server and Database level respectively.


A DBA should define the role for their users as per actual requirement.


The 'SYSADMIN' is the first well key role for any DBA.


Additionally,


Please also learn about below topics..


- High/Low Wait Types

- Row ID

- LIKE Statement / Query

- Kill SPID Decision Making

- Flow of Query Execution

- Error Logs

- IF Else condition in procedures


Best Regards


T. Amit Vaid S.

No comments: