As this is a SQL2022 thread, you could also look at using Polybase and an external table.

As mentioned by @Mr Brian Gale, cross server queries in SQL Server, for...

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

Copilot came up with:

You

Sent by you:

With Purview linage scanning, why must there be a master key setup in the database?

Copilot

Sent by Copilot:

Setting up a master key in the database is...

What do you meant 'after the data load'?

How are you looking at the csv file?

I...

SQL Server Query Tuning and Optimization | Data | eBook (packtpub.com)

Get your network people to create a load balancer with a separate connection...

SELECT ColumnA
FROM YourTable
GROUP BY ColumnA
HAVING COUNT(DISTINCT ColumnB) > 1;

The following give some details on using Let's Encrypt with SQL Server. My understanding is the SQL Server service account only requires READ access to the private key; not FULL...

I think the problem might be it is looking for the user, not the group, in DatabaseB.

I am not anywhere I can test this.

It could be a bug. I doubt if many people use maintenance plans. You may want to look at Ola Hallengren's Solution.

If they are using a SP, I would be inclined to remove MyDom\MyGroupName from DatabaseB and use Module signing. In outline;

USE DatabaseA;
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
CREATE OR ALTER...

• This reply was modified 4 months, 3 weeks ago by  Ken McKelvey.
• This reply was modified 4 months, 3 weeks ago by  Ken McKelvey.

This makes sense. EXECUTE AS LOGIN allows instance wide permissions.

If I impersonate the service account with...

If you are dealing with large amounts of transactional data you may also want to look at table partitioning or partitioned views.

You might be able to get a self-signed certificate to work by importing it into the client as well as the server.

Have you tried connecting to the IP address instead of localhost or the server name?

The following is a .NET reporting solution:

.NET and JS Reporting Solutions | Design Custom Reports in Code | ActiveReports (mescius.com)