If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...
2019-11-26 (first published: 2019-11-18)
1,022 reads
Event notifications are kinda like a trigger in the sense that they respond to specific event, specifically in response to DDL statements and SQL Trace events.
The major difference between...
2019-11-21 (first published: 2019-11-13)
929 reads
I am in a situation where I have to incorporate SQL Server Agent alerts in my monitoring and alerting strategy.I needed a query (DMV) to get details on what...
2019-11-18 (first published: 2019-11-07)
661 reads
If you are new at your job or a new client you would like to gather and review the sql server meta data to understand the environment and get...
2019-08-01 (first published: 2019-07-10)
635 reads
At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...
2019-07-18 (first published: 2019-07-03)
13,944 reads