My company is heavily dependant on SQL Server transactional replication and once in awhile the default alerts are not sufficient and sometimes we want to be able to disable alerts when we perform maintenance. In this tip I will show you a few scripts I have implemented to allow me to better manage our transactional replication.  Read more...

It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.  Read more...

A methodology is described to bring out the best in database monitoring through System Center Operations Manager 2007 customization.  Read more...

When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?  Read more...

This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.  Read more...