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 Triggers – Part 2 DDL & LOGON Triggers

14:26 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

11:20 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

Overview of SQL Server Data Tools (SSDT) Features

11:33 Database administation, Database Optimization & Structure

SQL Server provides SQL Server developers and administrators with dedicated client tools for day-to-day usage. Namely, they are SQL Server...
Read More

The Importance of SQL Server Data Tools (SSDT)

07:56 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...
Read More

SQL Server System Databases – Restore System Databases

12:15 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

09:17 Database administation, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System Databases that are installed by default...
Read More

SQL Server System Databases – the Tempdb Maintenance

12:37 Database administation, Database Optimization & Structure

In my previous article about SQL Server System Databases, we learned about each system database...
Read More

SQL Server System Databases Maintenance

11:00 Database administation, Database Optimization & Structure

SQL Server Installation by default creates several system databases per instance to maintain and administer that instance. In this article,...
Read More

SQL Server Transactional Replication Issues

10:15 Database administation, Perfomance Tuning, Transaction Log, Troubleshooting Issues

We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
Read More

Troubleshooting SQL Server Transactional Replication Issues

12:53 Database administation, Transaction Log, Troubleshooting Issues

SQL Server Transactional Replication is one of the most common Replication techniques used to copy...
Read More
Close