Is that 1,5TB compressed backup size?

Will you be using backup to url= blobstorage(v2?)

or backup to azure file storage?

network speed 100mbps: is that your internet connection speed?

Are you the only user...

Best you can do is to script out the endpoint you've created using SSMS and SQL authentication and see what it used.

We always user the sql  server service accounts (...

It's almost humorous as to the amount of irony...

ah, the joys of would be JSON

SUBSTRING to the rescue

declare @wouldbejson NVARCHAR(200) = N'{BATHROOM CLEANING}{2.5%}'
 Select charindex(N'{',@wouldbejson, 1) as firstoffset 
, charindex(N'}',@wouldbejson,1) as firstEndOffset
, charindex(N'}{',@wouldbejson, 1)...

Why did it take...

Current for SQL2019 is CU17 ! Make sure you're keeping up with these cumulative updates ! They fix a lot, but you'll have to test !

Also: check "Manage...

This may be a start

SELECT object_schema_name(object_id) As ObjSchema, object_name(object_id) As ObjName, replace (T.definition, 'WITH SCHEMABINDING', '/*WITH SCHEMABINDING*/') as NewDefinition
FROM sys.sql_modules T
where is_schema_bound = 1
order by ObjSchema, ObjName

TEST...

For AD-groups, it no default is used.(as an ad-account may have access through multiple ad-groups)

For SQLusers, the engine sets it to "dbo" by default.

I have noticed this works ! (...

First problem:

This cte will return all rows of county.reporting.dbo.2022 whenever there are results in cte1 ! ( no where clause in exists query )

Same for the second union part

deduplicated by...

• This reply was modified 3 years, 1 month ago by Johan Bijnens.

"Like" does not work with...

Performance has a cost.

That cost starts with declaring the correct data type for columns !

If that is the only  task in your ssis package,  why not use Powershell ?

Dbatools

Export-DbaDbTableData

Short but very enjoyable indeed 🙂

A bit of Fulltext history can be found at ref: "Full-text index architecture"

Thank you for the feedback.

( I was out for a week of vacation. )

Just wondering why you add the uniqueidentifier to the physical filename ??

Move N'ftrow_FTC_titles' to N'E:\Program Files\Microsoft SQL...

you need to extract the logical filenames from the backup file!

you need to hard code the full restore statement (or generate the statement in to a variable to be executed...