Resources from Async Best Practives Session

📦 Async Base Practices Session Resources & FAQ

Hey there! 👋

So, the last few days my inbox has been absolutely flooded with questions about my session at DotNet Spain Conference. Apparently, you folks are curious about the behind-the-scenes stuff!

Here are the top questions that kept popping up—figured I’d share the answers in case anyone else is wondering the same thing 😉

🖥️ “Wait, What Console Was That?”

“Your demos were console apps, but what terminal were you using? That definitely wasn’t the classic Windows cmd, right?”

Nope, you got that right! I ditched the ancient cmd.exe ages ago for the much more badass ConEmu. This beauty lets you spin up multiple shells (PowerShell, PuTTY, mintty, GViM, you name it) and organize them in tabs or split them into tiles like a boss.

Grab it here: https://conemu.github.io/

Pro Tip (Aug. 2020 Update) Actually, since this post is getting a bit long in the tooth, I’d also highly recommend checking out the shiny new Windows Terminal. It’s Microsoft’s modern take on terminal emulators and it’s pretty sweet! 🔥

🔍 “That SQL Profiler Template Tho…”

“In your last demo (the database cancellation one), you showed traces in SQL Profiler. You mentioned having a custom template for that? Mind sharing it?”

Absolutely! This template is actually pretty straightforward but super useful. It captures both the Starting and Completed events every time a SQL statement gets executed (in our case, a stored procedure that takes about 5 seconds to run).

The cool part? You can immediately see whether requests completed successfully or got cancelled by the user, plus you get timing info that’s perfect for debugging performance issues or cancellation behavior.

Download the template: sql profiler template

Here’s what the template looks like in action:

Installation is dead simple:

1. Download the template file
2. Double-click it
3. SQL Profiler opens and tells you it imported successfully
4. Done! 🎉

Now whenever you want to use this trace template, just select it like any of the built-in ones:

Hope this helps! Drop me a line if you have more questions 🤘