Options
SQL Server 2008 Book Recommendation
I was wondering if anybody had a decent book for somebody that has to audit SQL Server 2008?
We are preparing for an audit for SOX compliance so all the stuff I recommended previously is finally moving forward but due to the financial auditing I realize I know almost nothing about SQL Server. I can do the stuff for Windows Server 2008 but SQL, it's all Greek to me.
I don't have to admin the SQL servers but I can't audit what I don't know how to use so I will have to crash course learning the administration side. I need to learn all the terminology for SQL like tables, DDL, DML, etc.
We are using (management bought it without input from me /mad) something called Idera SQL Compliance Manager. I can't use just the default reports it creates I need to create alerts to isolate some stuff for specific tables so I have to prioritize what is tracked to avoid creating big alert files nobody wants to look at. So there is the security aspect of SQL I need to learn.
Thanks for any suggestions.
We are preparing for an audit for SOX compliance so all the stuff I recommended previously is finally moving forward but due to the financial auditing I realize I know almost nothing about SQL Server. I can do the stuff for Windows Server 2008 but SQL, it's all Greek to me.
I don't have to admin the SQL servers but I can't audit what I don't know how to use so I will have to crash course learning the administration side. I need to learn all the terminology for SQL like tables, DDL, DML, etc.
We are using (management bought it without input from me /mad) something called Idera SQL Compliance Manager. I can't use just the default reports it creates I need to create alerts to isolate some stuff for specific tables so I have to prioritize what is tracked to avoid creating big alert files nobody wants to look at. So there is the security aspect of SQL I need to learn.
Thanks for any suggestions.
Comments
-
Options
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
I would Google around for some system scripts (tables and objects). Lot's of good scripts already written that can go against any MS SQL server. These can find if passwords are hashed and if users have the correct access. Such as if Debbie in accounting has full admin access. There is a user accounts table that you can script against to see all users and what access and objects they have access too.
Here is a book I used it was free at work so....
Beginning Microsoft SQL Server 2008 Administration: Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger: 9780470440919: Amazon.com: Books
You may also think about swinging on over the DBFORUMS. Celko and other founding fathers of SQL as we know it today visit and will answer well crafted questions.
*** Specific tables related to your schema will require a well thought out strategy.
It really comes down to your requirements and what you are hoping to achieve. -
Options
tpatt100
Member Posts: 2,991 ■■■■■■■■■□
dBforums – Everything on Databases, Design, Developers and Administrators This one? I will bookmark it and wait until I dig into a book first so if I have any questions I can get straight to the point. Thank you for suggesting some scripts also.