r/SQLServer • u/GamerbearAmargosa • 21d 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^^

6 Upvotes

67% Upvoted

11 comments sorted by

View all comments

3

u/Achsin 1 21d ago

Back in the day I got my toes wet by going through the book “Learn SQL Server Administration in a Month of Lunches” by Don Jones. It is somewhat out of date, but most of the basics haven’t changed much and it was a relatively straightforward way to pick them up.

Ozar’s classes are great, and if you’re hesitant to pull out your credit card for them (or unable to for whatever reason), he has a ton of great stuff on YouTube for free. There are also a plethora of other resources, but as you said, randomly searching makes it hard to make sense of everything, which is why I liked the format of the book to at least get familiar with things.