Write Line The Console.WriteLine() method is used to print text to the console. It can also be used to print other data types and values stored in variables. Variables and Types In C#, a variable is a way to store data in Read More …
Part 1: Hello World
Read Line The Console.ReadLine() method is used to get user input. The user input can be stored in a variable. This method can also be used to prompt the user to press enter on the keyboard. C C# is a general-purpose, type-safe, object-oriented programming Read More …
CSS Cheat Sheet
Selectors Universal Selector * {} ID Selector #id {} Class Selector.class {} Type Selectorh1, h2 ,h3 {} Adjacent Sibling Selectorh1 + p {} Child Selectorul > li {} General Sibling Selectorh1 ~ p {} Descendant Selectorp a {} Attribute Selectordiv[attribute=”SomeValue”] Read More …
HTML Cheat Sheet
This cheat sheet – or HTML code quick reference – lists the common HTML tags and their attributes, grouped into relevant sections in an easy-to-read format. Basic HTML Structure Common Tags for Blogs<h?> heading </h?>Heading (h1 for largest to h6 Read More …
Introduction to HTML and CSS
This tutorial teaches you the basics of HTML and how to build your first website. That means how to layout an HTML page, how to add text and images, how to add headings and text formatting, and how to use tables. Read More …
Data Factory Ingestion Framework: Part 1 – Schema Loader
Use Case A business wants to utilize cloud technology to enable data science and augment data warehousing by staging and prepping data in a data lake. There are multiple different systems we want to pull from, both in terms of Read More …
SSIS 2016: An efficient way to handle transform and load of SCD2
Quick Review:This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in SSIS expiring the current row and inserting a new dimension table row like this –> SSIS comes Read More …
T-SQL TO U-SQL DATA TYPE CONVERSION
When working with code generated solutions we often need to convert datasets from SQL Server (T-SQL) data types to Azure Data Lake Analytics (U-SQL) data types. As you probably know U-SQL has a hybrid syntax of T-SQL and C# which Read More …
Part 9: Extending U-SQL
There are 5 kinds of User-Defined entities in U-SQL User-Defined Functions (UDFs)User-Defined Types (UDTs)User-Defined Aggregators (UDAggs)User-defined Operators (UDOs)User-Defined Appliers All of them are defined by .NET code. C# is not required. Any .NET language will work. User-Defined Functions User defined functions are normal static methods on a .NET Class. Read More …
Part 8: Set operations and Joins
Set operations are a way of merging rowsets together based on set theoretic operations such as union (UNION). intersection (INTERSECT), complement (EXCEPT). Sample data Let’s define two RowSets: @a and @b. Notice that both RowSets have duplicate rows. UNION UNION combines two rowsets. UNION Read More …