What is Data Lakehouse? 👀

Data warehouses are systems that contain relational data from the past, where we perform data transformations or data cleaning with ETLs. Data warehouses commonly used to find answers to existing questions and to support decision processes.

Power BI & Synapse Part 5 — Conquering Cosmos DB !

In the final part of the series, learn how to leverage SQL API for Cosmos DB and Serverless SQL pool within Synapse Analytics to…

Azure Synapse SQL Server less Create facts and dimensions

Copy public data set and create Facts and dimensions

Power BI & Synapse Part 2 — What Synapse brings to Power BI table?

In the 2nd part of the series, learn what Synapse brings to a table for Power BI developers, and how you can leverage both tools to get an…

Azure Synapse Analytics End to End Machine learning — Model Development

Load the data from the data source in this case the sample dataset Data Processing (ETL) using Pyspark.ETL work done in conjunction with pyspark and Spark SQL dataframe

Azure Synapse Analytics SQL-OnDemand with Covid 19 Dataset

How to use Azure Synapse SQL on demand and do ETL

Geospatial big data performance tests with Cosmos DB...

Several reasons can let you move away from traditional spatial store and query engines like Microsoft SQL, PostgreSQL or Oracle. Here we present the geospatial query capabilities and performance of an alternative to these well-established relational databases (RDB), namely Azure Cosmos DB.

Databricks PySpark Type 2 SCD Function for Azure Synapse Analytics

Slowly Changing Dimensions (SCD) is a commonly used dimensional modelling technique used in data warehousing to capture the changing data within the dimension (Image 1) over time. The three most commonly used SCD Types are 0, 1, 2.

What are Dedicated SQL Pools in Azure Synapse Analytics

A Big Data Solution within Azure Synapse Analytics

Monitoring a PolyBase Load in Azure Synapse Analytics

In this article I will discuss how to monitor and debug a PolyBase Load in Azure Synapse Analytics using system views and custom views (user created) and some best practices I followed for PolyBase load using T-SQL (CTAS/INSERT) and ADF.

Model your Azure Synapse Analytics Data Warehouse

In this tutorial, I will discuss how to physically model an Azure Synapse Analytics Data warehouse while migrating from an existing on-premise MPP (Massive Parallel Processing)Data warehouse solutions like Netezza and Teradata.

What is Microsoft’s Azure Synapse Analytics?

Azure Synapse Analytics can be called the service of these two worlds in terms of technology, security and performance from a single point.

Manage your Workload in Azure Synapse Analytics dedicated pool

In this article I will discuss the different capabilities available in Azure Synapse Analytics for workload management.

Azure Log Analytics Custom Logs Dashboard For Synapse Analytics

In this article, we will send data/metrics from Azure Synapse Analytics to Azure log analytics workspace and build an alert and dashboard on top of it.

Azure Synapse Analytics Database CI/CD using Azure Function

In this article, I will discuss an Azure Database CI/CD approach using Azure Premium Function and Jenkins pipeline. I will only explain the architecture and the approach I took to implement the Database CI/CD pipeline.

Azure Synapse Analytics Database CI/CD using Azure Function

In this article, I will discuss an Azure Database CI/CD approach using Azure Premium Function and Jenkins pipeline. I will only explain the architecture and the approach I took to implement the Database CI/CD pipeline.

Azure Synapse Analytics CI/CD using GitHub

Azure Synapse Analytics CI/CD using GitHub. Connect Azure Synapse Workspace to GitHub. Continuous integration and delivery for Azure Synapse workspace with Synapse CI/CD tools in Azure DevOps.

Loading CSV data into Azure Synapse Analytics by using PolyBase

In this article, we load a CSV file from an Azure Data Lake Storage Gen2 account to an Azure Synapse Analytics data warehouse by using PolyBase. We will look at the detailed steps to carry out the loading procedure.

SQL On-Demand: An easier way to Query Data

About SQL On-Demand SQL On-Demand is an interesting feature that will make Query your Data a lot more easier. Synapse SQL on-demand (preview) is a serverless query service that enables you to run SQL queries on files placed in Azure Storage.

Top 10 Features in Azure Synapse Analytics Workspace

Azure Synapse Analytics is an end to end data platform that combines data warehousing, visualization, data science, and ETL / ELT processes all in one place. In this blog I am going to list out some of the Top features that makes Azure Synapse Analytics a very powerful tool.