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

How to move a Published Table to a new File Group

How to move a Published Table to a new File Group Chris Skorlinski Microsoft SQL Server Escalation Services I recently needed to move a Transactional Replicated table to a new File Group.  There are a couple of documented Schema changes that can break Replication. http://msdn.microsoft.com/en-us/library/ms151870(SQL.90).aspx However, I found most problems are solved if I first…

1

Update Statistics fails with Error Number:–1073548784 "Could not allocate space for object ‘dbo.SORT”

Update Statistics fails with Error Number: –1073548784 “Could not allocate space for object ‘dbo.SORT” Chris Skorlinski Microsoft SQL Server Escalation Services · ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352′ in database ‘tempdb’ because…

0

Using Power Shell to script out Replication

Using Power Shell to script out Replication Chris Skorlinski Microsoft SQL Server Escalation Services While troubleshooting customer’s Replication scenarios we often ask for the “script” used to recreate their replication environment.  The BLOG posting below by Chad Miller provides a great example of using Power Shell and Replication Management Objects (RMO) to script out Replication….

1

Stop and checked your Virtual Log Files (VLFs)

Stop and checked your Virtual Log Files (VLFs) Chris Skorlinski Microsoft SQL Server Escalation Services Is your transaction log over 5gb?  Have you checked to see how many Virtual Log Files (VLFs) exists in your transaction logs?  If not, I would suggest you add to your many list of high priority tasks checks to see…

0

SQLSaturday, Toronto, Sept 17, 2011, check it out!

SQLSaturday, Toronto, Sept 17, 2011, check it out! Chris Skorlinski Microsoft SQL Server Escalation Services If you are in the Toronto area, or can be, on Saturday, Sept 17th, 2011, check out SQLSaturday workshop.  Great opportunity to meet with other SQL professionals and learn from great speakers on a wide variety of topics.  I’ll be…

0