Provisioning an Oracle Autonomous Database
Let’s assume that you are developing a data warehouse project, and your team needs the...
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 Oracle Autonomous Data Warehouse...
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...
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 are really helpful. To make the most use...
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...
SQL Server Business Intelligence Explained: Tools, Techniques and Trends
In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data...
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...
