Showing items from Ai

Fixing GitHub Copilot Agent Mode Hang in Visual Studio 2022

I was running into an issue with GitHub Copilot’s Agent Mode in Visual Studio 2022 where it would hang indefinitely after executing a command. This was particularly frustrating as it disrupted my workflow and made it difficult to use the tool effectively.

As it turns out, the issue is pretty straightforward to resolve. Apparently it tries to use the Powershell 7 terminal. In my installation, this was misconfigured and was pointing to some non-existent path. In my case, it was pointing to C:\Program Files\Microsoft\Azure Functions Core Tools\workers\powershell\7.4\zh-Hans\pwhs.exe, which does not exist on my system. You can check the path by opening the terminal window (CTRL +` or View->Terminal).

Continue Reading

The Real-World Trade-Offs of Natural Language to SQL Systems

Natural language to SQL (NL2SQL) systems are one of the most compelling applications of language models—but also among the hardest to get right in production. Turning messy human questions into precise, performant SQL queries touches nearly every challenge in AI: ambiguity, domain context, schema evolution, and validation.

Here’s a breakdown of the core lessons learned from real-world implementations—and why building a robust NL2SQL stack requires more than just dropping an LLM behind an input box.

Continue Reading