Showing results for Azure SQL - Azure SQL Devs’ Corner

May 22, 2025
Post comments count0
Post likes count0

New AI Features in SQL Server 2025

Brian Spendolini
Brian Spendolini

We have some great new AI Features in SQL Server 2025. I also figured a video would be better than reading a blog.... https://www.youtube.com/watch?v=dDJheVYgeVo but, you can also read all about it here.

AIAzure SQLT-SQL
May 21, 2025
Post comments count0
Post likes count1

MSSQL Extension for VS Code: Introducing Schema Designer (Preview)

Yo-Lei Chen
Yo-Lei Chen

Overview Database design can often feel like navigating a maze of tables, relationships, and data types — especially when working directly with T-SQL scripts. But what if you could map out your database, make changes to your tables, and manage complex schemas within a graphical interface? We are excited to announce the Public Preview of Schema De...

Azure SQLVisual Studio CodeVS Code
May 19, 2025
Post comments count7
Post likes count0

Announcing the General Availability (GA) of JSON data type & JSON aggregates…

Umachandar Jayachandran (UC)
Umachandar Jayachandran (UC)

We are excited to announce the General Availability (GA) of the native JSON data type and JSON aggregates - JSON_OBJECTAGG & JSON_ARRAYAGG. You can use the JSON data type and JSON aggregates to integrate and work with JSON documents more efficiently in the database. This functionality is available in Azure SQL Database, Azure SQL Managed Instan...

Azure SQLT-SQL
May 19, 2025
Post comments count2
Post likes count1

Unlocking the Power of Regex in SQL Server

Abhiman Tiwari
Abhiman Tiwari

Regular expressions, or regex, are powerful tools for text manipulation and pattern matching. They are incredibly useful in various scenarios, such as data validation, extraction, and transformation. SQL Server 2025 introduces native support for regex functions, making it easier to perform complex text operations directly within SQL queries. This R...

Azure SQLT-SQLManaged Instance
May 19, 2025
Post comments count0
Post likes count2

MSSQL Extension for VS Code: New UI Goes GA and GitHub Copilot Enters Preview

Carlos Robles
Carlos Robles

The SQL development experience is taking a major leap forward with the MSSQL Extension for VS Code. The MSSQL extension is evolving to meet the needs of modern developers, bringing powerful, intelligent, and intuitive capabilities directly into your daily workflow. With this release, we’re announcing the general availability of the enhanced UI and...

VS CodeAzure SQLSQL database in Fabric
May 8, 2025
Post comments count2
Post likes count2

Avoid T-SQL anti-patterns with the free T-SQL analysis tool

Erik Ejlskov Jensen
Erik Ejlskov Jensen

T-SQL Analyzer is a free, open-source, cross platform command line tool for identifying, and reporting the presence of anti-patterns and design issues in SQL Server T-SQL scripts. As a database developer, you can catch any potential bad practices and design problems very early in the project process - this ensures a frictionless path to deploym...

T-SQLAzure SQL.NET
May 6, 2025
Post comments count1
Post likes count2

Efficiently and Elegantly Modeling Embeddings in Azure SQL and SQL Server

Davide Mauri
Davide Mauri

Storing and querying text embeddings in a database it might seem challenging, but with the right schema design, it's not only possible, it's powerful. Whether you’re building AI-powered search, semantic filtering, or recommendation features, embeddings, and thus vectors, are now a first-class data type. So how do you model them well inside a databa...

Azure SQLAIVectors
Apr 30, 2025
Post comments count3
Post likes count2

MSSQL Extension for VS Code: Introducing Schema Compare (Preview)

Tauseef Siddique
Tauseef Siddique

Overview We are excited to introduce Schema Compare in the MSSQL Extension for VS Code! It can be tedious to manually manage and synchronize different database versions. Enter Schema Compare, the powerful new feature for MSSQL in VS Code that transforms this tedious task into a seamless experience. With intuitive visualization that instantly hi...

VS CodeAzure SQLVisual Studio Code
Apr 21, 2025
Post comments count1
Post likes count1

Predictable LLM results with Structured Output and sp_invoke_external_rest_endpoint

Davide Mauri
Davide Mauri

OpenAI recently introduced a powerful new feature for developers: structured output using JSON Schema via the parameter. This makes it possible to request responses from a GPT-4o model that strictly match a given schema—no free-text, no guesswork. If you're working with Azure SQL, this is a game-changer. Combined with the stored procedure and SQ...

Azure SQLAI
Mar 27, 2025
Post comments count0
Post likes count2

SQL Conf() 2025 Highlights: So Much Developer Innovation!

Jerry Nixon
Jerry Nixon

For decades, SQL Server has been a cornerstone of data management, evolving to meet the needs of modern developers. What began as a traditional relational engine is now a cloud-enabled, AI-integrated platform designed for building real-world applications. SQL Server continues to meet developers where they are—offering tools, services, and capabilit...

Azure SQLAIVectors