Install Azure CLI 2.0 on Microsoft Windows

Total: 1 Average: 5

Azure CLI is a Microsoft cross-platform tool that allows users to remotely access Azure services via their command line. The current article will describe installing Azure CLI 2.0 on Windows. However, before we go to perform this task, we’ll briefly review what Microsoft Azure is, what services it provides, and how to sign up with Microsoft Azure.

Let’s begin without ado.

Read More

Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms

Total: 1 Average: 5

This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an HTML5 table inside an ASP.NET webform. Additionally, it touches on the question of using CSS3 (cascading style sheets) to apply a style to the HTML5 table in an ASP.NET webform.

Let’s begin.

Read More

Data Visualization in Microsoft Power BI

Total: 1 Average: 5

Contents

  1. Introduction.
  2. How to create a table.
  3. How to create a Power BI pie chart.
  4. Creating a line chart in Power BI.
  5. Report creation.
  6. Conclusion.

Introduction

The final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.

Read More

Analytic Functions in SQL Server

Total: 10 Average: 4.8

Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average that return scalar values, analytic functions return a group of rows that can be further analyzed. In this article, we will see some of the most commonly used analytic functions in SQL server. We will be discussing the following functions:

  • CUME_DIST
  • FIRST_VALUE
  • LAST_VALUE
  • LEAD
  • LAG

Read More