Monday, June 12, 2023

MS-SQL Server - Goodness of Gunya

Goodness of Gunya


The word Gunya is derived from Hindi word गुण, which is nothing but one's capability of completing a task.


Now in brief, a DBA should have a capability of some of the key things that makes a perfect DBA.


G - Go for Execute any query should have self confidence earned prior to execute an optimised query.

U - Urgent task should be attended on priority by segregating them in the system.

N - Native tools should be utilised properly.

Y - Your configurations and permissions should have an audit periodically.

A - Getting Assistance from colleagues is free of cost.


Additionally,


Cure is better than putting things on hold.


Any query will be considered.


T. Amit Vaid S.

1 comment:

Anonymous said...

Topics
Profiler Trace, keys or keys and constraints
Master DB Link with Distribution DB
Standard/Basic Edition, Enterprise Edition
Backup History from msdb
Aggregate Functions
CXPACKET, CXCONSUMER
Roles &
Case When
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver16