Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases....
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 store values in an array in SQL Server....
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...
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 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...
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...
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,...
