Introduction to Window functions Window functions operate on a set of rows and return a single aggregated value for each row. The term Window describes the set of rows in the database on which the function will operate. Window (or Read More …
Month: May 2020
Windows Azure IaaS vs. PaaS vs. SaaS
A lot of people who talk about getting started with Azure but don’t know where to begin. They think that Azure “is just Virtual Machines sitting in a data center somewhere”. But, as you’ll see, Azure has so much more Read More …
Azure SQL Database managed instance
Managed instance is a new deployment option of Azure SQL Database, providing near 100% compatibility with the latest SQL Server on-premises (Enterprise Edition) Database Engine, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises Read More …
Azure SQL (PaaS) Database or SQL Server on Azure VMs (IaaS)
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 …