Last execution time - Yes - look at sys.dm_exec_procedure_stats

Last executed parameters - No - you will need to create extended event sessions to capture that information

doesn’t matter on the authentication type, the exact same principals of logins/users/permissions still apply.

Although for ease of management...

Your login will probably have sysadmin rights as you are the one who installed SQL, as such you are essentially "God" on the server, nothing can stop you, you don't...

So you have a process which is encrypting the MDF/NDF/LDF on disk outside of the SQL server process?

TDE is not a performance killer, it will add 1-2% CPU overhead which...

Move the hosts to a subnet which isn't full.

Decommission some hosts from the full subnet

Move other hosts to a different subnet

You need to make space in the subnet, or change...

The error message is quite clear on that, you have a database which is already part of the availability group, to setup DAG's all the groups need to be empty,...

Well first things first, you really need to be telling the client that they need to get off SQL 2008 and like 2 years ago, so you really need to...

If you don't want to shrink the only other alternative is to create a blank database and copy all the data from Original to New then drop the original database.

Access is given in multiple parts.

Logins and Users and permissions

logins give access to the server

users give access to the database(s)

permissions will Be at a role or individual securable option.

so what...

No easy way, if you want to change everything you need to script everything out and do a find replace and regenerate the database then reinsert the data.

The alternative is...

With no relationships your diagram will just be a heap of tables.

Go into the database in SSMS and expand the diagrams option, and add in the tables you want to...

So your database on SQL Server is none relational?

Or do you have a NoSQL databases on another platform and you want to make a diagram in SQL server?

If you have...

Testing the DBATools and the Connect-DbaInstance (as I don't usually use a second machine as its all on my laptop, and DBATools uses SMO which is the same as SSMS...

OK, so to confirm, SQL Configuration Manger shows TCP/IP as enabled here

You then have a TCP 1433 (or whatever port is in use if...

So have you enabled TCP/IP as a protocol for SQL Server to allow incoming connections from other machines in the network and then restarted the service?

have you then also opened...