What is Azure Synapse Analytics? Complete Overview
This post provides an overview of the Azure Synapse Analytics. It explains what it is and how it...
Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio
I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW in my last article. AdventureWorks DW...
Azure SQL Elastic Pool – Understanding and Creating
Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload....
Introduction to Amazon QuickSight
Nowadays, companies are moving their infrastructure from on-premise devices to the cloud. There are...
How to Setup SQL Server on the Amazon RDS
SQL Server is one of the most popular databases used in modern applications. Over the past few decades, it has established itself as a...
How to Auto-trigger AWS Lambda Functions
When we think about a cloud solution provider, we often consider the most popular ones, i.e. Amazon Web Services, Microsoft Azure, and...
Introduction to Layers in AWS Lambda Functions
AWS Lambda is an event-driven, serverless cloud computing service provided by Amazon, a part of the...
How to Connect to Azure SQL Database Securely
As a database administrator, I started my journey in deploying managed SQL databases on the cloud, and I highly recommend deploying Azure...
Provisioning an Oracle Autonomous Database
Let’s assume that you are developing a data warehouse project, and your team needs the appropriate environment immediately and under the...
Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage
Let’s imagine you have a large raw file and need to determine the best way to load it into an...
