July 13, 2016 at 6:35 pm
In response to the original question...
I see changes on production servers from the following groups of people:
1. Help Desk
2. Developers
3. DBAs
4. Managers (folks that think they are technical and just turning knobs because the knob is there)
5. Vendors
6. sysops folks
What kinds of changes:
1. Schema
2. Procs
3. functions
4. views
5. maintenance routines
6. permissions
7. server settings
8. New databases
9. new instances (same server)
10. anything that can be changed that they know about
11. changes to remove tempdb files after they have been properly set
Despite controls and/or change control being in effect, I find a lot of clients need a lot of auditing to figure who is changing what and when are they changing it. I have seen all sorts of changes being made and clients are always wondering how and why. What they tend to forget is everybody has access and they need to clamp down controls or audit all changes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply