Posts by this author

May 19, 2025
Post comments count2
Post likes count1

Unlocking the Power of Regex in SQL Server

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
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

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
Jan 20, 2025
Post comments count0
Post likes count0

Extending Regular Expressions (Regex) Support on Azure SQL Managed Instance (MI)

We are happy to announce the Private Preview of Regular Expressions (Regex) support on Azure SQL Managed Instance (MI). This new feature brings powerful text processing capabilities to your SQL queries, enabling you to perform complex pattern matching and data manipulation with ease.  Regex support in Azure SQL The Regex feature in Azure SQL foll...

Azure SQLT-SQL
Jun 4, 2024
Post comments count0
Post likes count1

Announcing UNISTR and || operator in Azure SQL Database – preview

We are excited to announce that the UNISTR intrinsic function and ANSI SQL concatenation operator (||) are now available in public preview in Azure SQL Database. The UNISTR function allows you to escape Unicode characters, making it easier to work with international text. The ANSI SQL concatenation operator (||) provides a simple and intuitive way ...

Azure SQLT-SQL
Mar 22, 2024
Post comments count8
Post likes count8

Introducing Regular Expression (Regex) Support in Azure SQL DB

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
Nov 14, 2022
Post comments count0
Post likes count1

Maximizing Azure SQL Database performance with a globally distributed Redis write-behind cache

Azure SQL Database is a fully managed platform as a service (PaaS) relational database service. With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to proc...

Azure SQL.NETRedis
Apr 27, 2022
Post comments count9
Post likes count0

Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database

We are excited to announce the general availability (GA) of change data capture (CDC) in Azure SQL Database. What is Change data capture (CDC)? CDC provides historical change information for a user table by capturing both the fact that Data Manipulation Language (DML) changes (insert / update / delete) were made and the changed data. Changes are ...

Azure SQL
Mar 2, 2022
Post comments count0
Post likes count1

Create REST API in Python with Django, using the Django REST Framework and Azure SQL

Django is a Python-based open-source web framework. It is a popular and well-liked web framework among developers all around the world. But wouldn't it be amazing to build a website with Django while also taking advantage of Azure SQL database's security, performance, high availability, and other great capabilities? In this article, we will crea...

Azure SQLPython
Feb 8, 2022
Post comments count0
Post likes count1

Saving Bot Activities in Azure SQL Database

In this blog post, we’ll walkthrough of how to integrate Bot Framework v4 SDK with Azure SQL Database and save Bot activities/ conversations into the database. We’ll leverage Bot.Builder.Community.Storage.EntityFramework package to save conversations using EntityFrameworkTranscriptStore with TranscriptLoggerMiddleware into Azure SQL Database. ...

Azure SQL