I went live on TikTok and took your top-voted 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