Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage

Cloud, Database administration, Database Optimization & Structure

Let’s imagine you have a large raw file and need to determine the best way to load it into an...
Read More

LINQ in C#: A tutorial with Query Examples in LINQ to Objects

Basics of C#, Languages & Coding

Less is more – this is definitely true when it comes to object collections and LINQ queries. One of the most valuable advantages is the...
Read More

Create and Use Custom Date Hierarchies in Power BI

Microsoft Power BI

Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the...
Read More

Creating the Date Table in Power BI Desktop Using DAX Function

Business intelligence, Power BI

The time intelligence functions for the data models or databases running behind a Power BI report...
Read More

How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent

Azure, Cloud, Tools & technologies

What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face numerous challenges, but the most...
Read More

SQL Server TRIM, LTRIM, and RTRIM Functions

Database development, Statements

The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a character string. A leading space is...
Read More

SQL Server Business Intelligence Explained: Tools, Techniques and Trends

Business intelligence, Power BI

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts...
Read More

SQL Date Format: How to Handle It the Smart Way

Database administration, Work with data

Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
Read More

SQL CASE: Know and Avoid 3 Lesser-Known Hassles

Database development, Statements

SQL CASE? Piece of cake! Really? Not until you bump into 3 troublesome issues that can cause runtime errors and slow performance. If you...
Read More

Successful MySQL/MariaDB Backup and Recovery Strategies

Database administration, MySQL

A vital part of preventing any kind of data loss in any situation is having appropriate backup and...
Read More
Close