Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlgirl
Starting Member
1 Post |
 Posted - 2003-02-04 : 11:08:21
|
| I have just started my first DBA job and have been asked by my boss to do an audit of the SQL Server environment. What should I be looking for. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-04 : 11:53:50
|
| Well it depends on what kind of audit he wants. Does he want a security audit? If so, you need to take a look at how the application connects, how developers connect, etc... Then you need to come up with recommendations as to what they need to change in order for the enrivonment to be secure. If he wants you to do an audit of the objects to determine if people are using best practices, then you are going to have to go through each object and determine what should be changed. So, what kind of audit does your boss want you to do? |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-02-04 : 14:10:12
|
| As a start, the SQL2000 Resource kit has a collection of admin stored procedures to audit a SQL environment that can be quite useful.HTHJasper Smith |
|
|
|
sqlnerd
Starting Member
3 Posts |
Posted - 2003-02-04 : 15:08:14
|
| the sql server operations guide freely available from microsoft also outlines some pretty awesome things.see my thread about the run book too.. perhaps you can participate. it will no doubt be helpful to you. |
|
|
|
|
|
|
SQL Server environment