All In One SQL Server Security Audit Script

Bhuvanesh
SqlAdmin
Published in
1 min readJun 3, 2017

As a DBA, Secure my SQL server is a pretty important part. Generally Security in the sense most of us point to users and their weak passwords. But apart from user accounts there are some critical parts are also there.

Instead of google it and execute all the queries which are found in many blogs and combine all the reports together is not a feasible way, So I have been taken a list of security checklist and prepared a Tsql script to check all the loopholes in the SQL Server.

THIS POST HAS BEEN MOVED TO MY OWN BLOG

--

--