Looking for a good SQL Server 2019 Admin book with SQL performance, optimization , with some internals

Swguy 41 Reputation points
2022-04-01T16:21:24.743+00:00

Looking for a good SQL Server 2019 Admin book with SQL performance, optimization , with some internals - with content different than what is normally available online with some practical examples etc. Please suggest couple in this category.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,122 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-04-04T03:18:16.447+00:00

    Hi Swguy-2130,

    How are things going? Is the answer helpful?
    You can take a look at SQL Server technical documentation, which also has practical examples.
    And please also check Microsoft Learn, which has many courses for SQL Server. https://learn.microsoft.com/en-us/search/?terms=performance&category=Learn&products=%2Fdevrel%2Fcbe4ca68-43ac-4375-aba5-5945a6394c20

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Ronen Ariely 15,091 Reputation points
    2022-04-01T18:19:58.887+00:00

    Good day @Swguy

    Your question does not fit the forum!

    It is an opening for abusing by advertisements and has nothing to do with technical question that we can help you solve.

    There are searching engine which are designed foe searching Like Google and Bing. Try using one of these to get tens of books. In anyway most books will not cover everything you mentioned and you might need to start learning topic by topic, book by book.

    Administrating databases is a topic stand by itself, performance is something that can be learned in a week at least and it is another topic that stand together with optimization usually by itself, and internals is something in a different level (if you focus only on internals related to performance then it might be in the same book)

    Here is the answer to your question:

    https://www.google.com/search?q=sql+server+performance+internals+book&oq=sql+server+performance+internals+book

    Tip! Select the book not by it's cover, not by recommendation online from people you do not know, but mostly by the author

    Tip2! Number of edition the book is published might (not always!) say something about the book success, but at the same time it might suggest old info. Make sure that the book content is updated to the latest server version! Microsoft improve the server in each version, adding new features and new objects (for example functions, procedures, DNM and so on) which are directly relevant to performance. Learning from book that was written in 2005 might help to understand basic but will not bring you updated options which are relevant to SQL Server 2019 for example.

    ----------

    14150-image.pngRonen Ariely
    Personal Site | Blog | Facebook | Linkedin

    0 comments No comments

  2. Swguy 41 Reputation points
    2022-04-01T20:06:49.293+00:00

    Thanks @Ronen Ariely

    Apologies for posting the question here. Didn't know that this was a forum meant only for technical questions.
    Actually I was directed to this from another MS site.

    Thanks for the answer !