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

If you are interested in #covid-19 statistics, check this #dashboard out. This has been developed using #powerbi, #azuresqldatabase and #az...

This video discusses the way of accessing Azure Data Lake Gen 2 through Azure Databricks, using Azure Active Directory Credentials. Followi...

This video discusses the ways of accessing Azure Data Lake Gen 2 in Azure Databricks, specifically using a Service Principal. Following are...

This video focuses on sending emails for operations related to Azure SQL databases. Following are discussed and demonstrated; Possibilit...

This video discusses performing data science experiments in SQL Server using Python. Setting up the environment, training, storing models a...

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 a video on Power BI Paginated reports. This videos discusses/demonstrates; What is a paginated report? Power BI support on pagi...

This video discusses the way of accessing external data sources such as Azure SQL Database with USQL as external data sets. It explains why...

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...

In order to access Excel workbook using Integration Services, one component we need to install is Microsoft Access Database Engine 2016 Re...

As you know, easiest way of getting a SQL Server set up in Azure is, purchasing a Virtual Machine in the Marketplace. There are multiple V...

I had a table with 3.5 billion records and wanted to update one column in all records. This table was not partitioned though the design sa...

Here is my second video related to Always Encrypted. This video discusses the way of configuring CMK for serving multiple applications hos...

Here is my second video that speaks about Always Encrypted feature. This video shows How Always Encrypted works, how it should be configure...

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...

Author: Acuity Training - Training Provide for Excel Business Intelligence   Understanding Business Intelligence There was a time ...

Everyone knows that SQL Server started supporting CREATE OR ALTER  statement with SQL Server 2016 and it can be used with few objects. How...

Can this be happened? The functions TRY_CONVERT and TRY_CAST have been designed for handling errors and they should return NULL when the...

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