How to Use Array Functionality in SQL Server
Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to...
SQL AVG Function: A Complete Guide
In mathematics, the Average value represents the middle value that we calculate by dividing the sum of all values by the number of values....
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...
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...
Basics of SQL Server Transaction Log
What is a Transaction Log? There is a requirement in relational database systems that transactions must be durable. This is “D” in the...
SQL Server BIT Datatype – Ultimate Guide
Introduction to Bit Data Type The data type represents an attribute that stores integer, character, data time, binary data. Suppose you...
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to...