Are you doing your analysis is Excel or PowerBI? (You can use DAX for that... I'd check on Ferrari & Russo's website(s) for answers on DAX... I know there's one...

Oh fun... I think you have to use Availability Groups... Mirroring is deprecated.
Here's an introductory article to it.

Oh, like mirroring. (That's what mirroring does - executes the transaction log against more than one database .. where the second is a copy of the first.).  The second copy...

Triggers are written against tables, not stored procedures.
What's your ultimate goal? When DB1 is updated, do something in the other database? (add records, update?)
You could do both in...

I just installed that add-in as if it were a 2016 Add-In.  Seems to have worked. I expected it to faceplant, but it didn't. =)

This depends on whether each Person has his own Goal value or everyone has one combined Goal value. If they all have a single goal, say "1000 units", you could...

Maybe you're leaving something out, because your question doesn't make sense. 100% of WHAT? Do they all contribute to some grand total or something? Adding percentages makes sense if it's...

CREATE TABLE & INSERT scripts?

Feel free to explain more. I'm not sure I know how to determine what is approved.
Please read this and post again: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You need Jeff Moden's DelimitedSplit8K function for this...

DECLARE @MyString VARCHAR(200) = 'Department =''test'' AND Branch = ''Yankee'' AND city = ''Brooklyn'' AND State =...

Neither. fn_CalculateNetPay is a function, and that's how you join a table to a table-valued function - by using APPLY

sys.dm_exec_procedure_stats
does that.

FFS! Just post the contents of the text file into the message window!
--Create New Table
    drop table if exists Test_Tbl
    CREATE TABLE Test_Tbl (Id varchar(1), Name...

Only thing I can think of that even might work is to create a subform and add two parameters to it for DIP and Data. Then add that to the...

What happens if you run the stored procedure that the report is based on?
If you're on a test server, you could do something evil like run
DBCC FREEPROCCACHE
to...

Where does one get these files:
library("rClr")
library("rsqlserver")

?