We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from a comment on twitter. The challenge […]
T-SQL Tuesday #17 – APPLY Knowledge
Tag: Security
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the job associated with the maintenance plan. […]
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find out who is a member of […]
IP and Default Trace…T-SQL Tuesday #005
When it is necessary to provide reports on activity occurring on the server, it pays to do a little prep work. Be Prepared. It is not an easy task to be able to go back in time and report on data that isn’t captured. The little prep work that one may need to do is well worth the effort in the end.
Security Audit
This article demonstrates a script that will generate a nice html report of your database security suitable for the auditors.