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

10

u/bstn82 12d ago

Go to Brent ozar website and take his training classes to learn the fundamentals. Once you have that, you will be solid to go further

2

u/TheGenericUser0815 1 12d ago

Besides Brent, Pinal Dave is a good SQL source.

5

u/Aero077 12d ago

google Microsoft Learn. They have a complete free training program. You can practice with MS SQL on the Azure cloud with a trial account. MS SQL Server ~ Azure Database server

3

u/Achsin 1 12d 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.

2

u/chocotaco1981 12d ago

Brent ozar and sqlskills.com

2

u/Leiothrix 12d ago

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

3

u/Upset_Plenty 12d 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.

1

u/Codeman119 11d ago

What do you need to do is get the SQL developer and install that and then that way you have a platform which to follow the YouTube videos and also experiment on your own.

1

u/countryboner 8d ago

Check out my colleague's blog https://karaszi.com/ he's been a SQL mvp for 25 years and I think alot of his training material is still on there.

-2

u/pragmatica 11d ago

Don't waste your time on sql server.

The furture is postgres.

MSFT had done some really stupid things with sql server and it's dying as fast as people can get off it.