Database development

SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro

Database development, Statements

Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And...
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
Read More

SQL GROUP BY- 3 Easy Tips to Group Results Like a Pro

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
Read More

Install and Configure XAMPP Software on Windows Server 2019

Database development, Tools & technologies

XAMPP is a cross-platform web server used to develop and test programs and web applications,...
Read More

How to Make the Best Use of Comment Function in MySQL

Database development, Statements

Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
Read More

WhoIsActive Runner

Database development, Stored Procedures

Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very least have heard of, the famous stored...
Read More

Guide for CTE in SQL Server

Database development, Tables

The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...
Read More

Different Ways to View Tables in MySQL Server

Database development, Tables

There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying the Information_schema.tables table. In...
Read More

SQL Server ROUND() Function: What It’s For and Why Should You Care?

Database development, Statements

SQL is a programming language used to create, read, update, and delete databases. It has one of the most popular functions for rounding...
Read More

SQL AS: Usage, Examples, and How it Can Benefit You Best

Database development, Statements

What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a...
Read More
Close