TSQL to get all logins’ permissions

We had a request from one customer where he wanted to have a visual representation of all the logins present in the SQL instance and the kind of server lever and database level permissions they have in one result set. I searched the net for solutions but could either find a script that gave either … Read more

Read SQL Server Error logs effectively

SQL Server Error Logs

As a DBA, how often we check SQL error logs. I would say Mutiple times in a single day. And how many of us really know who to check and read the error logs effectively.