Tag: sql server

How to Use Array Functionality in SQL Server

Database administration, Work with data

Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to...
Read More

SQL AVG Function: A Complete Guide

Database development, Statements

In mathematics, the Average value represents the middle value that we calculate by dividing the sum of all values by the number of values....
Read More

Creating the Date Table in Power BI Desktop Using DAX Function

Business intelligence, Power BI

The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use...
Read More

SQL Server TRIM, LTRIM, and RTRIM Functions

Database development, Statements

The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a...
Read More

SQL Server Business Intelligence Explained: Tools, Techniques and Trends

Business intelligence, Power BI

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data...
Read More

SQL Date Format: How to Handle It the Smart Way

Database administration, Work with data

Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
Read More

SQL CASE: Know and Avoid 3 Lesser-Known Hassles

Database development, Statements

SQL CASE? Piece of cake! Really? Not until you bump into 3 troublesome issues that can cause...
Read More

Basics of SQL Server Transaction Log

Database administration, 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...
Read More

SQL Server BIT Datatype – Ultimate Guide

Database administration, Work with data

Introduction to Bit Data Type The data type represents an attribute that stores integer, character, data time, binary data. Suppose you...
Read More

9 Best Practices for Writing SQL Queries

Database administration, Database development, MySQL, Oracle, Performance Tuning, PostgreSQL, SQL Server, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to...
Read More
Close