I tend to adopt Aaron's view a lot. I am refactoring my code and trying to make it better, but also help me clean things up that are an investment...

You can ask the AI what they did. I asked to restore a single table. Got "RESTORE FROM DISK WITH SINGLE_TABLE". Told it didn't exist but I could have pasted...

This apply?

https://support.microsoft.com/hu-hu/topic/kb4538365-fix-change-tracking-cleanup-does-not-work-when-invalid-cleanup-and-hardened-cleanup-version-are-negative-in-sql-server-2017-and-2019-f186bd92-622c-89f2-a6c2-739c250593f2

Expired records should be those that are in the tables, but should be deleted. Are you saying based on settings there aren't any records in the on-disk table...

Jason,

ask yourself this. Is the vibe coding any different from blindly approving a PR from a colleague? Or having to support someone else's code who you know takes shortcuts?

Those lawyers...

There is an FTP task in SSIS (https://learn.microsoft.com/en-us/sql/integration-services/control-flow/ftp-task?view=sql-server-ver17) and it works. Not SFTP though.

Works fine and I ahve friend still running xfers via ftp (or sftp via third party)

Glad you liked it

Yes, indexing makes a huge difference and the performance savings can overwhelm the index creation time/CPU

I find that the more talented people are with a skill, the less they trust an AI or want to use it. It's interesting, because it "reasons" about as well...

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver17

I lean towards Uwe's solution, especially when I need the table to stay online and accept insert/update/delete while I'm deleting data.

Microsoft implemented a change requiring a cert that is trusted through the local hierarchy, or the client clicking "trust cert". Depending on which client versions were upgraded or servers changed,...

If this (MaxCatalogConnectionPoolSizePerProcess) is set to 0, then the client value is used. You might set this higher. Similar question (or yours)

https://learn.microsoft.com/en-us/answers/questions/5646615/catalog-max-connection-pool-size-100

I think you need more connections set up...

Thanks, and I get it. The team is trying to figure things out. If you can repro, that would be great.

Lol,

Phil, how did you get that URL? Was it something from your profile or somewhere on the site? Those are old style URls, that we've blocked.

Lol, I used to pile up requests on my desk as I got busy. Just tell people to drop them there, along with email requests I'd print out.

at some point,...