The steps I am aware of are:

1 - find the bottleneck - is it the Lake, is it the network, is it the internet, is it the power BI processing,...

To add to what Jonathan said - do you understand the code? If person A is supporting it now and understands the code and they are leaving and you are...

First comment on this, I think you will get more/better results on a PostgreSQL form than a SQL Server forum. That being said, PostgreSQL has documentation on authentication. Have you...

First thing I'd check is "what changed?". If it worked prior to a certain date and suddenly stopped working, something changed. Step 1 is to figure out what changed and...

To add to what Jeff said, there are a lot of things mentioned in this thread to check. If it is a scheduled "crash" of the instance, then you likely...

This looks like a case for a UNION. You do your main SELECT then UNION a SELECT of the ID and the date minus 1 day. There is probably another...

I agree with Erland - installing 2008 R2 in 2023? yikes... BUT you may have a good reason, so do what you gotta do, but that's never fun installing such...

I'm saying I don't remember if it calls a logout or if it leaves the connection open in a suspended state (ie open but doing nothing) when it completes. I'm...

I'd be a little curious if it is related to the exact process you are running (failing to drop the database due to replication) OR if it could be something...

I think it really depends on the problem you are trying to solve. I am guessing you read the comments to the SSC post here:

https://www.sqlservercentral.com/forums/topic/script-all-logins-users-and-roles

If you are looking to re-create...

My troubleshooting steps are always the same - review the logs, reproduce the problem on a test system, and go from there. From what I found on google, it sounds...

I have not tested this, but any chance you have implicit transactions turned on in your instance?

If not, I'd open up a support case with Microsoft as nobody on this...

My opinion - there is a TON to learn. Heck, I know very little about SQL. Every time I think I know something, someone posts something that contradicts what I...

That is a lot of "insufficient memory" errors... any chance that the box hosting SQL Server is running out of memory?

Failing that, any chance that your service broker has a...

Only 50 MB is being used in the 10 minute timeframe. Looking at the longer time frame we can see more is used, jumping up to nearly 600 MB at...