Showing results for T-SQL - Azure SQL Devs’ Corner

Mar 24, 2025
Post comments count0
Post likes count4

Secure APIs with Data API Builder, Keycloak, and SQL Server

Alessio Tugnoli
Alessio Tugnoli

In this article, we'll explore how to create a secure, on-premises API using Data API Builder (DAB), Keycloak, and SQL Server. You'll learn to set up JSON Web Token (JWT) authentication with Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC), and Row-Level Security (RLS), ideal for secure business scenarios. Want to replic...

Azure SQLRESTT-SQL
Feb 26, 2025
Post comments count4
Post likes count2

Exciting new T-SQL features: Regex support, Fuzzy string-matching, and bigint support in DATEADD – preview

Abhiman Tiwari
Abhiman Tiwari

We are thrilled to announce the public preview of three powerful T-SQL features that will elevate your SQL queries: Regular Expressions (Regex) support, Fuzzy string-matching, and bigint support in DATEADD. These enhancements are now available in Azure SQL Database and SQL Database in Microsoft Fabric, offering developers more flexibility, efficien...

Azure SQLT-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 12, 2024
Post comments count0
Post likes count1

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

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
Sep 25, 2023
Post comments count0
Post likes count1

Generate images with Azure OpenAI Service (DALL-E) and Azure SQL Database

Brian Spendolini
Brian Spendolini

Following on the series of OpenAI posts I have done recently, here is a quick how-to on using DALL-E with External REST endpoint invocation in the Azure SQL Database. Using the OpenAI service in Azure, we can use the image generation REST endpoints to create new and wonderful images such as, if you remember, the cat in the data center. So ho...

Azure SQLOpenAIREST
Aug 28, 2023
Post comments count0
Post likes count3

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
Aug 7, 2023
Post comments count2
Post likes count0

Summer 2023 Update for Azure SQL Database External REST Endpoint Invocation

Brian Spendolini
Brian Spendolini

Summer 2023 REST Endpoint Invocation Update Welcome to the Summer 2023 REST Endpoint Invocation update post! This summer, we updated the External REST Endpoints Invocation feature with a few key fixes and additions to help you use more Azure Services with your Azure SQL Database. The feature was released to public preview last year and this late...

Azure SQLRESTREST Endpoint Invocation
May 17, 2023
Post comments count0
Post likes count2

Model your Supply Chain in a Graph Database | Part 3

Jerry Nixon Arvind Shyamsundar
Jerry,
Arvind

In Part 3 of our series, we delve into the rewards that graph databases bring to supply chain modeling. We explore the clarity achieved through the MATCH keyword, enabling precise communication between technical and business teams. Validation becomes seamless as stakeholders intuitively analyze the graph, uncovering missing relationships and enrich...

Azure SQL
May 17, 2023
Post comments count0
Post likes count2

Model your Supply Chain in a Graph Database | Part 4

Jerry Nixon Arvind Shyamsundar
Jerry,
Arvind

In Part 4 of our series, we explore the power of graph visualization in understanding and analyzing supply chain data. Using tools like PowerBI and the force-directed graph visual, we transform our SQL Graph data into an interactive and shareable format. The visualization allows us to easily comprehend the relationships within the supply chain, mak...

Azure SQL