I am just starting out in the world of SQL Server Database/Server administration, Due to a unexpected workload..
Can anyone suggest good, free training books or free training videos.
Which cover Profiler, Perfmon and other essential aspects of administering a server
I have read the book by How to Become an Exceptional DBA by Brad M McGehee but that was more about a DBA as a person. (I do fit the profile but not the 开发者_开发百科wage at the moment) 10 years. I will be there!
Probably the best documentation is the SQL Books online http://msdn.microsoft.com/en-us/library/ms130214.aspx
Videos covering backup basics and a few other tips/tricks are here http://www.sqlservervideos.com
www.sqlservercentral.com is a great resource as well. Lot's of good articles and blog entries around features and tasks.
There is a really good Stairway series on SQL Server that covers the profiler and other admin tasks.
www.sqlcat.com is good for whitepapers
Also look into www.sqlpass.org, which is the Professional Association for SQL Server, and sswug.org which also has lots of articles and features. SQL PASS has regional chapters that meet and present regularly. The one for my area puts those sessions up on the web as archives which is very helpful.
I'm sure there are other ways to find books "that fell off a back of a truck" in digital form around the internet as well.
精彩评论