Updated posting on regenerating symmetric keys

Updated posting on regenerating symmetric keys Chris Skorlinski Microsoft SQL Server Escalation Services. I came across a great posting by Laurentiu Cristofor [MSFT] called “SQL Server 2005: How to regenerate the same symmetric key in two different databases”.  I modified his “column encryption”example slightly to include DecryptByKey and reposted it below.  The sample wraps in…

0

Follow the Data in Transactional Replication

Follow the Data in Transactional Replication Chris SkorlinskiMicrosoft SQL Server Escalation Services Abstract Many technology solutions use a STORE and FORWARD model to move data though out the business. It begins when source data change is detected, collected, and STORED in a cache. This cache data, often on a schedule, is processed and FORWARD to…


Lessons learned updating 100 millions rows.

Lessons learned updating 100 millions rows. Chris Skorlinski Microsoft SQL Server Escalation Services Yes, post mostly Replication or High Availability topics, but I found this interesting enough to share on my ReplTalk blog.  These are the troubleshooting and resolution we used to help a customer explore faster ways to update a 100 million row table….

1

Push v. Pull Merge Replication

Push v. Pull Merge Replication Chris Skorlinski Microsoft SQL Server Escalation Services I hope to answer the question “What is the difference between Push and Pull Merge Replication?” in this blog posting. As you know Merge Replication is all about merging or blending changes between multiple SQL Servers.  One SQL Server is designated as the…

2

SQL Server Transaction Replication Bounded Update (or why my UPDATE was transformed into an DELETE/INSERT pair)

SQL Server Transaction Replication Bounded Update (or why my UPDATE was transformed into an DELETE/INSERT pair) By José Moreira B. Neto Microsoft SQL Server Escalation Services   Bounded Update is the term used to describe certain types of UPDATE statements from the publisher that will replicate as DELETE/INSERT pairs on the subscriber. We perform a…

3