1. Kick off a restore
2. SELECT * FROM sys.dm_tran_locks WHERE request_session_id = the @@SPID of the restoring connection.

During restore, the restoring thread will take an X lock on the whole...

I previous worked for a very large SaaS software company. Here's the approach they took, which works to solve the A vs B problem:

1. Management clearly dictates in writing and...

With the exception of adding a step #0 to start the session, I repeated your posted steps on SQL2022 in the same order, Viewing Target Data after the CREATE DATABASE...

Did you start the session?

ALTER EVENT SESSION [testsession] ON SERVER
STATE=START;

Is there a DDL Trigger on the CREATE LOGIN event that's blocking you, either intentionally or because of a bug in the trigger code?

SELECT * FROM sys.server_triggers

https://learn.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers?view=sql-server-ver16

TDE certificates don't expire (from the docs for CREATE CERTIFICATE - EXPIRY_DATE entry at https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15): "However, expiration is not enforced when the certificate is used for database encryption or Always...

IOCP = I/O (disk) Completion Port - After SQL Server makes an asynchronous storage request to the host OS, the OS will return data and notifications through the I/O Completion...

CREATE STATISTICS ... WITH AUTO_DROP is only available on AzureSQLDB, Azure Managed, and SQL2022.

The package was created with the wrong target SQL Server version.

After booting them out of the ddl_admin role, you can GRANT and DENY permissions to them directly on the Schema, which will carry through all objects within the schema. Include...

Note: Availability Groups are Mirroring version 2.x; you can repurpose the mirrors into AGs that include an AG Listener that will redirect clients after a failover.

Convert the separate mirrors of...

.

• This reply was modified 2 years, 2 months ago by Eddie Wuerch. Reason: Response was double-posted

There are a variety of actions you may take on a server that are prohibited in the documentation. I've dealt with several over the years in a VLDB world such...

The encrypted data isn't affected by the hashing algorithm change, the storage of the encryption key is.

Details of the issue are listed in the KB article that introduced the trace...

You can stop treating a normal condition as a failure that can be ignored by adding the check for primary into each step that does work that should only occur...

What was the login error, and on which of the two SQL Server instances was it recorded? The client will only receive error 18456 and no other details, but the...