New Disaster Recovery option for Peer-2-Peer (P2P) Replication in SQL 2008

  New Disaster Recovery option for Peer-2-Peer (P2P) Replication in SQL 2008 Chris Skorlinski Microsoft SQL Server Escalation Services Problem: Following a severe systems/replication failure, SQL 2005 requires database updates to be frozen until the peer is re-established. Peer-to-Peer Transactional Replication http://msdn.microsoft.com/en-us/library/ms151196(SQL.90).aspx Maintenance Considerations The following actions require the system to be quiesced (stopping activity…


Information Architecture, Navigation Design, and Graphic Design

Note: This article is updated at Information Architecture, Navigation Design, and Graphic Design. There’s often confusion over the distinction between information architecture, navigation design, and graphic design.  One of my favorite books that explains what these terms are and the distinctions is the book, The Design of Sites, by Douglas K. Van Duyne, James A….


Success Patterns for Web Sites

Note: This article is updated at Website Design Patterns. So many Web sites fail at helping users complete tasks or find the information they need in a simple way.   E-Commerce sites like Amazon tend to do a better job than a lot of sites here because they have a tight feedback loop for customers completing…


Project Plans in a Nutshell

Note: This article is updated at Project Plans in a Nutshell. “I love it when a plan comes together.” — Colonel John “Hannibal” Smith, The A-Team Project plans are tough.  No matter how many times you do them – they are always tough.  I’ve been doing them for years, and yet the path from zero…


Transaction Log File Considerations when using Change Data Capture

Transaction Log File Considerations when using Change Data Capture Content Provided by: Paul King, Microsoft One of the most important things to watch out for with change data capture is the transaction log I/O subsystem. As stated earlier, log file I/O significantly grows when change data capture is enabled in a database. In addition to…


How to execute a TSQL statement for all databases

How to execute a TSQL statement for all databases I wanted a quick way to execute a TSQL command against all databases.  I was having hard time getting the sp_MSforeachdb to work and didn’t want to write a cursor,  so I instead built a TSQL command which makes the commands I need to execute.  Not…


Snapshot Files deleted when "@immediate_sync = N’true’" and "@retention = 0".

Snapshot Files deleted when "@immediate_sync = N’true’" and "@retention = 0". As mentioned in previous post the @immediate_sync = N’true’ allows you to add a new Transactional Replication subscriber anytime during the Retention Period as both the Snapshot files on disk and the “cached” transactions stored in the distribution database will be available to bring…


Using “Verbose history agent profile.” while troubleshooting Replication

Using “Verbose history agent profile.” while troubleshooting Replication by Chris Skorlinski Microsoft SQL Server Escalation Services The “default” Agent Profile enables “-HistoryVerboseLevel 1” which provides limited detail in the Distribution database history tracking tables. Using Replication Agent Profile “Verbose history agent profile.” enables “-HistoryVerboseLevel 2” which provides additional diagnostic data while troubleshooting SQL Server Replication. …


TSQL Scripts to Analyze Merge Replication Filter Logic

TSQL Scripts to Analyze Merge Replication Filter Logic Provided by: Suresh B. Kandoth, SR Escalation Engineer, Microsoft SQL Escalation Services These 2 scripts are used by the SQL Server Replication Support team to help analyze the Filter Logic used in Merge Replication.  The first lists all defined Subset and Join filters.  The first listing shows…


Success Pattern for V-Teams

Note: This article is updated at 6 Success Patterns for V-Teams What is the success pattern for leading a successful v-team?  I asked one of my mentors, a seasoned softie for his take on what are the keys to a successful v-team.  Here is what he had to say: you’re building a coalition — not…