Showing results for development - Azure SQL Devs’ Corner

Nov 20, 2024
5
1

Introducing the enhanced MSSQL Extension for Visual Studio Code

Carlos Robles
Carlos Robles

The MSSQL extension for Visual Studio Code is designed to support developers in building applications that use Azure SQL (including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs), SQL Database in Fabric (Preview) or SQL Server as backend databases. With a comprehensive suite of features for connecting to databases, des...

Azure SQLVS Code
Apr 22, 2024
0
2

Private Preview for External REST Endpoint Invocation with Azure SQL Managed Instance

Brian Spendolini
Brian Spendolini

We have an exciting opportunity for customers and partners to use External REST Endpoint Invocation with Azure SQL Managed Instance in a private preview. What is Azure SQL Managed Instance? Azure SQL Managed Instance is a PaaS service that has near 100% compatibility with the latest Enterprise Edition SQL Server database engine, providing a nativ...

Azure SQLRESTREST Endpoint Invocation
Apr 3, 2024
0
4

Vanna.ai and Azure SQL Database

Brian Spendolini
Brian Spendolini

Vanna.ai and Microsoft SQL Vanna.ai, in partnership with Azure SQL Database Product Management, bring you a collaboration for using Vanna's natural language to SQL (NL2SQL) agent with the Azure SQL Database. How does Vanna.ai work? First, Vanna is an open-source Python RAG (Retrieval-Augmented Generation) framework for SQL generation/natural lan...

Azure SQL
Mar 14, 2024
2
1

Azure SQL Trigger Binding for Azure Functions goes GA

Brian Spendolini
Brian Spendolini

Azure SQL Database Engineering and Product Management would like to announce that Azure SQL Trigger Binding for Azure Functions is now generally available (GA). Catching Up As a quick refresher, the Azure SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or...

Azure SQL
Feb 19, 2024
2
2

NL2SQL with LangChain and Azure SQL Database

Brian Spendolini
Brian Spendolini

LangChain is an open-source framework for creating applications that use and are powered by language models (LLM/MLM/SML). In this post, basic LangChain components (toolkits, chains, agents) will be used to create a natural language to SQL prompt that will allow interactions with an Azure SQL Database; just ask the database what you want as if ...

Azure SQLAIOpenAI
Feb 12, 2024
0
1

Using AI for Content Moderation with Azure SQL Database

Brian Spendolini
Brian Spendolini

In my previous posts, I have covered using Azure OpenAI services with Azure SQL Database via REST endpoints. This post with further explore that pathway by creating stored procedures you can use to encapsulate the REST calls and combine them with custom business logic for AI content moderation with Azure SQL Database. A Quick Introduction The ser...

Azure SQLAIOpenAI
Nov 30, 2023
0
0

Winter 2023 Service Update for External REST Endpoint Invocation

Brian Spendolini
Brian Spendolini

As December approaches, it's time for the winter 2023 update for External REST Endpoint Invocation. We have added four new Azure Service Endpoints: Bing Search, Azure Key Vault, Azure Communication Services, and Azure AI Search. Let's look at a few examples of using these new endpoints. Bing Search Endpoints Bing Seach has many useful API endpoin...

Azure SQLOpenAIREST
Aug 28, 2023
0
3

REST Endpoint Invocation is now Generally Available

Brian Spendolini
Brian Spendolini

On behalf of the Engineering and Product Management teams, we are happy to announce that External REST Endpoint Invocation is now GA!   What is External REST Endpoint Invocation? External REST Endpoint Invocation makes it possible for developers to call REST/GraphQL endpoints from other Azure Services from right in the Azure SQL Database....

Azure SQLDevOpsREST
May 1, 2023
0
3

Change Tracking in Azure SQL Database

Brian Spendolini
Brian Spendolini

The Azure SQL Database has two main ways to track changes with data (rows/DML) as well as table changes. One of those methods is Change Tracking with the other being Change Data Capture. Today’s post will be going into depth on Change Tracking. Change Tracking and Change Data Capture So, what’s the difference between the two? Change Data Capture ...

Change TrackingAzure SQL
Dec 5, 2022
0
0

Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt

Brian Spendolini
Brian Spendolini

In part 3 of our Azure SQL database change management (CICD) series we cover testing your code using tSQLt and GitHub Actions. Prerequisites Check Refer to part 1 and part 2 for the prerequisites. Fork the GitHub Project We will be using tSQLt in this post, so I have created a GitHub project made up of several SQL Da...

Azure SQLDevOpsContainers