Author Archives: uday arumilli

SQL SERVER ARCHITECTURE

For more details you can check the link: Here are the full details on SQL Server Architecture

Posted in Database Design | Tagged , , , , | Leave a comment

Real Time Example for SSIS Transformations

Real Time Example for SSIS Transformations Introduction: List of 28 Transformations are as follows S No Transformation Real Time Examples 1 Aggregate Summing / Averaging a total of the products purchased by a customer online to produce the final amount. … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , | Leave a comment

How To Monitor Replication in SQL Server

How To Monitor Replication in SQL Server   This post takes you through the T-SQL script How to Monitor Replication in SQL Server. Usually we need to monitor replication periodically through out the day. I have designed a solution to … Continue reading

Posted in High Availability, SQL Scripts | Tagged , , , , , , , , , | 4 Comments