Tag: sql

Using CASE Expressions in SQL Server

Kenneth Igiri Leave a comment
Total: 1 Average: 5

Introduction

CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion or simple queries. Use cases for such commands are various.

For instance, there is a column containing the department code, but you wish to display the department’s name rather than the code. You could achieve it by doing a JOIN with another table containing the department details. However, let’s assume you want to keep the query relatively simple. Another use case would be returning specific values for the computed values set. Computed columns would not fit if the sets of conditions to specify are not the same.

Read More

Data Visualization in Microsoft Power BI

Ben Richardson Leave a comment
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

Loading and Managing Data within Microsoft Power BI

Ben Richardson Leave a comment
Total: 2 Average: 5

Contents:

  1. Introduction
  2. Importing data from Excel, SQL Server, and the Web.
    1. Importing data from Excel into Power BI.
    2. Importing websites into Power BI.
    3. Importing data from SQL Server Database into Power BI.
  3. Data Manipulation Basics in Power BI.
    1. Group By option.
    2. Splitting columns.
    3. Duplicating columns.
    4. Combining columns.
  4. Managing relationships within Power BI.
    1. Merging/Joining datasets.
    2. Model views/Relationship link.
    3. Hierarchies.
  5. Conclusions.

Introduction

This article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.

Read More

Completing SQL. Part 3: Complementing SQL. The life of Visual Studio extensions. Working with IO. Using SQL in unconventional ways.

Andrey Podkolzin Leave a comment
Total: 21 Average: 3.8

What is this article about?

This is the third article in the series of articles on the life of IDE developers for databases.

Its structure will be similar to the first one and the second one, even so, I am not going to tell you about the parsing of text. This article will present information on some tricks working with files and various problems of creating a big desktop application on the .NET platform.

Read More

Completing SQL. Part 2: Optimizing string processing and file opening

Andrey Podkolzin Leave a comment
Total: 22 Average: 4

What is this article about?

This is the second piece from the series of articles about the life of database IDE developers. Its structure is similar to that of the previous article. Just like in the first one, I’ll talk about the issues we faced and the solutions we arrived at – both effective and not so much. To understand this article, you don’t have to read the first part in its entirety, but the first few paragraphs would be useful to help you grasp the context.

Read More

Best SQL Tools for Database Developers and Administrators

Evgeniy Gribkov Leave a comment
Total: 21 Average: 3.8

For a SQL database developer, it is essential to have the necessary SQL tools in hand, which enable to reduce the development time of given functionality. The same is true for the tester. For a database administrator, it is also important to have monitoring tools.

In this article, we are going to look at some MS SQL Server development and monitoring tools, such as:

Read More