Dinesh's Blog :::: Being Compiled ::::

Azure Synapse Serverless SQL Pool facilitates data exploration, transformations and data warehousing with multiple functionalities, allowing...

  *** This is the session I have done for Sri Lanka Data Community – Feb 2022 episode. This does not contain the entire event. With modern ...

This video discusses how to automate starting and stopping Azure Analysis Services using Azure Automation Account. Following are demonstrat...

Here is an Azure site built for showing updates related to Coronavirus - COVID-19, specifically for Sri Lanka. This has been designed ...

Here is the first video on Azure Databricks. This talks about; Why we need to Azure Databricks for processing data What is Azure Databr...

Here is my third video on Azure Data Factory. This video discusses and demonstrates; Why we need iteration in ETLs Lookup Activity For...

Here is another video on Azure Data Factory V2. This video explains how to create a Pipeline manually, using Author-Tab. This video discus...

Azure Data Factory has been enhanced significantly with V2 and its support on Cloud-ETL-and-ELT is excellent now. First version of it was ...

I made another video on Azure Data Lake, specifically on Azure Data Lake Analytics. This is a 40-minutes video and it discusses following i...

I have made a video on Azure Data Lake and Azure Data Lake Store and published in YouTube. This video explains What is Azure Data Lake, It...

I have written few posts on HDInsight and thought to make series of Video on it as well. Here is the first one, with this video, I discuss...

Once HDInsight cluster is configured, we generally use either the portal dashboard (Powered by Ambari) or a tool like PuTTY for executing...

If you have started working with Big Data, you surely need to check the Microsoft support on it via Azure platform - HDInsight service. HD...

I have written many articles on HDInsight Service which is an Azure service that allows us to provision Apache Hadoop Cluster and use it f...

I started writing on this long time back but had no way of completing it. My first post on this was  Azure SQL Data Warehouse - Part I - C...

I have written two posts on HDInsight + SSIS based on Azure Feature Pack and they speak about how to creating a HDInsight Cluster and proc...

Here is a modern interview question on SQL Server. In addition to general questions on administration and maintenance, Azure based questio...

You know that we can create multiple administrator accounts in SQL Server if it is a on-premises instance or an instance configured in a V...

Unless it is a contained database, we must create a login for connecting with SQL Server in order to access a database. Databases are acce...

As a part of my presentation, I had to show the integration between Azure Data Lake Store (ADL) and Azure SQL Data Warehouse (Azure DW), h...