That is a very ugly file. Guessing it came from a mainframe?

It may be faster and more supportable to learn some python to preclean and format the file than it...

you don't have to restore it to the same instance. Any instance that you restore the certificate (that is used by TDE) to, will be able to restore the backup.

I...

something I wish I had studied earlier in my dba career is normalization; Either before or alongside studying the materials on using SQL server.

Also, hugely useful thing to watch if...

Are there actually still places in the wild that implement database logic primarily with stored procedures in applications?

Don't get me wrong, I wish it were more of a thing, eliminating...

`

Hello @Mr or Mrs. 500,

you wrote "kerberos configuration manager does add something to the equation that can and will break". Can you tell us what is this "something" please?

Thank...

Is delegation constrained?

did you configure delegation for the new service account?

Yes. There is an encryption key in...

that is significant information. The CIFS share - I assume that is third party? does it support the AES kerberos encryption types? DES and RC4 would have been off by...

check the time on both systems and the logon rights of the service account. It naturally needs at minimum logon as a service, it may also need logon as a...

I had that in SQL 2017 2-3 years ago and all I had to do was create the login and user to recover - after several hours of troubleshooting.

MS claims...

I strongly recommend against using kerberos configuration manager. It doesn't negate the need to understand how kerberos works or how to configure kerberos, but it does add something (kerberos configuration...

I can pretty much guarantee that this is not a SQL problem, but a "you problem."

The comparison of the other company is interesting and I don't think was mentioned before.

The...

second page

If you implement this, I would do it in batches, in the columns you widen you are going to get some hellacious page splits