Office Hours: Database Q&A

I went through your top-voted database questions from https://pollgab.com/room/brento. Here's what we covered:

00:00 Start
00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a production DB. I want @param=222 to use the plan compiled with @param=111 like it did in production. In my test it compiles a new plan for @param=222 every time. Suggestions?
01:37 Eduardo: Is PowerBI a recommended skill for SQL Server DBAs? Do many of the DBAs you encounter have this skill?
03:09 ProbablyOverthinkingThis: My friend and I agree that the overhead of Linked Server queries are "not ideal". What do you recommend if we have multiple databases hosted by their own application server databases and the need to cross query that data?
05:20 RoJo: We have 1TB DB and we use AG. The Log file is very large (350G), which perplexes us. Not that I need to shrink, but it does not show it would free up anything if I did. Why does SQL keep this so large - or should I care?
06:46 280-2-smallDBA: Query w/high ASYNC_NETWORK_IO. Nested CASE with subQs in cols and Where. Joins are comma sep names. All tbls are local to DB. Other big waits CXPACKET, CXCONSUMER. 1col is NVARCHAR(MAX) always null. Est row size 6kb always 1row. Why is AN_IO big wait? Can CXP and CXC cause AN_IO?
08:32 David Hicks: When looking at possible indexes to drop in order to fix table locks and long-running inserts/updates, is there a particular ratio of inserts and updates to actual usage of an index that you use for a guide, 10:1 for example?
11:45 Jökull: Is there a good way to include the IP address for when SQL Server sends out emails? We have some rogue SQL Servers sending emails and would like to track them down.
13:12 Vishnu: Will stack overflow experience a net benefit or loss from the A.I. revolution?
20:02 Gianis: What's your opinion of TSQL sprocs that have table value params that are passed in from .NET code? Is this good/bad practice from a performance perspective?
21:19 Perseus: What are your top rules for working from home for a WFH newbie?
22:28 DevInHiding: Hi Brent, sorry, this probably has been asked before, but can you recommend someone who is "the Brent Ozar of data security/encryption"? Thanks so much
23:57 Srinivas: In Azure SQL VM multi tenant DB, is there good way to determine which tenant is utilizing the most disk IO for billing and perf monitoring purposes?
24:54 Ramesh: What do you like about the paid AI chat tools over their freebie counterparts? Does one hallucinate less than others?
26:23 Dan: Hi Brent, what are the top things that you'd like to see added or changed in PostgreSQL to make porting from SQL Server as painless as possible?
27:56 Venkat: Are Microsoft certifications more important / valuable to the SQL Server contractor or the SQL Server corporate DBA ?