SQL knowledge to windows administrator

Question

Hello Everyone,

As a windows administrator. What type of knowledge windows guys should on SQL. Please share the topics.

Answer 1

Hi,

SQL Server is a relational database management system mainly used on Windows (SQL Server 2017 supports Linux), it is closely related to Windows in all aspects. From installation and startup, connection(windows authentication)&certification and encryption, management and maintenance, etc., including various HA technologies,sql server failover cluster, availability groups.

In addition to the basic concepts, you need to actually understand all aspects of SQL Server according to your needs.
https://learn.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15

Answer 2

so these will come under windows Administrator

Answer 3

Hi @dineshnegi-9437

Below are the Database Skills.
Install and maintain the performance of database servers.
Develop processes for optimizing database security.
Set and maintain database standards.
Manage database access.
Performance tuning of database systems.
Install, upgrade, and manage database applications.
Diagnose and troubleshoot database errors.
Recommend and implement emerging database technologies.
Create and manage database reports, visualizations, and dashboards.
Optimize query performance
Perform automation of tasks
Plan and implement a High Availability and Disaster Recovery (HADR) environment
Perform administration by using T-SQL

https://learn.microsoft.com/en-us/learn/certifications/azure-database-administrator-associate/

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.