1 – How can I not use self-sign cert in the TDE encryption. If I am following the below steps/ commands, then I will be using self-sign cert with my...

SQL1 and SQL2 are presently identities in your domain. They have machine accounts and DNS entries. Creating a Listener with the same network name as another server on the network...

First, you're using full paths to the nodes, even though you've shredded them with the .nodes method:

SELECT xed.event_data.value('(/RingBufferTarget/event/data/value)[1]', 'nvarchar(500)') AS value1,

xed.event_data.value('(/RingBufferTarget/event/data/value)[4]', 'nvarchar(500)') AS value4

FROM #capture_tls_data

CROSS APPLY targetdata.nodes('//RingBufferTarget/event/data') AS xed (event_data);

The...

By default, what you're doing is not possible, because the way SQL Server performs encryption work changed in SQL Server 2017. You can work around this with a trace flag....

"My clients are web apps, and native mobile apps, goes via an APP server that talk to the DB"

You seem to understand it. The key point is that the value...

The difference between Developer Edition and Enterprise Edition is basically limited to licensing and what words display with SELECT @@VERSION. Anything you can do with Developer Edition will work in...

'19 Nov 2022' is converts to the datetime value of '19 Nov 2022 00:00:00.000', which is earlier (less than) '19 Nov 2022 15:19:12.000'.

Try:

WHERE [...]
AND CONVERT(date, TransferredDate) BETWEEN...

This is known as a "Data Islands" problem - you're looking for groups of records in an ordered set.

You have a identity value on the table, so this gets easy....

Certificates used for TDE and Certificates used to encrypt a database backup will be in the master database. They are not included in the user database backup.

Certificates that have been...

Is there any way besides the Configuration Manager GUI to find out what SSL certificate is bound to the MSSQLSERVER network protocols?

Check the registry for what is configured. Fire up...

An SSL certificate is for communication between two different endpoints. The worst that could happen is the Primary won't connect to the Secondary, and things will look like they do...

A backup stripe set is a database backup taken to multiple backup files. The above 200GB block blob max size is your guide - use enough files to keep each...

Go to where the backups were created and look to see if you're grabbing the right certificate:

SELECT * FROM master.sys.certificates WHERE thumbprint = 0x477BB40D3618B2E162F70B62693D11F6FA3A360F

When you split a partition with data in it, the engine must scan the partition's rows to determine which rows will go into the new partition. Even in cases such...

The gold nugget in that error message is the \KB3045321\ in the path. 'KB' and a bunch of numbers means 'Knowledge Base article ######'.

1. Go search on Microsoft.com for "KB3045321"....