The post discusses common issues with file encoding when using PowerShell, specifically when logs appear corrupted or unintelligible. It provides a solution by ensuring commands use UTF-8 encoding and includes a PowerShell script that repairs damaged files by converting UTF-16 data back to UTF-8, enabling proper data recovery.
Let's be honest, you thought of doing this yourself. Connecting two tools that seem to serve very different purposes. But, as I had a day to fool around, I thought to myself, let's see if I can make this work. In the previous blog post on MCP Local, I described how to run your MCP … Continue reading SQL MCP: Local to Fabric Lakehouse
In the previous blog posts, I've written about installing MCP and how it works, followed by how to use it with an Azure SQL Database through an Azure Container Instance and Microsoft Foundry. But, you can also use your favourite local database (SQL Server ;)) and Visual Studio Code. The reason Visual Studio Code is … Continue reading SQL and MCP, the local edition
