A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Convert all SQL Server database logic entries into PostgreSQL format, including stored procedures, functions, triggers, and views. Perform functional and performance tests to verify the resulting ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability.

SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs.

I want to call a user defined SQL SERVER function and use as parameter a property that is a value object. The EF Core documentation shows only samples with primitive types. I can't manage to create a ...

Manuel string split function create Create a table value function. As a parameter, the main string @s variable and the searched variable @d to be made on the basis of fragmentation were created.

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.