Replication Agent fails with “An error occurred during decryption.”

Replication Agent fails with “An error occurred during decryption.” Chris Skorlinski SQL Server Escalation Services While helping a customer on a Replication issue, we encountered an very unusual error message. An error occurred during decryption. There is no remote user ‘distributor_admin’ mapped to local user ‘(null)’ from the remote server ‘repl_distributor’. Changed database context to…


Example of Merge Replication Fake Conflicts

Example of Merge Replication Fake Conflicts José Moreira Neto Microsoft Escalation Engineer   I ran into an issue where the customer was complaining that Merge Replication was generating “fake” conflicts. This customer has a straight SQL Server Merge Replication with no filters where the only non-default setting is the use of the Microsoft Maximum Conflict…


Replicating data loaded with BCP or Bulk Insert

Replicating data loaded with BCP or Bulk Insert Chris Skorlinski Microsoft SQL Server Escalation Services Yes you can use both Transactional and Merge Replication to move data inserted using the BCP.exe utility of the Bulk Insert command to Subscribers. Considerations For Transactional Replication By default, Transactional Replication will replicate data loaded via BCP or Bulk…


Six Steps for Enterprise Architecture as Strategy

Note: This article is updated at 6 Steps to Build a Strong Foundation for Execution. One of my new favorite books is, Enterprise Architecture as Strategy, by Jeanee W. Ross, Peter Weill, and David C. Robertson.  My colleague, Danny Cohen recommended it as one of the best books on enterprise strategy and I agree. A…


What does high wait in SOS_SCHEDULER_YIELD mean?

What does high wait in SOS_SCHEDULER_YIELD mean? Chris Skorlinski Microsoft SQL Server Escalation Services I was teaching a class this weekend  at http://www.sqlsaturday.com/60/eventhome.aspx on using Change Data Capture to pull changed data from SQL Server.  I complete my class so I headed over to Thomas LaRock http://thomaslarock.com/ class on WAITS AND QUEUES.  It was a…


Rozdíl mezi Partner MPN a placenou verzí Visual Studio a MSDN, sleva 20 % pro certifikované partnery

Licence Visual Studia a MSDN získané v rámci Microsoft Partner Network Programu (MPN) nelze použít pro tvorbu na zakázku, úpravu unifikovaného řešení nebo jiných placených služeb včetně outsourcingu pro jinou společnost včetně mateřské nebo dceřiné.  Lze je použít pro tvorbu komerčních “krabicových”/”marketplace” produktů. Mají však některá funkční omezení a nejsou trvalého charakteru.   Slevy na nákup Visual Studia/MSDN…


Methodologies at a Glance

Note: This article is updated at Agile Practices at a Glance. I’m a fan of simple maps to help drill in. After all, it’s hard to explore the concepts if you don’t know they exist, or you don’t know what they are called.  Below is a work in progress.  I’m making a quick, simple map…


Just Enough

Note: This article is updated at Just Enough. I happened to look over to my bookshelf and noticed that I have two books that landed together by chance: Just Enough Project Management Just Enough Software Architecture I’m a fan of “just enough.”  One of my mentors liked to quiz me with the question: “How much…