Monitoring the status of SQL server jobs is very important. If there is corrupted SQL Server agent, then jobs would not run as scheduled. So make sure you repair corrupted SQL Server before proceeding. Auto identifying operator and adding it to job...
Read more »When working in a very large SQL Server environment, it is very common that no one in the organization knows who uses a particular database. This scenario is very common if there are multiple legacy systems. Follow this article to identify how...
Read more »In this article we look at the vulnerabilities associated with enabling SQL Mail and look at ways to work around such security issues For SQL users, enabling an email database for replying to database queries is possible, since queries are...
Read more »