February, 2008

I'll be there, morning to evening, both days (26th and 27th) responsible for an area we have called "Rincón técnico de SQL Server" (SQL Server Technical Corner) where "Ask The Expert" sessions will be running virtually non...

Say you are one of those users who have been using SQL Server since 6.x days. And say you remember that in those versions there was the possibility to backup or restore a single table. Let's try hard to imagine your memory is good enough to be able to...

In red I highlighted the changes I've introduced to explain what was wrong in the original version of A tale about solving "Cannot generate SSPI context" and later "[DBNETLIB][ConnectionRead(recv()).] General network error. Check your network...

I had a customer who was receiving the "Cannot generate SSPI context error" when one, and only one, of his users with a specific domain account tried to log into a SQL Server 2005 using TCP network library and Windows Authentication. It ended...

Interesting story this one. I've been working with a customer who had a very simple package which consisted of a Sequence Container including an Execute SQL Task (which truncates the destination table) followed by a Data Flow Task. The Data Flow Task...

It seems Cumulative Update 6 (due in mid Feb 08) for SQL Server 2005 Service Pack 2 will include a code change so that performance counters show current performance values while the service is running, no matter what the service state was when perfmon...