Database development

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

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...
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 supported SQL Server JOIN types with syntax,...
Read More

SQL Server Triggers – Part 2 DDL & LOGON Triggers

Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event...
Read More

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

What is SQL Server? (Definition, Versions, Editions)

Database administation, Database development

Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit...
Read More
Close