question

Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 asked learn2skills commented

SQL knowledge to windows administrator

Hello Everyone,

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered

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://docs.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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Chotudin-9437 avatar image
0 Votes"
Chotudin-9437 answered

so these will come under windows Administrator

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

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://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.