Azure

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

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

Featured
Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database SQL Server auditing features allows you to track and log both server level events, as well as individual database...

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

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), you are entirely responsible for its...

Featured
How to Run Failover Clustering FCI in Azure Virtual Machines IAAS

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
Azure SQL Database Limitations

Azure SQL Database Limitations

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

Featured

How to Secure Azure SQL Database

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

Featured
Azure SQL Database Performance Tuning

Azure SQL Database Performance Tuning

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

Featured
Best Practices for SQL on Azure VM

Performance Tuning Best Practices for SQL on Azure VM

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

Featured
SQL Server 2014 Core Licensing

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

FOLLOW @ INSTAGRAM