Azure SQL Dev Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
Announcing LangChain integration for your SQL-based AI applications
In today's data-driven world, the ability to seamlessly integrate various technologies is crucial for efficient data management and analysis. We’re excited to announce LangChain integration with Azure SQL Database and SQL database in Microsoft Fabric! LangChain, a powerful tool for building solutions with language models, can be effectively combined with these services to build AI-ready applications. What’s New? Native Vector Support: SQL Database and SQL database in Fabric now support native vector search capabilities. This new capability brings the power of vector search operations directly to your SQL...
Build AI apps faster and easier with SQL database in Fabric – now Public Preview!
The SQL Server and Azure SQL team has embarked on a mission to make building AI apps faster and easier than ever, announcing the Public Preview of SQL database in Microsoft Fabric. This new simple, autonomous and secure, and optimized for AI service will help you in the era of AI, where 1 billion new apps are estimated to be built in the next 5 years, and 87% of leaders believe AI will give their organizations a competitive edge. With operational databases coming to Fabric, Fabric is evolving from an analytics platform to a data platform and the data layer of the AI and Copilot stack. SQL database in Fabric ...
RAG with SQL Vector Store: A Low-Code/No-Code Approach using Azure Logic Apps
Data is at the heart of every AI application, and efficient data ingestion is critical for success. With over 1,400 enterprise connectors, Logic Apps offers unmatched access to a diverse range of systems, applications, and databases, whether hosted in the cloud or on-premises. These connectors give businesses the flexibility to keep their data where it resides while seamlessly powering AI experiences. By leveraging Azure Logic Apps' native capabilities, organizations can implement the Retrieval-Augmented Generation (RAG) pattern, enabling straightforward ingestion and retrieval of data from multiple sources to...
Exciting Announcement: Public Preview of Native Vector Support in Azure SQL Database!
Public Preview of Native Vector Support in Azure SQL Database We are excited to share that the dedicated vector data type in Azure SQL Database, which was previously available through the Early Adopter Preview, is now transitioning to Public Preview! As of today, the Vector data type and its associated functions are accessible to everyone, automatically and seamlessly. You can start using them immediately in any Azure SQL Database you currently have or will create in the future. Azure SQL MI will move to Public Preview in the next months: stay tuned for more details! SQL Database as a Vector Store: With th...
Soccer Analytics Copilot with Azure SQL and OpenAI
The Football (aka Soccer in US 😀) Analisys Copilot provides an intuitive interface for users to interact with complex football data without needing advanced technical skills. By utilizing natural language processing, users can ask questions and retrieve detailed insights from vast datasets, including competitions, matches, teams, players, and events. This makes data exploration accessible to analysts, coaches, and fans who may not be familiar with coding or database queries, enabling them to gain valuable information through simple conversations with the chatbot. Through this interactive platform, users ca...
The ultimate chatbot?
RAG - Retrieval Augmented Generation - is by far one of the most common patterns today as it enables the creation of chatbots that can chat on your own data, as I described in my previous "Retrieval Augmented Generation with Azure SQL" blog post. As soon as you start to use it excitement grows, as it provides a sort of a magical experience. Experience that unfortunately stops the moment you try to ask it question that requires the ability to extract data from a structured source, like a database, as RAG is great when dealing with unstructured data, like text. By integrating the RAG pattern alongside NL2SQL, wh...
Smart Resume Matching: Document RAG with Azure SQL DB & Document Intelligence
Hey Azure SQL enthusiasts! 👋 We had a hiring event last week, and as I was going through a stack of digital resumes, I thought, "There has to be an easier way to do this." That's when it hit me—why not use Azure SQL DB’s new vector data type to revolutionize our hiring process? Not only could we find the perfect candidate faster, but we could also identify key focus areas for the interview. It’s a win-win! So, buckle up because today, we’re diving into how Azure SQL DB’s vector capabilities can enable advanced resume matching. We’ll be using Azure Document Intelligence and Azure OpenAI to make this magic ha...
Build a chatbot on your own data in 1 hour with Azure SQL, Langchain and Chainlit
Chatbots are the hot topic lately, and now you can create them easily by downloading solutions like OpenWebUI, connect it to Ollama or any OpenAI compatible API, choose your favorite language model, and then run it. It just takes a few minutes and it's done. But building chatbots is not enough, you most likely want to build a chatbot on your own data. Luckly, the software ecosystem around AI and chatbot is growing every day, and today creating a chatbot that allow your users to chat with data stored in your database is very easy, thanks to libraries like LangChain, ChainLit and, of course, Azure SQL. To get...
EAP for Vector Support Refresh – Introducing Vector type
Latest update - 06 November 2024 Vector Support is now available as Public Preview! Read the announcement here: Public Preview of Native Vector Support in Azure SQL Database! Access to full documentation here: Vector functions. The new data type Not even 6 months ago we started the Early Adopter Preview vector data support in Azure SQL, and we got great feedback and a lot of enthusiasm about the feature. Developers are excited to be able to easily build AI-enabled solution using an enterprise ready, secure, scalable and proven platform like Azure SQL, without the need to move data outside the database for...