SQL Server 2008 Book Recommendation

tpatt100

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.

N2IT

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.