MS-SQL Server - Best Working DBA

Best Working DBA

A responsibility is just to understand...

Basic of SQL Server Architecture

High Availability Concept

Group by Clause
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16

Wait Types Analysis
Native Tools
Keys and Contraints
Having Clause
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-having-transact-sql?view=sql-server-ver16

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

Alter Table
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver16

Identity Function
https://learn.microsoft.com/en-us/sql/t-sql/functions/identity-function-transact-sql?view=sql-server-ver16

Naming Standards

https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/lesson-2-create-and-apply-a-naming-standards-policy?view=sql-server-ver16

Additionally,

Is your SQL server Hanging?

When SQL server hangs and become unresponsive we can clear the process ID related to sqlservr.exe by 'End Task' from Task Manager and restart SQL Services.

Best Regards

T. Amit Vaid S.