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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-03-16 : 21:16:30
|
| I have been asked to analyze a DB which was under a different team. I have done the following, 1. Identified tables without PK, and clustered index 2. identified FK’s without index3. orphan users and weak passwords4. analyzed SPS for bad codeIs there anything else I can do? Are there any ready-made scripts which I can use. ------------------------I think, therefore I am - Rene Descartes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 22:44:03
|
| How do you know there's weak password by checking db? Did you see any db maintenance job? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-16 : 23:59:00
|
| what about the normalization of tables in database? |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-17 : 10:28:29
|
quote:
Originally posted by rmiao
How do you know there's weak password by checking db? Did you see any db maintenance job?
We have a proprietary reporting tool which identifies the weak passwords. I don’t know that sql for that…------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 23:12:37
|
| Sql login's password is encrypted in master db, not sure how does your tool to check it. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-18 : 04:50:07
|
| The Microsoft Baseline Analyzer is a useful tool to analyse weak or null passwordsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
DB Analyze