Reading list for the week – 24/10/11

I am starting off this week’s Reading List with an article related to Hotfix Service Model. This article has good information on how Microsoft SQL Server team uses the Incremental Model to deliver hotfixes to SQL Server.

A new hotfix was recently released to fix the issue of series of messages while restarting SQL Server 2005 through SSMS. This issue happens when SQL Server 2005 and Biz Talk Server 2006 are installed on the same server. Read more about this here.

Next is an interesting article by Kalen Delaney (b | t) on The Pros and Cons of Parameter Sniffing.

Are you using Database Mirroring and the transaction log is growing huge during Index maintenance? If yes, Kimberly L. Tripp (b | t) and Paul Randal (b | t) discuss about a different approach to index maintenance on mirrored database in this article.

That’s all for this week. Happy learning!

4 thoughts on “Reading list for the week – 24/10/11

  1. Pradeep Kumar Buddharam

    Hi Pradeep,

    Hope you are doing well. I want to know some details regarding SCOM and DBAMON. I have read some articles but not got much information. For SCOM I came to know that it is a monitoring tool but not sure how to configure and how it works for generating alert. For DBAmon it is like automated process in getting the server details.
    Can you please help me in providing some information like
    1.How to configure Sql server to SCOM and DBAMon for alerting purpose.
    2.Using the tools will have any performance issues.
    3. How to configure database mail to this tools.

    It will be helpful to me if you provide some information.

    Thanks
    Pradeep Buddharam

    Reply
    1. PradeepAdiga Post author

      Hi Pradeep,
      Nice to hear from you. I haven’t worked on SCOM. If DBAMON is the tool by Bill Border, yes I had worked on it for some time. You need to edit the config file in the Unix box and add a DSN entry on the server where the SQL instance is hosted. You may find this article useful.

      Reply

Leave a Reply