Synchronize two tables using SQL Server Integration Services (SSIS)-Part II of II

Please, refer to this link for the first part of this post. In this part we will start with the same sample scenario where “table A” in “database A” needs to be synchronized with “table B” in data warehouse “database B”. During the first part of this post we discussed how to deal with new…

1

Synchronize two tables using SQL Server Integration Services (SSIS)–Part I of II

There are situations where a SQL Server DBA needs to keep two different tables in sync. Usually, the DBA needs to keep a copy of a table in a in a data warehouse repository that is used as a solution for archiving and/or reporting. SQL Server provides a robust method for keeping data synchronized across…

7

Kerberos Error Configuring SQL Server Linked Server for Delegation

Today I want to post about my findings on a case involving a linked server between two SQL Server servers. Before anything else I want to give thanks to my colleague Ignacio Alonso Portillo, who was kindly enough to help me not only with this support case but with many others too. My customer called…

0

What are Sparse Files and Why Should I Care as SQL Server DBA?

Last week I worked with one of my co-workers from the Windows Platform Support group in a backup-related issue with SQL Server data files. We both learn several things because of that case and I think it is worth the time to share this information with you. Our customer was using Microsoft Data Protection Manager…

0

“The IP Address ‘x.x.x.x’ is already in use. To continue, specify a different IP address” SQL Server 2008 cluster setup error

Today I want to talk about my experience with one of the most strange setup errors installing SQL Server in a cluster. In this particular case I was helping the customer to install a new SQL Server 2008 R2 instance in a three-node cluster. The Windows cluster was already running with two instances, each one…

3

“OnlineThread: SQL Cluster shared data upgrade failed” error (ID 19019) installing Cumulative Update in SQL Server cluster

Last week I was working with a customer on this obscure SQL Server error right after installing Cumulative Update 9 (CU9) on a SQL Server 2008 two-node cluster. As you will see, the root-cause of the problem was easy to understand, but getting to the point of finding this root-cause was not. In this case…

5

Unexpected Behavior Setting Up Firewall Rules with Clustered SQL Server Instances

If you have ever try to setup firewall rules in your network to manage access to SQL Server you have probably found a somehow weird behavior when connecting to a clustered instance. In this particular case my customer was finding that the rules she had configured on her Windows firewall were working fine when connecting…

0

Running a Maintenance Plan Using dtexec.exe Command Prompt Utility Does Not Perform Any Action

SQL Server Maintenance Plans bring an easy way to DBAs to quickly setup routine maintenance activities in the database. Starting SQL Server 2005 maintenance plans are created as SQL Server Integration Services packages and could be executed in the same way as any other SSIS package: Using Business Intelligence Development Studio (BIDS) Using the SQL…

0