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 …
Day: May 11, 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 …