Azure SQL Dev Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
Winter 2023 Service Update for External REST Endpoint Invocation
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 endpoints other than just search; the endpoints include autosuggest, image search, news search, and spell check to name a few. Search Let's start with a regular search example. In this code example and external REST endpoint Invocation, we are going to call the search endpoi...
Data API builder 0.9.7 Released
There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don't want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what's going on behind the scenes. Enable Application Insights when self-hosting DAB Logs can now be streamed to Application Insights for a better monitoring and debugging experience, especially when Data API builder is deployed in Azure. A new  section can be added to the configuration file to enable and configure integration wi...
Announcing New Lower Price Tier for Cloud Native Applications on Azure SQL
Today we are announcing a new pricing tier for Azure SQL Database targeted at developers building cloud native applications. It is based on Azure SQL Database Hyperscale tier, which offers awesome cloud scalability with one of the lowest TCO in the industry. Azure SQL Database Hyperscale delivers outstanding performance and scalability through adaptive, cloud native resource management, optimized for the workload patterns of each database application. Hyperscale storage scales automatically, providing consistent performance at all scales. Azure SQL Database Hyperscale provides the best database capabilities t...
Vector Search with Azure SQL Database
With public preview of integrated vectorization, a ground-breaking capability of vector search in Azure AI Search (previously Azure Cognitive Search), you can do vector search with data stored in Azure SQL Database easily. This feature is designed to streamline the process of chunking, generating, storing, and querying vectors for vector search in Azure AI Search. This feature significantly speeds up the development of the vectorization pipeline and minimizes maintenance tasks during data ingestion and query time. It paves the way for seamless integration of vectors into your applications with traditional search ...
Azure SQL Database Elastic Jobs preview refresh
We are very excited to announce a significant “refresh” to the current Azure SQL Database Elastic Jobs preview! This refresh brings several new capabilities that were highly requested by our customers during the current preview. Main new capabilities added in this refresh include: Azure portal has also been significantly enhanced to provide new experience and support these new capabilities. For more details see my Azure SQL Blog
Build your API with DAB. Build your client with Kiota!
Project Kiota is a code generation engine from Microsoft that reads the OpenAPI specification emitted from any REST endpoint and then creates reusable client code in CSharp, Go, Java, PHP, Python, Ruby, Swift, and TypeScript. Kiota is a byproduct of Microsoft Graph, a sophisticated REST endpoint that required developers to write boilerplate code over and over - but not with Kiota. In the same way that the Data API builder (DAB) says, "Don't waste your time writing API code for your data," Kiota says, "Don't waste time writing client code for your API." A perfect friendship of technologies. Build your API wit...
OpenAPI for your Azure SQL database
A recent and exciting feature of Data API builder (you may have learned about Data API builder from my previous article, as I used it to quickly make a stored procedure and a table available as REST endpoint to easily integrate with OpenAI) is the compatibility with OpenAPI specifications and Swagger. This was a highly demanded feature, and it is impressive to see it in action. You can quickly transform your database tables, views or stored procedures into standard, modern, scalable, REST endpoints that are accessible to everyone. For this example, in just a few minutes, I converted the AdventureWorksLT sample d...
How I built a session recommender in 1 hour using Open AI
As a developer, I often attend conferences to learn new skills and network with other professionals. However, conferences can be overwhelming, especially when they offer dozens of sessions on different topics. How can I decide which ones are worth my time and attention? That's why I decided to use OpenAI to create a tool that can help me find the most relevant sessions for my interests. I used the session abstracts of a conference as input and converted them into embeddings using OpenAI's natural language processing capabilities. Then, I used vector search to compare the embeddings with a query topic and rank th...
Creating a Kubernetes Application for Azure SQL Database
Creating a Kubernetes Application for Azure SQL Database Buck Woody, Principal Applied Data Scientist, Microsoft Modern application development has several challenges. From selecting a "stack" of front-end through data storage and processing from several competing standards, through ensuring the highest levels of security and performance, developers are required to ensure the application scales and performs well and is supportable on multiple platforms. For that last requirement, bundling up the application into Container technologies such as Docker and deploying multiple Containers onto the Kubernetes plat...