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

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

Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database...

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

Everyone knows that SQL Server creates a Clustered Index  when we add a Primary Key  if there is no Clustered Index  already exist in the ...

Have you ever come across a situation where you have to design a dimension that has no attributes except the one explain the dimension its...

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