Allow A User To Modify Any Job

I ran into a problem today with permissions and jobs. As I’ve mentioned previously, I’m in the middle of auditing access rights on our SQL Servers and removing unnecessary sa rights from logins that don’t need them. In our shop, we have developers who build SSIS package and schedule them to run on our production […]

Who Can Get The DBA Fired Report

So there you are, sitting at your desk, idly clicking in SSMS, admiring your little kingdom of SQL Servers. Everything looks good. Jobs are running correctly. No performance problems to be seen. Everything is humming along smoothly. It’s tempting to relax a little and perhaps take some time to peruse a few blogs or check […]