Another thing to point out - your data looks to be inconsistent:

A DB 130 9/1/2023
A DB 120 10/1/2023

why did "DB" shrink by 10 MB that day/month?

But in...

My opinion, you are going to need a tool to do that. Offhand, I am not sure what tool can handle it, but anything that supports WMI should be able...

I agree with Jeff - if the code is complex or confusing, it should have comments around those bits explaining the logic. Now, if the code is confusing to someone...

Just to add to what Phil said - that SHOULDN'T exist in the real world. I have run across some things that make me scratch my head like storing numeric...

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...

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...