SQL

In the previous post, we introduced you to how Azure Arc-enabled SQL MI provides High Availability based on the tier..

So far in this series of posts, you have been able to deploy and configure your newly provisioned Azure Arc-enabled..

“SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibilities with..

Now that we have our Azure Arc-enabled SQL Managed Instance deployed, potentially one of the most common tasks you will..

Managing and Maintaining a SQL Server environment is nothing new to most of you. You are probably used to managing..

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that..

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some..

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL..