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.

The Importance of SQL Server Data Tools (SSDT)

Database administration, 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

Database administration, 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

MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management

Database administration, 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

TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database

Database administration, 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

Database administration, 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

Database administration, Performance 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

Database administration, Transaction Log, Troubleshooting Issues

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

SQL Server Transactional Replication Configuration

Database administration, SQL Server, Transaction Log

Transactional Replication in SQL Server is one of the most commonly used Replication techniques to copy or distribute data across multiple...
Read More

SQL Server Transactional Replication Internals

Database administration, Transaction Log

SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple...
Read More
Close