Learning SQL Server 2017 Administration

Question

Learning SQL Server 2017 Administration

rondebbs 48050

Old Hand

Points: 371
More actions
November 24, 2018 at 9:29 pm

#409332

Is there a good book or material to learn the product from a DBA perspective. I will probably take the Certifications but also need to learn it well from a practical stand point. The best book I can find seems to be - SQL Server 2017 Administration Inside Out. Has anyone used it? Is there anything better out there? I learn better my own running scenarios etc rather than in classroom setting. Any point in the right direction would be helpful. Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 1

rondebbs 48050 - Saturday, November 24, 2018 9:29 PM
Is there a good book or material to learn the product from a DBA perspective. I will probably take the Certifications but also need to learn it well from a practical stand point. The best book I can find seems to be - SQL Server 2017 Administration Inside Out. Has anyone used it? Is there anything better out there? I learn better my own running scenarios etc rather than in classroom setting. Any point in the right direction would be helpful. Thanks

Check Udemy they have some good practical video lessons on SQL Server 2017 Admin.

Lowell SSC Guru Points: 323506 More actions · Answer 2

note that when it comes to SQL Server administration, not a lot has changed; if you find a class/book/blog on administration in general, from 2012 and later, say, you would be fine.
Enabling Query Store and using Query Store might be more relevant, how the new auto tuning of indexes and plans are coming more into play, that is something to research, but you can drill into the specific new things to SQL2017 separately.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

aksel.rohtsalu Say Hey Kid Points: 664 More actions · Answer 3

Hi
Check SQL Server 2012 Database Administration (70-462) in pluralsight

https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt1/table-of-contents
https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt2/table-of-contents
https://app.pluralsight.com/library/courses/sql-2012-database-administration-pt3/table-of-contents

regards
Aksel