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