Skip to content

Kloudspro

  • Home
  • Quick Links
    • Microsoft Certifications
    • Azure Portal
    • Azure Data Factory
    • Power BI Service
    • Azure Data Centers
    • Azure Pricing Calculator
    • Azure Database Migration Guide
    • Microsoft Bug Bounty Program
    • Databricks Community Edition

Tag: Azure SQL Database

Azure SQL Hyperscale Tier – Next Milestone

November 29, 2020 Parry M.

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

Continue reading

A Practical Guide to Table Partitioning in Azure SQL Database

November 19, 2020 Parry M.

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

Continue reading

Case Study: Choosing The Right Offering, Model and Tier for Azure SQL Database

November 10, 2020 Parry M.

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

Continue reading

Script to Check Size of Each Table

November 9, 2020 Parry M.

If you want to get the size of each table in each database on the instance, run the following script – Below part of the

Continue reading

How to Check Actual Row Size in SQL Server

November 9, 2020 Parry M.

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

Continue reading

Unique Comparison – DTU vs. vCore Based Model

November 4, 2020 Parry M.

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,

Continue reading

Automatic Tuning – Azure SQL Database & Managed Instance

October 20, 2020 Parry M.

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

Continue reading

On-Premise to Azure SQL Database Migration

October 17, 2020 Parry M.

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

Continue reading

A Practical Guide to Failover Groups

October 15, 2020 Parry M.

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

Continue reading

A Practical Guide to Active Geo Replication

October 13, 2020 Parry M.

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

Continue reading

Azure SQL Database Hyperscale Tier

August 25, 2020 Parry M.

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

Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Search what you are looking for

Read this blog in your own language

Advertisements
  • Home
  • Quick Links
Create a website or blog at WordPress.com