SQL1 is running under the domain account: CORP\SqlServices. But what I'm thinking is that when the last DBA installed it...

Thanks Brian. The MS docs on SPNs are confusing.

I'm looking at things with our AD admin. More investigation reveals the following:

All services for SQL Server run under the CORP\SqlServices...

I should've checked before I posted: I can see using the query from the article that all the logins are using NTLM.

I'm still not sure why I get the...

Brian,

I run all SQL services under one domain account. When I do SETSPN -L on that account, I don't see any SPNs listed. (I have never used SETSPN to manage...

Yes and no 😉

I've seen this happen in a few different places. Generally, the storage admins I've worked with have been top notch. They understand best practice for SQL when...

Good article.

As Database Administrators we are paid to maintain three things:

* Confidentiality of data

* Integrity of data

*...

Hmm. Is your own domain user account in the Administrators group of the server that SQL is installed on?

Have you considered enabling mixed authentication so that sa will work?

If you've done all the research you can, nobody knows anything about those accounts and you really don't have...

Great article. I find myself struggling to explain these concepts to people on a weekly basis. You've put everything very clearly.

Some of the problems originate from the fact that there could be multiple samples in that table for a given date. The solution I've settled upon at the moment:

DECLARE

@Date1...

Thx. That's a good point that it depends on how much the index is used.

Did you shrink the database/data file after you truncated the table?

Have you tried breaking the query down into smaller parts to isolate what is giving that exact error? Have you tested the connection to the linked server from SSMS?

That's a great way of putting...

Above, Carl gave us an example of simulating a particular kind of corruption to practice recovering from it. Are there other simulations that you guys run through to help keep...