Azure has two options for hosting SQL Server workloads in Microsoft Azure: Azure SQL Database: A SQL database native to the cloud, also known as a platform as a service (PaaS) database or a database as a service (DBaaS) that Read More …
DATA WORKFLOWS IN AZURE
TAKING AN END-TO-END LOOK FROM INGEST TO REPORTING! Introduction There are a lot of scenario’s where organization are leveraging Azure to process their data at scale. In today’s post I’m going to go through the various pieces that can connect Read More …
Error :4127 – At least one of the arguments to COALESCE must be a typed NULL
This error message is shipped with SQL Server 2005 and it occurs due to one of the nice functions namely COALESCE . Lets discus the cause and resolution for this error message. Let me explain this error in detail : Message Number: 4127 Severity Read More …
Data Conversion
In this article, we will convert text to number in multiple versions of SQL Server and will see the difference. I will use four different Data conversion functions (Convert, Cast, Try_Convert & Try_Cast) to convert Text to Number. Let me explain this with simple examples. Read More …
How to select minimum value from group in a table
Sometimes, you need to define window frame within the table on the basis of certain criteria, to pick up some specific data. Today, I was developing one report for my customer and the requirement was very simple, to find the Read More …
Azure Data & Analytics Implementation
Microsoft Azure Tool Stack for Data & AnalyticsThere are options! For example, I just stood up an Azure for Data & Analytics solution that has no logic apps, Azure function, event hub, blob storage, databricks, HDI, or data lake. The Read More …
Azure Data Factory (ADFv2) Parameter Passing (part -1)
Date Filtering I just had the pleasure of deleting in my blog backlog, three ADFv1 blog posts in the making. The arrival of Azure Data Factory v2 (ADFv2) makes me want to stand up and sing Handel’s Hallelujah Chorus. Yes, Read More …
Azure Databricks
How to Optimize all your Tables THE MANY SMALL FILE PROBLEM If you have ever worked with big data tooling it is very likely that you’ve encountered The Many Small Files Problem, where tools like Hive, Spark, etc. do not Read More …
C# Introduction
What is C# Programming Language? C# (pronounced as “C Sharp”) is a simple, modern, object-oriented and type safe programming language. C# language has it’s roots from the family of C languages such as C, C++ and it is mostly similar Read More …