Author: Raja Jegan

Raja Jegan Ramesh is an experienced Database Architect with more than 15+ years of experience in and around various RDBMS technologies. Primarily focused on SQL Server and related areas, he handles other RDBMS platforms like Oracle, MySQL, etc., in his day to day work. During his spare time, he contributes in Experts-Exchange platform to help resolve day to day issues for several people which helps him encounter lot of scenarios related to SQL Server and how to handle those efficiently by working with other SQL Server experts as well.

SQL Server Unique Constraints

Uncategorized

In SQL Server, constraints are certain rules that can enforce data integrity on database tables. In...
Read More

SQL Server Synonyms

Uncategorized

An SQL Server Synonym is a special database object used to an alias or alternative name for an existing object within the local server...
Read More

SQL Server PIVOT Operator

Uncategorized

In SQL Server, PIVOT is a powerful operator to transpose table values in the rows format to table values in column format. In this article,...
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...
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

How to limit rows in SQL Server

Uncategorized

While executing SELECT queries on tables containing huge records, developers often need to limit the number of records being fetched out to...
Read More

SQL Server Primary Key

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the...
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 happens on the database or server....
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

SSDT (SQL Server Data Tools) for Visual Studio: Main Features

Database administation, Database Optimization & Structure

SQL Server provides SQL Server developers and administrators with dedicated client tools for...
Read More
Close