What is SQL Server Express? Definition, Benefits and Capabilities
SQL Server Express is a free lightweight edition of SQL Server with limited functionality,...
Understanding of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases. And it might seem strange, but many users...
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, day-month-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...
