Database development

GROUP BY in SQL Server: 3 Easy Examples to Group Results

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
Read More

How to Comment MySQL Code: Best Practices

Database development, MySQL, 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

How to Use the sp_whoisactive PowerShell Script for Real-Time SQL Server Monitoring

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

How to SHOW or LIST Tables in MySQL

Database development, MySQL, Tables

There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both....
Read More

How to Use a ROUND Function in SQL Server

Database development, Statements

The ROUND function in SQL Server is a powerful tool that allows you to round numeric values to a specific number of decimal places. This...
Read More

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

Database development, SQL Server, Statements

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

How to Get SQL Server Statistics Information Using System Statistical Functions

Database administation, Database development, Database Optimization & Structure, Stored Procedures

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
Read More

SQL Server RAISERROR Statement with Simple Examples

Database administation, Database development, Stored Procedures, Troubleshooting Issues

The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
Read More

Stored Procedure to Delete Duplicate Records in SQL Table

Database development, Stored Procedures, Tables

Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
Read More