Monthly Archives: June 2010

Replication Agents

A common question that comes up is where the Replication Agents reside in a typical replication scenario. There is a lot of information about this everywhere, including MSDN. However, I am a visual person who understands diagrams more than pages … Continue reading

Posted in Uncategorized | Leave a comment

Setting Transaction Log alerts

The other day, one of our developers (who’s preparing to be a DBA, by the way– whoo!) asked me how to set up an alert if the transaction log grows alarmingly. Now I searched SQL Server Agent>Alerts inside SQL Server … Continue reading

Posted in Transaction Logs | Leave a comment

SQL Query Tuning

SQL Query Tuning ppt Hello everyone, Some time back I made a couple of presentations about SQL Server Query Tuning, mostly for SQL Server 2005 and applicable to SQL Server 2008. Later, I felt that sharing this information would benefit … Continue reading

Posted in Uncategorized | Leave a comment