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 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

SQL Server Limit Results

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

Primary Keys in SQL Server

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

The Importance of SQL Server Data Tools (SSDT)

Database administation, Tools & technologies, Work with data

Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we...
Read More

SQL Server System Databases – Restore System Databases

Database administation, Database Optimization & Structure

In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that...
Read More

SQL Server System Databases – MSDB Maintenance

Database administation, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System...
Read More
Close