Showing results for Azure SQL - Azure SQL Devs’ Corner

Apr 22, 2024
Post comments count0
Post likes count2

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 18, 2024
Post comments count0
Post likes count3

Data API builder Version 0.11 Brings In-Memory Caching

Jerry Nixon
Jerry Nixon

Literally, I just said that! I have three daughters, and it's amazing how they ask me the same questions over and over. I don't mind answering them, but I sure wish they would either remember my answer or, at least, write it down. There's a measurable cognitive load with the context switching and staying consistent in my answers. And that's a good—...

Data API builderAzure SQLREST
Apr 18, 2024
Post comments count0
Post likes count0

Vector Search Optimization via KMeans, Voronoi Cells and Inverted File Index (aka “Cell-Probing”)

Davide Mauri
Davide Mauri

In a previous article I already mentioned how vectors can be easily stored in Azure SQL already and how to calculate dot product and cosine distance using just T-SQL. In this article I will show how to improve the performance in vector search by using a technique that has many name but is really based on something very well know already: KMeans Clu...

AIAzure SQLVectors
Apr 3, 2024
Post comments count0
Post likes count4

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 22, 2024
Post comments count8
Post likes count8

Introducing Regular Expression (Regex) Support in Azure SQL DB

Abhiman Tiwari
Abhiman Tiwari

We are pleased to announce the private preview of regular expressions (regex) support in Azure SQL Database. Regex is a powerful tool that allows you to search, manipulate, and validate text data in flexible ways. With regex support, you can enhance your SQL queries with pattern matching, extraction, replacement, and more. You can also combine them...

Azure SQL
Mar 19, 2024
Post comments count4
Post likes count0

Empowering the SQLBits website with Azure SQL and Data API Builder

Davide Mauri
Davide Mauri

SQLBits is the biggest and most well-known data conference in UK and Europe. With several thousand people attending every year, and with more than 10 years of session recordings, it provides an amazing amount of knowledge to everyone who wants to learn anything around the Microsoft Data Platform. Be it on-premises, or on Azure, or the shiny new Fab...

Data API builderAzure SQL
Mar 14, 2024
Post comments count2
Post likes count1

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
Post comments count2
Post likes count2

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 14, 2024
Post comments count0
Post likes count5

Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale

Asad Khan
Asad Khan

Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale AI and cloud-native applications built for the future need a highly scalable, cloud native database with excellent price-performance. For applications operating on mission-critical relational data, Azure SQL Database Hyperscale provides the performance, reliability and s...

Azure SQL
Feb 13, 2024
Post comments count0
Post likes count1

Build your APIs with DAB using Containers – Part 2

Carlos Robles
Carlos Robles

Are you tired of spending countless hours building APIs from scratch? With Data API builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL, or M...

Azure SQLData API builder