Azure

Switch IP addresses between two Azure VMs

Changing an IP address of Azure virtual machines isn’t a complicated task. Simply locate the VM in Azure Portal and change the IP of it. A little bit more complicated is the scenario when we would like to switch IP…
Azure

Dynamic Data Masking in Azure SQL

Dynamic Data Masking is available for Azure SQL Database as one of the main security features. There is more on Data Masking on Microsoft Docs. I don’t want to repeat all these technical details, but rather provide you with sample…
Azure

Backup and restore database in Azure Storage Account

Creating backups of user databases from an on-premise environment to Azure Blob Storage is an easy task. You need to configure Storage Account in Azure where your database backups will be sent. Then you can reference this newly created storage…
Azure

Linked Server from on-premise to Azure SQL Database

If there is a need to move data between local SQL Server instances (on-premise) and Azure SQL Databases we can use Azure Data Factory. But it isn’t the ideal solution all the time: it’s paid in some scenarios and not…
Azure Data Studio
Azure

Azure Data Studio

Azure Data Studio, formerly known as SQL Operations Studio, is a tool for basic SQL Server querying and administration on Windows, Mac-OS, and Linux. That it can be executed on other platforms then Windows is the main point why it…