How to configure Fail-over and Geo-Replication for Microsoft Azure Database

In this article, I would like to instruct you how we use Geo-Replication to set High Availability up for Microsoft SQL Azure Database. Prerequisite condition The following article gives some basic steps to create a SQL Database in Microsoft Azure Introduction Active Geo-Replication is Azure SQL Database feature that allows you to create readable replicas … Continue reading How to configure Fail-over and Geo-Replication for Microsoft Azure Database

Advertisements

How to create a Pipeline to load a text file to Azure SQL Database with Azure Data Factory

In this article, I would like to instruct you the way how to load a text file to Azure SQL Database that you created with Azure Data Factory. See the following articles before going ahead How to create Storage Account? How to create SQL Database? How to upload a file to Storage Accounts? For demo … Continue reading How to create a Pipeline to load a text file to Azure SQL Database with Azure Data Factory

How to fix “Invalid object name OPENJSON” in SQL Server 2016

Situation Microsoft introduced a great feature in SQL Server 2016 that support JSON data. However, you can get the error Invalid object name OPENJSON when you work on databases that their compatibility level are lower than 130.   Solution To fix this error, you need to update your database compatibility to 130 ALTER DATABASE <Database … Continue reading How to fix “Invalid object name OPENJSON” in SQL Server 2016