April, 2009

  • SQL Server Books

    Books I recommend: SQL 2005 : Inside Microsoft® SQL Server 2005: T-SQL Querying by Itzik Ben-Gan , Lubor Kollar and Dejan Sarka Microsoft® SQL Server 2005 Administrator's Pocket Consultant by William R. Stanek Inside Microsoft® SQL Server...
  • Replication: Non-convergence on Merge Replication

    one possible cause... I had worked on an issue which I found quite interesting so decided to post it in order to share with everyone. Problem : I change a row on the subscriber. Once that is done, I then see that the change is propagated to the...
  • Replication: Snapshot files removed after being Generated

    Snapshot files for a transactional publication are immediately removed after being generated by the snapshot agent I had recently worked on this issue and decided to post my findings as this may help others that are experiencing the same issue. ...
  • SQL Server Performance Analysis Part IV

    PART IV: "How To" get down to whatever is bringing SQL to its knees... At this point, one should know already whether or not they have memory pressure / cpu bottleneck / disk issues (previous blog posts). With that information, we now filter down...
  • SQL Nexus – The Tool

    After writing about "How to analyse SQL Server Performance", I decided to write a post about SQL Nexus, which, if I am not mistaken, I have mentioned before in previous posts. SQL NEXUS : Download tool from: http://www.codeplex.com/sqlnexus ...
  • Questions and Topics

    If you have any questions in regards to any issue related to SQL / SQL Replication or would like me to post a blog on a topic, please feel free to drop a comment or e-mail me: clsilva@microsoft.com
  • Replication: Sysmergearticles and Error 208

    Invalid object name "dbo.sysmergearticles" : I have seen issues on Forums where people state that they get the error "invalid object name dbo.sysmergearticles when they try to replicate their subscriber with their publisher. I had recently...
  • SQL Server Performance Analysis Part III

    PART III: "How To" get down to whatever is bringing SQL to its knees... Now let’s get down to pinpointing the troublemaker: In most cases, when SQL’s performance is degraded, we never know what exactly is causing the issue. In most cases, we also...
  • SQL Server Performance Analysis Part II

    PART II: "How To" get down to whatever is bringing SQL to its knees... SQL Server Error Log : If SQL Server has an issue, this is most likely where you will find an indication to what is going wrong. This log provides us with lots of information...
  • SQL Server Performance Analysis

    PART I: "How To" get down to whatever is bringing SQL to its knees... Having worked with SQL Server for a few years now, I know that one of the most problematic issues is performance . There are many ways however of analyzing SQL Server performance...