Overview Clauses such as SELECT, WHERE, and HAVING (among others) allow you to enter U-SQL expressions. An expression in a programming language is a combination of explicit values, constants, variables, operators, and functions that are interpreted according to the particular rules of precedence and Read More …
Author: Kenneth_pro_
Part 3: Parameters and Data Types
The DECLARE statement allows us to define parameters to store values for things that aren’t RowSets. We’ll start with this snippet DECLARE can assign constant values to a name. In this case we can assign the input file to a parameter. Parameter values Read More …
Part 2: Transforming RowSets
In this chapter you’ll focus on the fundamental ways in which rowsets can be created and modified. Creating a RowSet from another RowSet Effectively this script just copies the data without transforming it. However, if you look at the output Read More …
Part 1: Introduction to U-SQL
In this blog you will master the mechanics of running U-SQL on your own box with Visual Studio. You will also get familiar with basic U-SQL concepts. If you come from a SQL background, you’ll notice that U-SQL queries look Read More …
Window Function In SQL Server
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 …
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 …