Couple of months ago, we wrote an introductory article about Hyperscale tier of Azure SQL Database. As we have discovered more about it so we
Tag: Azure SQL Database
A Practical Guide to Table Partitioning in Azure SQL Database
As this post is more about the practical stuff so assuming that you are familiar with partitioning’s basic concepts and let’s quickly jump to the

Case Study: Choosing The Right Offering, Model and Tier for Azure SQL Database
Requirement: A relational data store needs to be provisioned on Azure specifically on SQL Server platform. Problem Statement: There are multiple offerings by Microsoft in
Script to Check Size of Each Table
If you want to get the size of each table in each database on the instance, run the following script – Below part of the
How to Check Actual Row Size in SQL Server
We were doing some capacity estimation for one of the clients today to forecast their storage requirements for SQL Server database on Azure. While this

Unique Comparison – DTU vs. vCore Based Model
Assuming that you already have a basic understanding of what DTU is and the availability of vCore based model while choosing Azure SQL database offering,
Automatic Tuning – Azure SQL Database & Managed Instance
Azure SQL Database and Azure SQL Managed Instance both are Azure’s PaaS implementations whereby Microsoft takes care of all management tasks of underlying systems. Automatic
On-Premise to Azure SQL Database Migration
Starting from scratch on cloud platform is quite easier when you need to setup a database say on Azure but the moment discussions start happening
A Practical Guide to Failover Groups
Note: Practical guide here doesn’t mean a step-by-step approach to setup the service/feature but to mention the important points which are critical to understand for
A Practical Guide to Active Geo Replication
Active Geo Replication is a database-level feature specific to Azure SQL Databases. It creates a secondary replica of your primary database which can be used
Azure SQL Database Hyperscale Tier
Hyperscale service tier is available for single databases that are using vCore-based purchasing model. But, before you start thinking much about this tier, let’s first