Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage
Let’s imagine you have a large raw file and need to determine the best way to load it into an...
LINQ in C#: A tutorial with Query Examples in LINQ to Objects
Less is more – this is definitely true when it comes to object collections and LINQ queries. One of the most valuable advantages is the...
Create and Use Custom Date Hierarchies in Power BI
Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the...
Creating the Date Table in Power BI Desktop Using DAX Function
The time intelligence functions for the data models or databases running behind a Power BI report...
How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent
What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face numerous challenges, but the most...
SQL Server TRIM, LTRIM, and RTRIM Functions
The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a character string. A leading space is...
SQL Server Business Intelligence Explained: Tools, Techniques and Trends
In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts...
SQL Date Format: How to Handle It the Smart Way
Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
SQL CASE: Know and Avoid 3 Lesser-Known Hassles
SQL CASE? Piece of cake! Really? Not until you bump into 3 troublesome issues that can cause runtime errors and slow performance. If you...
Successful MySQL/MariaDB Backup and Recovery Strategies
A vital part of preventing any kind of data loss in any situation is having appropriate backup and...