The Tutorial Guide to SQL Server DROP TABLE Statement
The SQL DROP statement is a command that deletes existing database components or the entire...
Install and Configure XAMPP Software on Windows Server 2019
XAMPP is a cross-platform web server used to develop and test programs and web applications, created by the Apache friends organization....
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
SQL Server COUNT Function
COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers...
SQL Server Configuration Manager
Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by default with SQL Server Installation to...
Stored Procedure to Get Logins and Server Roles Inventory
Security is for sure one of the most important areas that we, as professional DBAs, must cover. Within SQL Server, there are many...
Large-Sized Database Management System: Design and Architect
A Database Management System is the information’s strongbox. We will attempt to design the...
SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection
Using Structured Query Language (SQL) can seem complicated at first, but further, it will become easier and much more convenient. You only...
SQL JOINs Tutorial with Examples
In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax,...
SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event...
