TDE seems to be a tick box to lower insurance premiums, meet regulatory compliance etc. Personally I would concentrate on encrypting sensitive columns, with something like Always Encrypted, before getting...

Our servers force encryption so the following works for me.

USE [master];
GO
EXEC dbo.sp_addlinkedserver
    @server = N'<FQDN of Linked Server>'
    ,@srvproduct=N'SQL Server';
GO

Our infrastructure team now has a CA server which is recognised as such by every machine on our network. All I have to do is ask for a certificate with...

Here are my notes about forcing encryption on a local instance. I presume EC2 will be much the same.

1. Check the DoD is a valid CA on the EC2 instance...

• This reply was modified 5 months, 1 week ago by  Ken McKelvey.

The customer does not want to spend money on code changes really.... so I have to keep everything basically the same but get rid of filestream and move to...

• This reply was modified 5 months, 1 week ago by  Ken McKelvey.

You shold

You may also want to look at object storage. eg...

You shold

You may also want to look at object storage. eg...

Your question is too open-ended.

You need to provide details of the process, versions of SQL Server etc.

You can get a large file very quickly. In SSMS I would go Management | Extended Events | Sessions and right click on Track_Login and start it. Let it run...

No, but it will tell you if the SQL Server SPNs are configured correctly. It also allows you to generate a script, to give to your domain admins, if they...

It might be a Kerberos double hop problem where it falls back to, and manages to connect with, NT AUTHORITY\ANONYMOUS LOGON.

You could try checking the SPNs with the Kerberos...

If there are only a few rows, why is bridgeid a bigint?

You can...

• This reply was modified 5 months, 2 weeks ago by  Ken McKelvey.

Scripts that give index reccomendations are often a good starting point but you need to understand what is going on behind the scenes. I generally deal with OLTP dbs so...

The following will reset the Total variables on the code boundary:

SELECT ISNULL(CODE, '') AS CODE, ISNULL(ID, 0) AS ID, TIP, AMOUNT, PRICE
    ,PRICE -...