There are multiple ways to populate data into Azure SQL DataWarehouse PAAS (Platform as a Service). The primary way is to use Polybase (with T-SQL) or Azure Data Factory. If you...
How to Upgrade to SQL Server 2016 from Earlier and Older Versions SQL Server 2016 comes with multiple components. Upgrade considerations for each one of them is different. Before...
Auditing Features in SQL Server 2016 and Azure SQL Database SQL Server auditing features allow you to track and log both server level events, as well as individual database...
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...
I have already spoken about High Availability for SQL Server deployed in an Azure VM. For SQL Server deployments in Azure VM’s (IAAS), you are entirely responsible for its...
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...
This post is about the Azure SQL Database Limitations. Azure SQL Database is a robust, one of a kind “Database as a Service” offering from Microsoft. It has some major...
Security is always a concern for Customers & Organisations when they thing about moving to the cloud. Azure provides new security paradigms and robust security at physical,...
Azure SQL Database Performance Tuning is an important topic even if the database does not need a dedicated DBA to manage and maintain. There are several automatic optimization...
In this post, I am going to talk about Performance Tuning Best Practices for SQL running on an Azure VM with key considerations. Understand the characteristics of running SQL...
