Last week we evaluated Azure Synapse Analytics workspace for our new venture and any time we explore a new service on Azure, analyzing the cost
Month: November 2020
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
Azure Machine Learning Algorithm Cheat Sheet
Key points about understanding the cheat sheet – The suggestions in the cheat sheet are approximate rules-of-thumb This cheat sheet is intended to suggest a
Executing Azure Databricks Notebook from Azure Data Factory (ADF)
Executing or calling an Azure Databricks Notebook within ADF pipeline is quite easy. There is an in-built activity called “Notebook” available there under the Databricks
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,
ADF Daylight Saving Support in Scheduled Triggers
As Azure Data Factory now supports time zones other than UTC while creating scheduled triggers, it gives you the flexibility to handle the daylight saving
