Database development

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized...
Read More

The Tutorial Guide to SQL Server DROP TABLE Statement

Database development, Statements

The SQL DROP statement is a command that deletes existing database components or the entire databases with all their data permanently....
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, created by the Apache friends organization....
Read More

Exploring SQL Server LEN() Function

Database development, SQL Server, Statements

SQL Server supports different data types to store relevant data in SQL tables. These data types can...
Read More

SQL Server COUNT Function

Database development, Statements

COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers for their day-to-day needs. In this...
Read More

SQL Server Configuration Manager

Database development

Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by default with SQL Server Installation to...
Read More

Stored Procedure to Get Logins and Server Roles Inventory

Database development, Stored Procedures

Security is for sure one of the most important areas that we, as professional DBAs, must cover....
Read More

Large-Sized Database Management System: Design and Architect

Database development

A Database Management System is the information’s strongbox. We will attempt to design the Database Management System so that the...
Read More

SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
Read More

SQL JOINs Tutorial with Examples

Database development, Statements

In this article, we are going to takes a close look at SQL Server JOINs. We will review all...
Read More
Close