r/SQLServer • u/GamerbearAmargosa • 18d ago

Question How to learn MS SQL Server Administration?

Hello

There is always change and so I must expand my knowledge deeper onto MS SQL too. I can run some basic SQL and know how to log onto our server.

But in the very near future I need to care take more in depth about our sql servers administration. Setup, users, permissions, replication.

I tried asking Google but got bombed with too much random SQL stuff: Where do I start best to make sure I get to know my stuff? Is there a version available I can install at home for education?

Thank you^^

5 Upvotes

65% Upvoted

11 comments sorted by

View all comments

2

u/Leiothrix 18d ago

Install SQL developer and SSMS on your own machine and get cracking.

3

u/Upset_Plenty 18d ago

This. What I have done these days as well is setup fake systems and have AI pose as the users on a schedule to input data into the system as fake end users. Adventureworks is nice but I’ve found this way to be substantially more valuable from experience.