Azure

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...

Featured

Direct Links To Download SQL Server Sample Databases

Introduction to SQL Server Sample Databases To get started with Microsoft SQL Server for demonstrations & training you need some sample databases to play with. There are many...

Featured

Best Practices for Configuring SQL on Azure IaaS VM

Best Practices for Configuring SQL on Azure IaaS VM Running SQL Server workloads on Azure as IAAS (Infrastructure as a service) is becoming popular. With more SQL Servers running...