You mentioned the user picks the database in the report. Wouldn't that be the value you use to query the db?

If there's one row, then for comfile_sql, use this:

            
July 2, 2019 at 8:26 pm
            
#3659508

            
            
                                                
        

If you're populating the report with the company name, then this is only querying one table, correct?

I assume your context isn't the right database, so you really need a query...

Status update has a list now - https://www.sqlservercentral.com/forums/topic/status-update-2-jul-2019

OK, sharded/federated databases. Is there a reason you search all dbs rather than asking if this user as access in this db/company? I assume that the humres table exists everywhere?

Not...

I hate to duplicate all GH issues here, but I can perhaps add a list to the status update of the front end items that might let you know what's...

Issue in backlog already. Below search and a few other things.

+1 to what Jeff said

Is this a one time thing or a regular query? Because searching across all databases and checking if a table exists is going to be bad for performance and not...

Thanks, need to write more of these. I think at 2019+ this starts to become a more viable tech.

I've submitted an issue to try and get quoting either only quoting the post itself (no sub quotes) or adding line breaks in. I think this is a cumbersome item.

It's not, but it's a lot of work, and easy to make a mistake in complex guard clauses. Add to this the evolution across a dozen changes and the scripts...

We run SSC on ephemeral drives (NVMe) but with AGs because if it dies, we need to fail over .

I think the challenge is that the actual implementation of how you deploy changes presents challenges. You can't easily mix state and migrations if your deployment method is a particular...

RSA was a poor choice, and actually might be correct. The documentation isn't clear here, but developers can write their own implementation of a key store, which could be an...

I'll leave this here, as we're not going to agree.

I've apologized for the issues, and I do so again here: I'm sorry. We made mistakes and didn't do this that...