Considering NL2SQL? Should your database really be the prompt? How can SQL MCP Server help?
You’ve probably experienced both of these, perhaps at the same time. First, that desire to let an agent get at your data. It’s driven by simplification and better experiences for the user and for you: fewer screens, fewer queries, fewer reports, and less code overall. Second, and perhaps more importantly, that unrelenting reluctance and reticence […]
The post Considering NL2SQL? Should your database really be the prompt? How can SQL MCP Server help? appeared first on Azure SQL Dev Corner.
Published on:
Learn moreRelated posts
Outgrowing SQL Server Express? Upgrade to Azure SQL Database Free Tier in 3 Steps
If you’ve been building local prototypes, internal tools, web backends, or lightweight services on SQL Server Express, you know the routine: i...
MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More
Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the MSSQL extensio...
The Two Hybrid Searches in Microsoft SQL
Hybrid search is usually described as combining keyword search with vector search. Microsoft SQL does that, for sure, but we do quite a bit mo...
Your best friend: BlockOnPossibleDataLoss=True
BlockOnPossibleDataLoss can frustrate developers, but it's one of the most important safeguards in database deployment. Here's how to keep you...
Build Locally, Ship to Cloud for $0: Azure SQL for Modern App Developers
As app developers, our primary focus is building great user experiences, designing APIs, and shipping features quickly. What we don’t wa...
Refactor your database with SQL projects in VS Code
SQL database projects are a fundamental tool for keeping your database in source control, tracking changes and collaborating on quickly evolvi...
Build locally, ship to Azure: meet Azure SQL Developer
Big news: Azure SQL Developer is here, in private preview. It’s the Azure SQL Database engine, on your laptop, in a container. Build aga...
T-SQL Hygiene: Introducing the Covering Index
Often in applications, we write database queries. And often, the same query is executed again and again. To make queries against large tables ...
T-SQL Hygiene: What’s the Big Deal with SET NOCOUNT ON?
Learn why SET NOCOUNT ON improves stored procedure efficiency, reduces unnecessary messages, and matters to .NET developers. The post T-SQL Hy...
MSSQL Extension for VS Code: Shortcuts Configuration, Enhanced Results Grid Experience, and More
The MSSQL extension for VS Code v1.44 continues to improve the SQL development experience with features that help you work faster and customiz...