Hi,

If you have many tables with identity primary key that may cause pagelatch_up, pagelatch_ex, pagelatch_ex going up. You may consider using GUID primary keys if the concurrent insert rate...

That is not yet available for PaaS. If you use IaaS the automatic failover won't be available for you.

Why don't you use case statement and subqueries in the set part instead?

Hi,

1. You should monitor operating system counters: CPU usage, memory, etc. This way you can tell if it was more resource pressure on that server or not.
2....

That is possible that plans are different. What would I do in this case is create a plan guide on the primary replica and check how it works on the...

You can use the CREATE CERTIFICATE command in order to import a certificate with the private key, check this out - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql

Hi,

There are some limitations and restrictions on the algorithms and key length you can use - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/choose-an-encryption-algorithm

[FirstName] [varchar](max) NULL
Looks like some guy has very long 4 Gb first name and another looser don't have a name at all. 😛
How you can insert Chinese...

TDE
Data Encryption (using T-SQL functions)
Always Encrypted
Transport Encryption

Check this article - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/sql-server-encryption

Have you restored the initial full backup on the second server with MOVE option? https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql


MOVE 'FileStream' to 'D:\Filestream'


Yes, it should be audited. https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql

Something like this:

ALTER TABLE Customers ADD 
    PromotionCode nvarchar(100)  
    ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = MyCEK, 
    ENCRYPTION_TYPE = RANDOMIZED,