Azure

Featured
Exporting SSRS Key to Azure Key Vault

Exporting SSRS Key to Azure Key Vault for Scale-Out Deployments

You will have to agree that managing so many encryption keys for SQL Server could be a tedious job. With Azure Storage Value, storing and distributing keys is even more...

Featured
BYOL SQL License to Existing Azure VM

How to Apply BYOL SQL License to Existing Azure VM on Cloud IAAS

In case if you are looking to apply BYOL SQL License to Existing Azure VM, then this post is for you. If you or your customer have an Enterprise Agreement or Software Assurance...

Featured
SQL Server Analysis Services Performance Tuning on Azure Virtual Machines

SQL Server Analysis Services Performance Tuning on Azure Virtual Machines

In this post, we will be covering SQL Server Analysis Services (SSAS) Performance tuning best practices on Azure with a bit of detail. Do note that we are referring to running...

Featured
Azure SQL Data Sync Limitations

Azure SQL Data Sync Limitations Pricing and Alternatives

Before we talk about the Azure SQL Data Sync Limitations, we will need to understand the prerequisites first. The Azure Data Sync has been around for a while (October 2011), and...

Featured
Restore Azure SQL Database

How To Do Point In Time Restore of Azure SQL Databases From Backups

If you have your Databases hosted on Microsoft’s Azure cloud service, you can breathe easy. Microsoft automatically takes backups of all your databases. It is a part of...

Featured
How to Upgrade to SQL Server 2016 from Earlier and Older Versions

How to Upgrade to SQL Server 2016 from Earlier and Older Versions

Upgrading to the latest edition of SQL Server could be a breeze if planned properly. It is important to take note of all the SQL Server related services that need to be migrated....

Featured
Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database

As a part of the robust security options provided by SQL Server, it also provides fine-grained auditing both on-premises and on the cloud. In this post, we would be exploring the...

Featured

How to Replicate your Data to an Azure VM with SQL Standard

How to Replicate your Data to an Azure VM with SQL Standard SQL Server Standard is undoubtedly one of the best selling editions due to its cost effectiveness and feature sets. Its...

Featured

How to Backup your Azure SQL Database

How to Backup your Azure SQL Database I have already spoken about High Availability for SQL Server deployed in an Azure VM. For SQL Server deployments in Azure VM’s (IAAS),...

Featured

How to Run Failover Clustering FCI in Azure Virtual Machines IAAS

How to Run Failover Clustering FCI in Azure Virtual Machines IAAS Till recently, SQL Server Always On Availability Groups were the only Cluster based High Availability option...